The table below lists applications and tools that have been tested and verified to work with Oracle Autonomous Database. In some cases, products have been extended specifically for Autonomous Database. In other cases, such as Oracle GoldenGate, the specific limitations of using a tool with Autonomous Database are documented. In general, analytic tools that are certified with Oracle Database should work successfully with Autonomous Database, whether the tool is on the list or not. For products not listed in this document, please refer to Autonomous Database documentation for connection information.
This table contains the Autonomous Database certification matrix for third-party tools and applications. Please note that owners of third-party products make their own statements regarding product certification and support. Information in this matrix is intended for guidance only. If connecting without a wallet, see oracle-samples.github.io/adb-connectors/common/tls-no-wallet/workshops/freetier/.
| Oracle Product | Version Number | Notes/Links |
|---|---|---|
| Oracle E-Business Suite | Oracle E-Business Suite 12.2.6 and later | Certified with Autonomous Database-Dedicated (PDF) |
| Oracle Peoplesoft | PeopleSoft 9.2, PeopleTools 8.57, 8.58, 8.59 and above | Certified with Autonomous Database-Dedicated and Shared |
| PeopleTools | 8.57.16 and 8.58.05 and above | Certified with Autonomous Database-Dedicated and Shared |
| Siebel CRM | 21.8 | Certified with Oracle Autonomous Transaction Processing through Shared (Autonomous Database-S) or Dedicated (Autonomous Database-D) Infrastructure |
| Oracle JD Edwards | Applications Release 9.2 | Certified with Oracle Autonomous Database on both Dedicated and Shared Exadata Infrastructure on Oracle Cloud Infrastructure - FAQ (PDF) |
| Oracle JD Edwards | Tools Release 9.2.4.3 | Certified with Oracle Autonomous Database on both Dedicated and Shared Exadata Infrastructure on Oracle Cloud Infrastructure - FAQ (PDF) |
| Oracle Product | Version Number | Notes/Links |
|---|---|---|
| dbt | v1.0.6 | Create a connection from dbt to Oracle Autonomous Data Warehouse using Oracle dbt driver |
| Oracle Data Visualization Desktop | 12.2.1.4 or later | Autonomous Database 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 Autonomous Data Warehouse/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 Database 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. |
| Oracle Fusion Middleware | 12c (12.2.1.4.0) | Certified with Oracle Autonomous Database - Dedicated and Shared |