4 Replies Latest reply on Oct 1, 2015 12:12 PM by Stanisa

    OBIEE connection pool

    Stanisa

      I need to take data from DB2 database.

      I have OBIEE 11g 11.1.1.6 on Linux x64.

      In Physical layer I made New Database. Gave to it a name. In Data Source Definition I have chosen ODBC Basic.

      After that I made Connection Pool with Name DB2, Call Interface: ODBC 3.5. I have chose Data Source Name: db2.

      After that I can see metadata from DB2 database.

      In Physical layer when I choose the view data (from imported table) I get the picture saying: Cannot view Data because the Connection Pool is missing the DSN or Username.

      How to setup properly the Connection Pool for accessing the DB2 database?