Oracle SaaS Stories | Exporting Data to Cloud Object Storage with BI Cloud Extract Tool

UPDATE 18/06/2021

See this post that explains how to leverage the capability with OCI Data Integration which is a low code, serverless pipeline engine.

Business Intelligence Cloud Extract is a tool that you can use to export data from Oracle SaaS. The tool is under /biacm service url, such as https://xxxx-envn.yy.dc.oraclezzz.com

As the time of this writing the supported external storage repos are Oracle Cloud Object Storage “Classic” and UCM (Universal Content Manager.

Update: Update 19C now supports OCI (gen2) object storage as well

Step zero: Prerequisites

BICC and UCM privileges need to be configured to obtain permissions:

Role Name: BIACMADMIN

 Role Hierarchies: Application Implementation Administrator and ESS Administrator, OBIA_EXTRACTTRANSFORMLOAD_RWD

 Role Description: Provide access to schedule the extraction jobs in BIACC

OPTION 1: OCI OBJECT Storage (gen2)

Create a bucket in OCI console

Get connection details

You need tenancy, user, generate a key, add the key to the user,… (ask an OCI specialist to help you)

Configure & test connection

Create an export and configure External Storage

View results in OCI console

Download files with OCI CLI

oci os object bulk-download --bucket-name ERPexport --profile eiuenext --auth security_token --namespace eiurenext --download-dir .

OPTION 2: OBJECT Storage (Classic)

Fist Step: Configure cloud storage

Second Step: Create a connection in the tool

Click the “+” button:

Provide cloud storage information:

Host: <identitydomain>.<region>.storage.oraclecloud.com

Service Name: storage-<identitydomain>

Container: Click the reload button and select a container from the listbox

Third Step: Create an schedule

Click the “+” button and put appropriate values:

Select one or more data stores:

Provide storage connection and the rest of the information and click [Save]

Wait for the job to execute:

Go to object storage console and see what happened:

The zip files contain the data, the JSON files contains details of the job run.

That’s all folks, hope it helps! 🙂