OBIEE to DB2 AS400 connectivity
Hi all,
it is not clear to me how to set up the connection to a DB2 on AS400 database.
Using BI Administrator, on the Physical layer, when I use "New Database" functionality
in the "Data source definition section", there is a combo box called "Database":
which option should I choose :
- ODBC Basic (or Advanced) ?
- DB2 AS/400 ?
in this case, when I go to the Connection pool definition,
in the "Call Interface" combo box, which option should I choose:
ODBC (2.5, 3.5) ? or DB2 CLI (Unicode) ?
and which values should I enter in the below fields ? (Data Source Name, User Name, Password)
- should a specific ODBC driver be installed ?
- or should I use one of the Odbc drivers that are installed during OBIEE installation (e.g. MERANT OEM 5.2 32-BIT DB2 Wire Protocol ) ?
Thanks a lot
Silvio