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?
1
votes
The ODBC driver is not available separately. It's part of the older IBM i Access for Windows product or the new IBM i Access Client Solution Talk to your system admin to get the software.
– Charles
@Charles Thank you for the reply. but, is this the correct ODBC Driver which is used to import tables from AS400 DB2 to Informatica Powercenter?
– AyrusTerminal
It should work per Koushik's answer below.
– Charles
"IBM Data Server Client" does this be any help in this aspect?
– AyrusTerminal
No, that's for DB2 LUW. DB2 for i and DB2 for z/OS are different.
– Charles
1 Answers
0
votes
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.
