1. Using the Oracle Autonomous Data Warehouse Adapter with Oracle Integration Generation 2
  2. Implement Common Patterns Using the Oracle Autonomous Data Warehouse Adapter
  3. Methods for Connecting Oracle Integration to an Oracle Autonomous Data Warehouse Instance with the Oracle Autonomous Data Warehouse Adapter

Methods for Connecting Oracle Integration to an Oracle Autonomous Data Warehouse Instance with the Oracle Autonomous Data Warehouse Adapter

Connectivity from Oracle Integration to an Oracle Autonomous Data Warehouse database instance using the Oracle Autonomous Data Warehouse Adapter can be accomplished through the following methods.

  • Connectivity agent: Use this approach when the Oracle Autonomous Data Warehouse database instance is not publicly accessible and resides within a private subnet in your Virtual Cloud Network (VCN). With this topology, the Oracle Autonomous Data Warehouse Adapter cannot directly access the Oracle Autonomous Data Warehouse database instance. The connectivity agent must be deployed in your network to allow the connectivity agent access to the Oracle Autonomous Data Warehouse database instance.
  • Direct connectivity: Use this approach when the Oracle Autonomous Data Warehouse database instance is directly accessible from Oracle Integration. In this case, the connectivity agent is not necessary. However, Oracle strongly recommends using Transport Level Security (TLS ) for the communication between Oracle Integration and the Oracle Autonomous Data Warehouse database instance to ensure the data being transmitted is encrypted in motion.