Oracle Fusion Pipelines: Set Up a BI Connector Data Source and Table

Modified on Thu, 6 Aug at 10:46 AM

You have successfully installed and activated BI Connector. Before creating your pipeline in Fabric or ADF/Synapse, you need to set up a BI Connector Data Source and Table pointing to your Oracle Fusion data.

 

What type of Oracle Fusion data are you going to pipeline using Fabric (or) ADF/Synapse?
Fusion Raw Tables
Pipeline raw Oracle Fusion base tables directly to your destination platform.
Existing BI Publisher Data Models
Pipeline data from existing Oracle Fusion BI Publisher Data Models.
Custom Queries from BI Connector IDE
Pipeline data using custom queries built in the BI Connector query editor.
Analysis / OTBI Reports
Pipeline data from Oracle Fusion and FDI OTBI and Analysis Reports.