Question:
I’m curious if you or anyone else has successfully created a data warehouse in SQL Server 7.0, using DTS to import/extract info from Informix, running Elite time/billing application?
Answer:
Haven’t seen it, but it should be workable. SQL 7.0 is a good database and has very sophisticated ROLAP analysis capability. I have had a client extract from S2 Systems’ CRM:2000 package into a SQL 7.0 database for ROLAP. Worked like a charm. I’m not sure about DTS. My client used ODBC to connect the two databases.
Charlie has over a decade of experience in website administration and technology management. As the site admin, he oversees all technical aspects of running a high-traffic online platform, ensuring optimal performance, security, and user experience.
