From the course: Oracle DB Cloud Database Migration and Integration Workshop

Unlock this course with a free trial

Join today to access over 23,300 courses taught by industry experts.

Extract data from the Fusion SaaS application using the BICC Connector in ODI

Extract data from the Fusion SaaS application using the BICC Connector in ODI

From the course: Oracle DB Cloud Database Migration and Integration Workshop

Start my 1-month free trial Buy for my team

Extract data from the Fusion SaaS application using the BICC Connector in ODI

“

Welcome friends to the Oracle University module on Extract Data from Fusion SaaS Application Using BICC in ODI. I'm your host, Desiree, and let's get started. In this module, I'm going to show you Business Intelligence Cloud Connector, BICC with ODI, setting up ODI topology objects, creating model and reverse engineering, and finally, creating mapping. Oracle Data Integrator supports data extraction from Fusion Cloud Applications to load any target in Autonomous Database. This presentation will give you an overview of the process and detail the steps needed. We will go over ODI topology configuration, reverse engineering of data model, and finally, creation of data integration mapping. ODI leverages Business Intelligence Cloud Connector, also called BICC, for data extraction from Fusion Cloud Applications. There are other methods based on direct JDBC drivers to extract data from selected Fusion Applications as well. However, the BICC method is preferred because it is optimized for…

Contents