Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.4K Intelligent Advisor
- 75 Insurance
- 537.7K On-Premises Infrastructure
- 138.7K Analytics Software
- 38.6K Application Development Software
- 6.1K Cloud Platform
- 109.6K Database Software
- 17.6K Enterprise Manager
- 8.8K Hardware
- 71.3K Infrastructure Software
- 105.4K Integration
- 41.6K Security Software
OBIEE to DB2 AS400 connectivity

user641186
Member Posts: 6
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
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
Tagged:
Answers
-
Hi all,First off, have you read the installation docs?
it is not clear to me how to set up the connection to a DB2 on AS400 database.
http://download.oracle.com/docs/cd/E10415_01/doc/nav/portal_booklist.htmUsing BI Administrator, on the Physical layer, when I use "New Database" functionalityThis should be the database you're using. What you set here defines what DB-specific functionality OBIEE will use. If you put something incorrect or generic you'll get at best worse performance and at worst errors as OBIEE asks your DB to do something it doesn't support.
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,I would have thought native DB2 CLI would be more suitable
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)Erm. The datasource name, and your username and password for the tables you're getting data from?
This discussion has been closed.