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

Question

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?

Answer 1

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 -

• Create a DSN for DB2 database. Go to Start > Administrative Tools > Data Sources(ODBC) > System DSN > Add.
• When Dialog box shows up, choose DataDirect xx.xx DB2 Wire Protocol. Where xx.xx is driver version and depend on infa vesion. Give a proper DSN name, DB host, port, DB Name Security selection may cause issue so try different options
• Open informatica designer. GO to source > Import from database. Then select the DSN and provide user/password to login. Pretty standard process to import sources.

enter image description here