2 Before You Install the Recipe

You must perform the following configuration tasks on your OCI Object Storage Service 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.

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 Oracle Cloud Infrastructure (OCI) Object Storage Service

To access OCI Object Storage Service instance from Oracle Integration, you must create a bucket and create a set of API signing keys in your OCI Object Storage Service 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 Oracle Cloud Infrastructure (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.