Oracle Autonomous Data Warehouse (ADW)

You can connect Oracle Analytics to Oracle Autonomous Data Warehouse (ADW).

Supported Versions

19c and later.

Prerequisites

None.

Connectivity

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

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

Other Connectivity Information

• Use the Oracle Autonomous Data Warehouse connection type.
• Supports resource principal authentication in OCI Identity and Access Management (except when using Oracle Analytics Publisher). See Use Resource Principal to Access Oracle Cloud Infrastructure Resources.
• Supports saving output from data flows.
• Supports incremental refresh for datasets based on this database type. See Configure a Dataset to Load Incrementally.
• For semantic model connections, you can only have one global wallet, therefore you can only connect to one instance.

Useful Documentation Links

• Connect to Oracle Autonomous Data Warehouse.
• You can also connect via Delta Sharing using the Delta Share connection type. See Connect to a Database Using Delta Sharing.
• Manage Connections to Data Sources
• Manage Connections Using REST APIs