OIC - Oracle Integration-Bulk load into Oracle ATP OR Oracle ADW

Oracle Integration enhances its database adapters, including Oracle Autonomous Transaction Processing (ATP) and Autonomous Data Warehouse (ADW) Adapters, to support native bulk load operations. Leveraging Oracle Autonomous database and OCI features, these enhancements significantly boost performance.

A typical use case involves importing bulk data by retrieving a file (e.g., from an FTP server or HCM system), placing it in object storage, and loading its contents into an ATP-S database. Oracle Integration can also reformat files (e.g., XML or JSON) into the database's required format, such as CSV.

To implement the integration flow:

1. Create an App Driven Orchestration or Schedule Based Orchestration based on the requirement.
2. Download the file from the FTP location to the staging area.
3. Use the Oracle Autonomous Transaction Processing Adapter or Autonomous Data Warehouse Adapter as per your database instance.
4. In the adapter wizard:
1. Select Perform bulk data import operation.
2. Choose the OCI Bucket and enable Delete file from object storage after operation completion.
3. Edit Copy data format options, select the file format, schema, table, and columns. Ensure the columns align with the incoming data order.

Reference:

https://blogs.oracle.com/integration/post/oracle-integration-bulk-load-into-oracle-atp-or-oracle-adw