Oracle Analytics Cloud and Server Idea Lab

Home› Oracle Analytics› Oracle Analytics Idea Labs› Oracle Analytics Cloud and Server Idea Lab

Categories

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

PostgreSQL(12.X,13.X) Datasource compatability with Oracle Analytics Server(5.9 & 6.4).

Needs Votes
545
Views
7
Comments
sivaraman-Oracle
sivaraman-Oracle Rank 1 - Community Starter
in Oracle Analytics Cloud and Server Idea Lab

Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Vertex Pharmaceuticals Inc


Description (Required):

Customer would like to have PostgreSQL version (12.x/13.x) as one of the supported datasource for Oracle Analytics Server(5.9 & 6.4),since the current PostgreSQL version(9.6) which is used as datasource is vulnerable and going to be out of support. They are currently using PostgreSQL 9.6 as datasource for OBIEE 12.2.1.4. As per the certification matrix for OAS, only PostgreSQL 9.x and its minor versions are certified for Oracle Analytics Server.



Use Case and Business Need (Required):

Current PostgreSQL version(9.6) which is used as datasource by the Customer is vulnerable and going to be out of support.

1 - OAS : https://docs.oracle.com/en/middleware/bi/analytics-server/administer-oas/certification-supported-data-sources.html

2 - OBIEE 12.2.1.4: https://www.oracle.com/docs/tech/middleware/obiee-122140-certmatrix.xlsx

Enhancement Request / Service Request: 3-29500330611

Tagged:
3
Up
3 votes

Needs Votes · Last Updated

Comments

  • Michal Zima
    Michal Zima Rank 6 - Analytics Lead

    @sivaraman-Oracle . If you check certification matrix for OAS correctly, you can see plus sign after version of PostgresSQL : 9.0+ - this means, that versions 9 and higher are certified. This is how it should be interpreted. But better to have it confirmed by somebody directly from Oracle.

  • BalaGuddeti-Oracle
    BalaGuddeti-Oracle Rank 5 - Community Champion

    PostgresSQL : 9.0+ - this means 9.0, 9.1, 9.2 or 9.1.1 etc.. 9.x supported.

    PostgreSQL version (12.x/13.x) yet to be certified. However, not being certified does not mean not being supported.


    Thanks,

    Bala Guddeti

    Bala Guddeti

    Principal Analytics Technologist

    https://www.linkedin.com/in/balaguddeti-oracledataintelligence/

  • User_MD80A
    User_MD80A Rank 1 - Community Starter

    Hi ,

    Please let me know if any one tried connecting OBIEE to postgres higher versions like 12.x or 13.x.

  • User_MD80A
    User_MD80A Rank 1 - Community Starter

    Hi Team,

    Prioritize the task as the postgres 9.x has reached end of support.

  • User_MD80A
    User_MD80A Rank 1 - Community Starter

    Hi Oracle Team,

    OBIEE (12.2.1.4) has extended the EOL till 2025.

    Postgres 9.x has reached end of life and is vulnerable.

    Postgres 11.x end of life is Nov-2023.

    Did Oracle development team get a change to work on certifying the Postgres database higher versions?

    Thanks,

    Sanjay

  • User_MD80A
    User_MD80A Rank 1 - Community Starter

    Hi Oracle Team,

     Oracle extend the End of Support for OBIEE 12.2.1.4 till 31-Dec-2025. The Postgres supported version in the certificate matrix is 9.x. The 9.x Postgres version already reached End of Support in Nov-2022.

     We had connected with the Oracle Development team and they have suggested to use the Postgres 11.x version as the version uses the same set of Drivers as 9.x. Now, the Postgres version 11.x reaching end of support in Nov-2023.

     What all the available options to upgrade the Postgres as the Postgres is not extending the End of Support.

     Will Oracle will certify the Postgres latest version 12.x or 13.x with the OBIEE Application(12.2.1.4) or OAS 6.4

  • Kakuta
    Kakuta Rank 2 - Community Beginner

    Hi Oracle Team,

    How's current status ? Postgres version has already discovered 16.x.

    So, if OAS still support version 9.x only, it is useless for user. Then, when I told this certification info to the application team, they could not cover the disappointment. And they switched other BI solution tool.

    Regards.