PostgreSQL

You can connect Oracle Analytics to a PostgreSQL database.

Supported Versions

9.0+, 13, 14, 15

Prerequisites

None.

Connectivity

Use Data Source With Support Connectivity Options Notes
Datasets Yes
  • Public
  • Private
    • Private access channel
  • Data access - Live or cache
 -
Semantic Modeler Yes
  • Public
  • Private
    • Private access channel
 -
Model Administration Tool Yes
  • Private
    • Private access channel
  • System connection
 -
Oracle Analytics Publisher No

-

 -

For more information about this connectivity table, see Key to Connectivity Information.

Other Connectivity Information

  • Use the PostgreSQL connection type.
  • This connection type doesn't support Server Name Indication (SNI) for Transport Layer Security (TLS).
  • Oracle Analytics doesn't support PostgreSQL databases deployed on the NEON platform.

Useful Documentation Links