PostgreSQL

You can connect Oracle Analytics to a PostgreSQL database.

Supported Versions

9.0+

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 Identification (SNI) for Transport Level Security (TLS).