Connecting securely from Oracle Integration to Autonomous database using network access list by Shreenidhi Raghuram
September 5, 2021 Leave a comment
Introduction
Many integration use cases require the use of Autonomous database (ADB) as the parking lot datastore with Oracle Integration.
Oracle Integration provides various options to connect to ADB. The Oracle integration documentation table below summarizes these options.
* Cloud Database Connectivity Support
Options
In summary,
- Connecting to ADB dedicated instances (ADB-D) and ADB shared private endpoint DB requires an OIC connectivity agent.
- Connecting to ADB Shared infrastructure (ADB-S) database uses JDBC over SSL and provides direct connectivity using wallet.
Note that this mode does not require connectivity agent to be deployed. Oracle integration connects using JDBC over SSL directly to the ADB-S public endpoint in this case.
Use case
Certain organizations’ security requirements or use cases may mandate that the database network traffic should only traverse through a private endpoint within a VCN. These use cases undoubtedly will need to use the ADB dedicated or ADB shared private endpoint databases. Oracle integration requires the connectivity agent to be deployed in the ADB VCN for these modes. Read the complete article here.
For regular information on Oracle PaaS become a member in the PaaS (Integration & Process) Partner Community please register here.
Blog
Twitter
LinkedIn
Facebook
Wiki
Technorati Tags: SOA Community,Oracle SOA,Oracle BPM,OPN,Jürgen Kress