Cloud Database Connectivity Support
This table describes cloud database connectivity support in Oracle Integration. Review these capabilities and use the adapter (Oracle Autonomous Transaction Processing Adapter, Oracle Autonomous Data Warehouse Adapter, or Oracle Database Cloud Service Adapter) appropriate to your environment. As with the Oracle Advanced Queuing (AQ) Adapter, different Oracle databases must be certified with all connectivity gateways. The following table demonstrates the combination of databases plus security policy with the cloud, private endpoint, and connectivity agent.
Note:
This table is applicable for both outbound and inbound scenarios.| Database + Policy | Cloud (Public Gateway) | Private Endpoint | Private Endpoint with Host Entry | Connectivity Agent |
|---|---|---|---|---|
|
Oracle Autonomous Transaction Processing (ATP) database/ Oracle Autonomous Data Warehouse (ADW) database with Wallet Security |
Supported |
Supported |
Not Supported Note: The host entry is valid for Basic Authentication. |
Supported |
|
Oracle Database Classic Cloud Service (DBaaS) database with Wallet Security |
Supported |
Supported |
Not Supported Note: The host entry is valid for Basic Authentication. |
Supported |
|
On-premises Oracle database with Wallet Security |
Not Supported Note: On-premises database connection through an agent only. |
Not Supported Note: On-premises database connection through an agent only. |
Not Supported Note: On-premises database connection through an agent only. |
Supported |
|
Oracle Autonomous Transaction Processing (ATP) database/ Oracle Autonomous Data Warehouse (ADW) database with Basic Authentication |
Supported Note: TLS is disabled. |
Supported Note: TLS is disabled. |
Supported Note: TLS is disabled. |
Supported Note: TLS is disabled. |
|
Oracle Database Classic Cloud Service (DBaaS) database with Basic Authentication |
Supported |
Supported |
Supported |
Supported |
|
On-premises Oracle database with Basic Authentication |
Not Supported Note: On-Premises database connection through an agent only. |
Not Supported Note: On-Premises database connection through an agent only. |
Not Supported Note: On-Premises database connection through an agent only. |
Supported |