Re: Extracting data from a SQL Server database

Hi Rob, Neil The Enterprise Gateway Manager uses ODBC to access other RDBMS like SQLServer, Oracle etc. Let me know if you need more information. I work on the development team for this product. Thanks, -Manas --- Rob Wilson <rob_wilson_at_@ameritech.net> wrote: > 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 @) __________________________________ Do you Yahoo!? Win a $20,000 Career Makeover at Yahoo! HotJobs http://hotjobs.sweepstakes.yahoo.com/careermakeover sending to informix-list

"Manas Dadarkar" <catchmanas@yahoo.com> wrote in message news:c79k4k$bm$1@terabinaries.xmission.com... > > Hi Rob, Neil > The Enterprise Gateway Manager uses ODBC to access > other RDBMS like SQLServer, Oracle etc. > Let me know if you need more information. I work on > the development team for this product. > > Thanks, > -Manas Thanks Manas. We may get an eval for the client if our distributor has it. The '6.5k price tag may deter if there is also freeware available.