RE: Extracting data from a SQL Server database

here are couple of option that i could think of 1) sqlserver has something called as linked servers where you can link other database like db2, oracle,i think they don't have anything for informix, but you can create a linked server to access an ODBC database using an ODBC data source to connect to the informix database, this way you can extract data from informix database and load it to the sqlserver database using sqlserver routines or DTS packages to pull the data. 2)you can do the extract from the informix 4gl programs and unload to a delimited file, then use the sql server bcp utility to load the delimited file in the sql server database. -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org]On Behalf Of Neil Truby Sent: Tuesday, May 04, 2004 8:44 AM To: informix-list@iiug.org Subject: Extracting data from a SQL Server database My client has a series of 4GL programs that do ETL of data from various Informix sources into a "data mart". It works like this: a 4GL program uses synonyms to extract data from remote live Informix databases and loads the data into a staging database. Another set of 4GLs extract this "staging" data and insert into into the data mart. Now they want to add a new database to the first part: that is, the extraction of the live data. Trouble is, this new database is a SQL Server one. Any opinions on the easiest way to achieve this? thanks Neil Truby t:01932 724027 Director m:07798 811708 Ardenta Limited e:neil.truby@ardenta.com sending to informix-list