Sanae BEKKAR – My Blog –

Today’s article is about a high level architecture design of a modern Multi-Cloud Analytics integration from a real scenario.

Let’s get started!

Scenario & Requirements  

Two Cloud providers: Oracle Cloud , Microsoft Azure Cloud.

Source : Oracle Fusion SaaS Apps

Target : Power BI

Orchestration : MS Azure Data Factory

Challenges : We expect a bulk Cloud extraction of more than 2M records, it selected as a high volume , Oracle BI Publisher is not recommended , we use BICC – BI Cloud Connector for this case.

Main used components ::

• Oracle Fusion Apps, including Oracle ERP , HCM ,EPM, SCM Cloud services.
• BICC – BI Cloud Connector to extract data from Oracle Fusion SaaS Apps.
• OCI Object Storage > Bucket. Check my related posts for more informations about this components.
• Synapse Pipeline pull the extracted files from OCI Object Storage Bucket
• MS Azure Data Factory is used as a tool for designing and orchestrating , transforming and loading.
• Power BI is used by BI team for analytics and report visualisation.

Here’s the integration flow :

1. We setup BICC in Oracle Fusion Cloud  (either in Full or Incremental mode), to generate a cloud extract .
2. We define as target to export the extract , a bucket within OCI Object Storage. 
3. Synapse  pipeline pull the extract file from the bucket [same action can be done by OIC] , in CSV  format  files and compress.
4. The tranformation to the target format will be done by Azure Data Factory [selected for this case].
5. The transformed extract file is send to Power BI for reporting needs.

Next post , will check the features and benefits of the interconnexion Oracle – Microsoft Azure and how it implemented.

Thanks for reading!