1. Connecting Oracle Analytics Cloud to Your Data
  2. Reference
  3. Data Sources and Data Types Reference
  4. List of Supported Databases in Oracle Analytics Cloud
  5. Oracle Database

Oracle Database

You can connect Oracle Analytics to an Oracle Database.

Supported Versions

12.1+, 12.2+, 18+, 19+

Prerequisites

Ensure that the appropriate security access rules are in place for Oracle Analytics Cloud to make a network connection to the database service on the database listening port.

Connectivity

Use Data Source With Support Connectivity Options Notes
Datasets Yes
  • Standard*
  • Private access channel
  • Remote Data Connectivity
  • Data access - Live or cache
 * For dataset connections, you can connect to multiple database instances. Upload a wallet for each connection.
Semantic Modeler Yes
  • Standard**
  • Remote Data Connectivity
  • System connection
 ** For semantic model connections, you can only have one global wallet per semantic model connection.
Model Administration Tool Yes
  • Standard
  • Private Access Channel
  • Remote Data Connectivity
  • System connection
 -
Oracle Analytics Publisher Yes
  • Standard
  • Private access channel
 -

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

Other Connectivity Information

  • Supports saving output from data flows.
  • Use the Oracle Database connection type to connect to Oracle Database Classic Cloud Service.
  • Supports incremental refresh for datasets based on this database type. See Configure a Dataset to Load Incrementally.

Useful Documentation Links