Sunday, March 11, 2012

Accesing information from an Informix database

Hi,

I d like to know if there is any way to access an Informix database from sqlserver 2005.

We are trying to build a data warehouse in SS2005, and I want to know If I could avoid the generation of hundreds of flats files from Informix and loading them into SS2005, directly recovering all information from SS2005 across any kind of migration or connection.

Any help would be very appreciated

Regards.We access an Informix database from SQLSVR 2000 via an ODBC connection using a driver named MERANT 3.50 32-BIT INFORMIX.|||That's the way we do it as well. ODBC connection, linked server ... start moving the data !

Gr,
Yveau

No comments:

Post a Comment