See this post that explains how to leverage the capability with OCI Data Integration which is a low code, serverless pipeline engine.
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:
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! 🙂