Oracle ERP Cloud - Data Extraction via BICC
Hi -
We are building a cloud data warehouse using data from Oracle SCM Fusion Cloud 22d using Oracle Business Intelligence Cloud Connector (BICC) for data extraction using the BICC PVOs.
The design we have in mind is one BICC PVO per BICC Job to extract the data via the BICC PVOs. So if the data pipeline needs to extract 100 PVOs, we would submit 100 BICC Jobs (each job containing one PVO) using the Oracle ESS SOAP API to submit jobs, get the ESS schedule id for each job and then monitor the jobs to completion and download the PVO content (gzip files) from Oracle UCM.
Tagged:
0