Oracle AI Database

You can connect Oracle Analytics to Oracle AI Database.

Supported Versions

12.1+, 12.2+, 19+, 21c, 23ai, 26ai

Prerequisites

Ensure that the appropriate security access rules are in place for Oracle Analytics 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
  • Public*
  • Private
    • 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.

Manual SQL in Oracle Analytics does not support WITH clauses (that is, Common Table Expressions, or CTEs). Queries must be rewritten using inline subqueries, database views, or materialized tables.

Semantic Modeler Yes
  • Public**
  • Private
    • Private access channel
    • Remote data connectivity
 ** For semantic model connections, you can only have one global wallet per semantic model connection.
Model Administration Tool Yes
  • Public
  • Private
    • Private access channel
    • Remote data connectivity
  • System connection
 Use Oracle Call Interface instead of ODBC to connect to Oracle AI Database using Oracle Client Tools, for example, Model Administration Tool.
Oracle Analytics Publisher Yes
  • Public
  • Private
    • 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, Oracle Database, and Oracle AI Database.
  • Supports incremental refresh for datasets based on this database type. See Configure a Dataset to Load Incrementally.

Useful Documentation Links