

In the Targets section, I changed the Connection to the oracle one i created already. In the Sources section, I found the value in Connections is another Relational name other than “”ODBC_INFORMIX”” ,So i changed it back. In the Relational Connection Editor window:ĭouble click the session i created just now, go to Mapping tab. In the Source Analyzer and Target Designer, I can import tables from the ODBC data source which i just created.Ĭlick Connections->Relational I select ODBC, press “”Add”” On the IBM Informix ODBC Driver Setup dialogĪnd press button “”Apply& Test Connection””, it prompt “”Test connection was successful””.

LD_LIBRARY_PATH=$INFORMIXDIR/lib:$INFORMIXDIR/lib/cli:$INFORMIXDIR/lib/esql:$LD_LIBRARY_PATH Stty erase “”^H”” kill “”^U”” intr “”^C”” eof “”^D””Įxport PATH=$ORACLE_HOME/bin:$DMEXPRESS_HOME/bin:$PATHĮxport LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:$ORACLE_HOME/rdbms/lib:$DMEXPRESS_HOME/libĮxport SHLIB_PATH=$ORACLE_HOME/lib32:$ORACLE_HOME/rdbms/lib32Įxport CLASSPATH=$ORACLE_HOME/jre:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib:$ORACLE_HOME/network/jlib:$ORACLE_HOME/jdbc/lib/classes12.zipĮxport NLS_LANG=AMERICAN_AMERICA.ZHS16GBK profile file (/usr/bin/sh initialization). uncomment the below line for UNICODE connection Define ODBC Database Driver’s Below – Driver Configuration Sectionĭriver=/info/informix/lib/cli/iclis09b.slĭriver=/oradata/informatica/ODBC5.2/lib/DWor822.sl Oracle=DataDirect 5.2 Oracle Wire Protocol


here is my work enviroment:ģ.Informatica 8.6(download from oracle website,installed by user oracle)ġ.install informix client SDK(2.9) on hp uxĢ.install informix client SDK(2.9) on xp laptop ] ] ] ] ] [[File:IBM_ODBC_Driver_for_Windows_7.Now I want to make a transformation from Informix to Oracle. Also, you must have administrator privileges in order to extract it using IZArc. Note: you should not extract the package using IZArc. After extraction, you should have a folder named in. Installation: Start by downloading and saving the link to the correct installation package (follow the links in this paragraph). Major differences: The differences between Informix and SQL Server driver installation packages are: However, we provide an automatic installation package which installs all required components automatically in one go! The following paragraphs will guide you through this process. Often, installing drivers is not easy and it might take a long time and require that you reboot your system before they will work properly. Introduction: If you’ve ever used Informix before, you know how frustrating it can be not to have direct access to your database from an application on Windows because of a lack of drivers. Ibm Informix Odbc Driver Download Windows 7 64 Bitħ20c5d9bec 18 This article provides download and installation instructions for the IBM Informix ODBC Driver for Microsoft Windows 7.
