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.  (http://download.oracle.com/otn/java/sqldeveloper/sqldeveloper-17.4.0.355.2349-x64.zip)

 

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
Business Objects BI / Visualization Connecting to the Oracle Autonomous Data Warehouse using an Oracle Wallet
Cognos BI / Visualization Use IBM JCE Unlimited Strength Policy files
DataDirect Driver Configure Data Direct ODBC driver to connect to Oracle Autonomous Data Warehouse
Data Virtuality Pipes Data Movement Moving data into Oracle Autonomous Data Warehouse
Data Virtuality Platform Data Movement Moving data into Oracle Autonomous Data Warehouse
Domo Data Movement
BI / Visualization
Connecting Domo to Oracle Autonomous Data Warehouse
IBM DataStage Data Movement Connecting to Oracle Autonomous Data Warehouse using Progress DataDirect ODBC driver
Informatica Powercenter Data Movement Creating a connection from Informatica PowerCenter 9.6 to Oracle Autonomous Data Warehouse
Looker BI / Visualization Creating a connection from Looker to Oracle Autonomous Data Warehouse
Microsoft Power BI BI / Visualization Creating a connection from Microsoft Power BI Desktop to Oracle Autonomous Data Warehouse
MicroStrategy BI / Visualization Creating a connection from MicroStrategy to Oracle Autonomous Data Warehouse
Qlik Sense Desktop BI / Visualization Creating a connection from Qlik to Oracle Autonomous Data Warehouse
Qlik Sense Server BI / Visualization Creating a connection from Qlik to Oracle Autonomous Data Warehouse
SAS Access BI / Visualization Creating a connection from SAS/ACCESS to Oracle Autonomous Data Warehouse
Simba Driver Creating a connection using Simba ODBC Drivers to Oracle Autonomous Data Warehouse
Tableau Desktop BI / Visualization Creating a connection from Tableau to Oracle Autonomous Data Warehouse
Tableau Server BI / Visualization Creating a connection from Tableau to Oracle Autonomous Data Warehouse
Talend Data Movement Creating a connection from Talend ETL Tool to Oracle Autonomous Data Warehouse
WanDisco Data Movement How to integrate object storage data buckets managed with WANDISCO FUSION with LiveS3 as staging area for Oracle Autonomous Data Warehouse
×
Call us now
1-800-633-0738 (United States)

Contact
×
Call us now
1-800-633-0738 (United States)

Technical Support

Oracle Cloud Discussion Forums