BICC Extracts to GCP

Vasu Bajaj

Hi All,

I am looking for a way to read data incrementally from the PVOs to the GCP. My initial hunch was to use Apache Airflow, but I think that would not serve the purpose. Later, I came across the BICC scheduled incremental extracts using the connector console but I am not able to locate any example to load data to GCS. I am not sure if BICC has that capability yet. Can someone guide me to any example that could help me meet the requirement?

Any help/guidance is appreciated.

EzequielC-Oracle

Hi @User_D8OCB ,

This is the OBIEE community.

BICC is available as part of the Oracle Applications Cloud subscription.

What product are you using? Is it Fusion Applications?

Regards,

Ezequiel.

Vasu Bajaj

Hi @EzequielC-Oracle ,

yes, I am using the Cloud Fusion application.

[Deleted User]

Hello,

Please have a look at the official documentation: https://docs.oracle.com/en/cloud/saas/applications-common/24a/biacc/configure-where-to-load-datastorage-type-cloud-storage.html#u00180692

It details the 3 possibilities of target data store:

Vasu Bajaj

Thanks @Christian Berg . I did look at the documentation before posting the question but both the object storage integrations are for native Oracle Cloud I believe.

[Deleted User]

https://community.oracle.com/products/oracleanalytics/discussion/comment/53047#Comment_53047

Yes. The three outlined options in the documentation are the supported ones for BICC. GCP is not a supported data storage.

You can create an Enhancement Request and ask for this capability to be added to the product or you can investigate other avenues of approach by using supported data storages and then transferring the data from the supported storages to your GCP.

EzequielC-Oracle

Hi Vasu,

To create an Enhancement Request (idea) go to the Ideas Lab:

https://community.oracle.com/products/oracleanalytics/categories/ideas

Regards,

Ezequiel.

Vasu Bajaj

Thanks, folks!! Appreciate your response.
I spent time to dig down a bit more and came across a kb: Download from Oracle WebCenter Content (UCM) using the “WebCenter Content Document Transfer Utility.”

This utility helps you download the files from the UCM using a jar - oracle.ucm.fa_client_11.1.1.jar , which I am not able to locate. Sample Command:

echo "Search MANIFEST from UCM" >> ./log/log.log
java -jar "./oracle.ucm.fa_client_11.1.1.jar" SearchTool \
--SortField=dID \
--SortOrder=desc \
--log_file_name=log/manifestSearchResults.txt \
--dDocTitle="MANIFEST.MF" \
--dSecurityGroup="OBIAImport" \
--delimiter=, \
--fields=dID,dDocName,dInDate \
--quiet --propertiesFile=./connection.properties \
--defaultFields=false >log/log.log 2>log/error.err

Does anyone know where I can get this jar from?