Re: Extracting data from a SQL Server database

Can't you do this with DRDA Gateway? "Neil Truby" <neil.truby@ardenta.com> wrote in message news:<c7871v$sf4o$1@ID-162943.news.uni-berlin.de>... > 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