Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

PostgreSQL DB into OBIEE 11.1.1.9

Received Response
31
Views
2
Comments
Avinash Pentyala
Avinash Pentyala Rank 5 - Community Champion
edited Aug 13, 2024 6:04PM in Oracle Analytics Cloud and Server

Hi Gents,

I have to connect PostgreSQL from OBIEE to using Direct DB Request, please confirm DataDirect Connect ODBC Drivers will support??

otherwise which drivers I have to install?? OBIEE running on Linux box.

Kindly assist me.

Regards,

Avinash

Answers

  • Avinash Pentyala
    Avinash Pentyala Rank 5 - Community Champion

    ODBC driver comes default in OBIEE 11.1.1.9, added following connection in "odbc.ini" file.

    [PostgreSql]

    Driver=/BI/MW/Oracle_BI1/common/ODBC/Merant/7.1.4/lib/ARpsql27.so

    Description=PostgreSql

    HostName=******

    PortNumber=15432

    AlternateServers=

    ConnectionRetryCount=0

    ConnectionRetryDelay=3

    Database=

    LoadBalancing=0

    LogonID=****

    Password=*****

    ReportCodePageConversionErrors=0

    Regards,

    Avinash

  • 2951778
    2951778 Rank 2 - Community Beginner

    How did you configure your connection pool in the RPD. What is the database type used when setting up the database.

    Thanks!