Oracle Integration Cloud comes with a library of adapters for both Oracle and 3rd Party applications. All of these capabilities mean that it’s possible to integrate applications faster and increase business agility. I've been writing a lot lately on the topic of Oracle Autonomous Database and also presenting about Oracle Integration Cloud, so I thought, why not merge the 2 subjects and document here how you might go about using the Oracle Integration out-of-the-box adapters to integrate to an Oracle Autonomous Transaction Processing (ATP) or Autonomous Data Warehouse (ADW) instance (both Oracle Autonomous Database - ADB - offerings). In this post I will describe how to use the Oracle Autonomous Database adapter in Oracle Integration Cloud to directly connect to an ATP or ADW instance.
Processing
Oracle Autonomous Database: Load Data from a Local File
In this post we will look at the data load from local file feature of "database actions" including how to access this feature and how to use it! This data loading feature is really simple to use allowing you to efficiently create tables or update existing tables with data that you might have stored locally or in the cloud, all without writing any code.
Oracle Autonomous Database: Accessing & Using Database Actions
Database actions can be accessed for Oracle Autonomous Database. In this post we will look at what Database Actions are, how to access/use them and also how to grant access to other users to make the most out of the features available.
Connecting to an ATP Database in Oracle Cloud
In this post, I document the steps to help you to connect to (and use!) a newly created Oracle ATP Database Service
Creating an ATP Database in Oracle Cloud
In this post, I document the steps to help you create your own Oracle ATP Database Service.