1. Send Files from Oracle Cloud Infrastructure (OCI) Object Storage Service to Oracle Autonomous Transaction Processing (ATP)
  2. About This Recipe

1 About This Recipe

Use this recipe to send files from OCI Object Storage Service to Oracle ATP.

Note:

This recipe is available as OCI Object Storage Service — Oracle ATP | Send Files in the Integration Store. Oracle provides this recipe as a sample only. The recipe is meant only for guidance, and is not warranted to be error-free. No support is provided for this recipe.

Overview

This recipe transfers files from OCI Object Storage to Oracle ATP, whenever a file is uploaded in OCI Object Storage.

To use the recipe, you must install the recipe and configure the connections and other resources within the recipe. When a new object(file) is uploaded to a bucket in OCI Object Storage Service, the integration flow is triggered, and it downloads the file from OCI Object Storage. Further, the recipe sends the downloaded file to Oracle ATP as a Binary Large Object (BLOB) attachment.

System and Access Requirements

  • Oracle Integration, Version 21.2.1.0.0 (210129.2200.39462), or higher

  • Oracle Cloud Infrastructure (OCI) Object Storage Service

  • An account on Oracle Cloud Infrastructure (OCI) Object Storage Servicewith the Administrator role

  • Oracle Autonomous Transaction Processing (ATP)

  • An account on Oracle Autonomous Transaction Processing (ATP)with the Administrator role