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


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.

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

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.

WordPress.com.
%d bloggers like this: