How to Connect to OCI Object Storage Bucket from BICC

In Case of Large Volume extracts we prefer using BICC.

BICC currently has  limited External Storage Connectivity.

One of the allowed ones is OCI Object Storage.

We need to configure OCI as external storage connection in The BICC.

We can follow the below steps to create connectivity between BICC and OCI 

Login to OCI and get below details which are required for connectivity

• Host
• Tenancy OCID
• User OCID
• Namespace
• Bucket

 

To get the host,namespace and bucket details follow the below screenshots:

Login to OCI->Menu->storage->buckets->Select compartment->select the bucket

 

 

 

 

The host url will be like below:

objectstorage.<region>.oraclecloud.com

example: objectstorage.us-ashburn-1.oraclecloud.com

We can get this url by going to one of the object and se url:

 

 

 

 

 

Now we need to get tenancy and tenancy OCID

For this click on the drop down  under user profile:

 

 

 

We will get the tenancy name here.

Now to get tenancy OCID click on the tenancy link.

 

 

 Copy these details.

Now we will get the last one which is user OCID.

We will be creating BICC to OCI connectivity with this user.

For this go to identity and security-> click on domains:

 

 

Select the compartment->and then select the IDCS domain.

In our example case we will use Default one :

 

 

We need to make sure the user has relevant access/policy on the object storage bucket (i.e. write) 

under this click on users->select the user

 

Copy the user OCID.

Now we have all the details needed for OCI storage connection in BICC.

Keep this tab opened because we will comeback here to upload the api signing public key.

Now open BICC:

Url will be: <host>/biacm

example : https://abcd-dev2.fa.us6.oraclecloud.com/biacm

 

 

Click on Configure External Storage icon as highlighted in the above screenshot. 

 

 

Click on Plus (+) and provide all the details we had copied from OCI:

 

Now click on Generate API   Signing Key

This will generate key pair.

Click on SAVE to save the details.

After this click on Export Public Key

Take the downloaded public key and go to the other tab for OCI.

  Under that user details click on  API Keys:

 

 

 Click on Add API Key->Choose a public key file->upload the exported public key: and click on add button

After uploading match the details with what wen have in BICC (User OCID, Tenancy OCID and Fingerprint)

 

Click on close.

 

 

We can see the newly added key details under the API Keys of this user.

 

Now go to BICC Tab and open the OCI external storage connection we had created.

Click on Test Connection

We will get result like below:

  

 

NOTE: Whenever we have PROD to Lower environment refresh, the BICC will copy prod details so if we want to use lower env for OCI connectivity we need to update it if we are using different user for prod and lower env.

Now whenever we run a BICC job select this external storage and provide path it will upload file in the specified bucket and folder. If the folder doesn't exist then it will create the folder and write object in OCI Object store.

In the Next post we will see how to copy these files to Amazon S3 bucket using OIC integration.