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