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

OCI Storage

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 .

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

Comments

Leave a Reply

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

WordPress.com Logo

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

Google photo

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

Twitter picture

You are commenting using your Twitter 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.