No results found

Your search did not match any results.

Autonomous Data Warehouse Tools and Application Test Matrix

The following tables list tools that have been tested and verified to work with Autonomous Data Warehouse.

In some cases, tools have also been extended specifically for Autonomous Data Warehouse. In other cases, such as Golden Gate, specific limitations of using a tool with Autonomous Data Warehouse have been documented.

In general, any analytic tools that is certified with Oracle Database should work successfully against Autonomous Data Warehouse whether the tool is on this list or not.

For tools not listed in this document, please follow the Autonomous Data Warehouse documentation for connection information.

Oracle BI and Data Integration

Oracle Product Version Number Notes/Links
Oracle Data Visualization Desktop 12.2.1.4 or later Autonomous Data Warehouse connection available is Windows and Mac OS
Oracle Analytics Cloud Any
OAC Data Sync Data Sync is a simple "Data Movement" tool that can load data into ADW/ATP from several files, on-premises and SaaS sources. It leverages the power of the database (ELT) to do row level transformations, post load processing.
It is distributed with OTN license agreement and can be downloaded here. Documentation is available under data load section of Oracle Analytics Cloud Help Documentation.
Oracle Business Intelligence Enterprise Edition 12.2.1.4
Oracle Essbase 12.2.1.1.115 or later Oracle Essbase connection to Autonomous Data Warehouse with the ability to upload wallet files. For more information, watch the demo video and read the blog.
Oracle GoldenGate Cloud Service 18.1.3 or later
Oracle GoldenGate (on-premise) 12.3.0.1.2 or later
Oracle Data Integrator (on premise) 12.2.1.2.6 and 12.2.1.3.0 or later Java Development Kit (JDK) Version 8 Update 161 (8u161) is recommended. Note: Java Development Kit (JDK) Version 8 Update 161 (8u161) eliminates the need to separately install JCE Unlimited Strength Policy Files.
Oracle Data Integration Cloud Service (ODICS) 17.2.1 or later Java Development Kit (JDK) Version 8 Update 161 (8u161) is recommended. Note: Java Development Kit (JDK) Version 8 Update 161 (8u161) eliminates the need to separately install JCE Unlimited Strength Policy Files.
Oracle Data Integration Platform Cloud (DIPC) 17.4.5 or later Java Development Kit (JDK) Version 8 Update 161 (8u161) is recommended. Note: Java Development Kit (JDK) Version 8 Update 161 (8u161) eliminates the need to separately install JCE Unlimited Strength Policy Files.
Oracle SQL Developer 17.4 or later Java Development Kit (JDK) Version 8 Update 161 (8u161) is recommended as it eliminates the need to separately install JCE Unlimited Strength Policy Files. For x64 Windows users, SQL Developer is available with a bundled JRE that includes the required Unlimited Strength Policy Files. Help Documentation.

Third Party Tool Compatibility Matrix

This table contains the Autonomous Data Warehouse certification matrix for third-party tools and applications. Please note that for certification of third party tools and applications, owners of third party products make their own statements regarding product certification and support. Information in this matrix is intended for guidance only.

Product Name Type of Tool Connection Notes
Alteryx Designer BI / Visualization Creating a connection from Alteryx to Oracle Autonomous Data Warehouse (PDF)
SAP BusinessObjects BI / Visualization Connecting to the Oracle Autonomous Data Warehouse using an Oracle Wallet (PDF)
Cognos BI / Visualization Creating a connection from IBM Cognos Analytics server to Oracle Autonomous Data Warehouse (ADW) (PDF)
DataDirect Driver Configure Data Direct ODBC driver to connect to Oracle Autonomous Data Warehouse (PDF)
Data Virtuality Pipes Data Movement Moving data into Oracle Autonomous Data Warehouse (PDF)
Data Virtuality Platform Data Movement Moving data into Oracle Autonomous Data Warehouse (PDF)
DataViz BI / Visualization Creating a connection from SaCa DataViz to Oracle Autonomous Data Warehouse (ADW) (PDF)
Domo Data Movement
BI / Visualization
Connecting Domo to Oracle Autonomous Data Warehouse (PDF)
FlexDeploy DevOps Creating a connection from FlexDeploy to Oracle Autonomous Data Warehouse (ADW) (PDF)
HVR Software Data Movement Creating a connection from HVR to Oracle Autonomous Data Warehouse (PDF)
IBM DataStage Data Movement Connecting to Oracle Autonomous Data Warehouse using Progress DataDirect ODBC driver (PDF)
Informatica Powercenter Data Movement
BI / Visualization
Creating a connection from Informatica PowerCenter 9.6 to Oracle Autonomous Data Warehouse (PDF)
Looker BI / Visualization Creating a connection from Looker to Oracle Autonomous Data Warehouse (PDF)
Microsoft Power BI BI / Visualization Creating a connection from Microsoft Power BI Desktop to Oracle Autonomous Data Warehouse (PDF)
MicroStrategy BI / Visualization Creating a connection from MicroStrategy to Oracle Autonomous Data Warehouse (PDF)
PL/SQL Workbench Utility Creating a connection from PL/SQL Workbench to Oracle Autonomous Data Warehouse (ADW) (PDF)
Qlik Sense Desktop BI / Visualization Creating a connection from Qlik to Oracle Autonomous Data Warehouse (PDF)
Qlik Sense Server BI / Visualization Creating a connection from Qlik to Oracle Autonomous Data Warehouse (PDF)
SAS Access BI / Visualization Creating a connection from SAS/ACCESS to Oracle Autonomous Data Warehouse (PDF)
Simba Driver Creating a connection using Simba ODBC Drivers to Oracle Autonomous Data Warehouse (PDF)
Tableau Desktop BI / Visualization Creating a connection from Tableau to Oracle Autonomous Data Warehouse (PDF)
Tableau Server BI / Visualization Creating a connection from Tableau to Oracle Autonomous Data Warehouse (PDF)
Tableau Online BI / Visualization Creating a connection from Tableau Online to Oracle Autonomous Data Warehouse (PDF)
Talend Data Movement Creating a connection from Talend ETL Tool to Oracle Autonomous Data Warehouse (PDF)
TIBCO Spotfire® BI / Visualization Spotfire Connectivity for Oracle Autonomous Data Warehouse via Information Links Using JDBC with Wallets
WanDisco Data Movement How to integrate object storage data buckets managed with WANDISCO FUSION with LiveS3 as staging area for Oracle Autonomous Data Warehouse (PDF)
WingArc1st MotionBoard BI / Visualization Creating a connection from MotionBoard to Oracle Autonomous Data Warehouse (PDF)