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		-	-

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

Other Connectivity Information

• 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