db2ibm-midrangeinformatica-powercenterinformatica-powerexchange

Powercenter connectivity with DB2 400/AS400 with powercenter running on Windows 2012 r2


My requirement is to import DB2 400/AS400 tables to informatica powercenter. As i'm new to AS4oo db2 connectivity, i came to know that we can establish ODBC connection using "iSeries access ODBC driver".I tried my best in IBM website to download this driver and confused a lot.any help is appreciated here. How to download and install the above mentioned "iSeries access odbc driver". or any other way?


Solution

  • Informatica always provide Datadirect driver for DB2. Now, sometime DB2 version may not be compatible with DD diver. In that case you can ask Informatica corp. for older version or workaround. If you want to import DB2 tables, you have to follow these steps -

    enter image description here