Oracle Integration: ICS to OIC Migration with transition to ATP by Michael Meiner
Blog: PaaS Community
Oracle Integration (OIC) has a rich set of capabilities to enable our customers to connect to Oracle databases including on-premise databases and Cloud (DbaaS, ATP). We continue to enhance Oracle Integration to provide additional database connectivity functionality. In the November 2020 release, Oracle Integration offers new functionality for transitioning to an ATP database.
This can be especially important when migrating from Integration Cloud Service (ICS) to Oracle Integration (OIC). As OIC runs on Oracle Cloud Infrastructure (OCI), you might want to also take advantage of ATP which is available in OCI. ICS integration flows which integrate with Oracle Database as a Service (DBaaS) typically use the Database adapter. When migrating such integrations to OIC, the Database adapter will appear in the migrated integrations. This makes uptake of ATP cumbersome, as each integration flow would need to be hand-modified to replace the Database adapter with the ATP adapter.
Integration of ATP using the Database Adapter
In the Oracle Integration November release, it is now possible to integrate such existing integrations with ATP. In prior releases, the only connection option available with the Database adapter was username password token. This security option is not supported by ATP-Serverless. In the November release, there is an additional connectivity option for Oracle Wallet. You can use this option to connect with ATP-Serverless. This allows you to seamlessly replace the DBaaS connections from ICS with ATP-Serverless connections for use with OIC. There is no need to modify the integrations, just update the connection information including the connectivity agent and you’re ready to use ATP!
This is all made possible by the Oracle Wallet option in the Database adapter. See below for this new security option in the Oracle Database connection. Read the complete article here.
For regular information on Oracle PaaS become a member in the PaaS (Integration & Process) Partner Community please register here.