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

Neil Truby wrote: > 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? Am can use entreprise gateway manager? Or sql dts? -- Enor

Neil Truby wrote: > 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 > > Informix Gateway Manager allows ODBC connections. It would be set up fairly similar to how your environment already is - synonyms and remote databases. It doesn't say ODBC is supported on the web site http://www-306.ibm.com/software/data/informix/tools/egm/ but it does mention it in the manual and I know I've implemented it before. -- Rob Wilson rob_wilson_at_ameritech.net (replace _at_ with @)