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

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 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 new ICI object Storage Connection
Configure connection appropriately

Create an export and configure External Storage

View results in OCI console

List of generated files with exported data

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>

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! 🙂


  1. pani

    Hi, Can you please help how to work with offerings I am new to this BICC. I have defined OCI object storage connection and selected supply chain and order management as an offering, after that what steps need to follow to extract a few columns from the order management.


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.