Before You Install the Recipe

You must perform the following configuration tasks on your OCI Object Storage and Oracle ATP instances in order to successfully connect to these external systems using Oracle Integration and transfer files.

Configure Oracle Database Cloud Service

To access the Oracle Database Cloud Service using Oracle Integration, you must perform certain general configurations on your Oracle Database Cloud Service instance.

See Prerequisites for Creating a Connection in Using the Oracle Database Cloud Service Adapter with Oracle Integration 3.

Also, perform the following tasks to configure Oracle Database Cloud Service for this recipe.

  1. Create a schema named OBJECTSTORE_ATP. See Creating Schemas.
  2. Run the following script to create a table named FILE_TABLE under the schema.
    CREATE TABLE OBJECTSTORE_ATP.FILE_TABLE   
        (     
          FILE_NAME     VARCHAR2 (128),
          CREATION_DATE DATE,     
          FILE_BLOB     BLOB     
        )

Configure OCI Object Storage

To access OCI Object Storage instance from Oracle Integration, you must create a bucket and create a set of API signing keys in your OCI Object Storage instance. See How to use the OCI Object Storage from the Oracle Integration Cloud.

Also, ensure that the Emit Object Events is enabled for the bucket created.

Configure OCI Notification Service

To configure OCI events and notification services, see Configuring OCI Events and Notification Services for OCI Data Integration (OCI-DI).

Note the following while configuring notification services:

  • While creating the subscription, create a HTTPS subscription. In the Create Subscription page, select HTTPS as protocol.
  • In the URL field, specify your endpoint URL in the following format: https://username:password@<host> /ic/api/integration/v2/flows/rest/project/ORCL-R-STORE_ATP_FILETRANSFER/ORACLE_OBJECTST_ATP_FILETRAN/1.0/sendcreateobjectevent

Specify the following values while configuring events.

  • In the rule conditions section, specify the following values.
    Field Information to Enter
    Condition Select Event Type.
    Service Name Select Object Storage.
    Event Type Select Object – Create.
  • In the Attribute(filter) section, specify the following values.
    Field Information to Enter
    compartmentName Enter a desired compartment. This filters events from a specific compartment.
    bucketName Enter a desired Object Storage Bucket. This filters events only in the Bucket from where you want to source files for your OIC flow.
    Event Type Select Object – Create.
  • In the Actions section, specify the following values.
    Field Information to Enter
    Action Type Select Notifications.
    Notifications Compartment Enter a desired compartment. This filters notifications from a specific compartment.
    Topic Select the topic created previously.