Select Oracle Connector Based on Use Cases

Issue

Fivetran offers multiple connector options to sync data from the Oracle Cloud. The Oracle Fusion Cloud Applications (OFCA) connectors use Business Intelligence Cloud Connector (BICC) and the Oracle Business Intelligence Publisher (BIP) connector uses the BI publisher to sync data. As these connector types offer similar capabilities, I am not sure which connector to use.

Environment

All Oracle Fusion Cloud Applications connectors and Oracle Business Intelligence Publisher connector.

Answer

The Oracle Fusion Cloud Applications connectors use BICC which is a data extraction tools that creates .csv files for the Oracle applications (FSCM, CRM, and HCM) and stores them in a file store. BICC uses data stores to extract data from the Fusion tables to the destination. The Oracle Cloud Applications connectors (BICC based) schedule and configure the jobs such that the files are first stored in UCM and are then uploaded to your destination.

The Oracle Business Intelligence Publisher connector uses BIP which is a reporting tool that queries the underlying Fusion tables to create custom reports. Our BIP connector uses BI Publisher to query these tables individually to extract the individual underlying tables and stores them as files into UCM.

The following table lists the key differences and helps determine whether to use the OCFA (based on BICC) connectors or the Oracle BIP connector:

Oracle BICC	Oracle BIP
When you need information from the FCSM, CRM, and HCM applications and are able to get the data you need from the available extracts.	When you need access to the underlying Fusion tables and not the extracts or views provided by Oracle.
When you are familiar with the extracts and the BICC connector, and prefer to use the approach recommended by Oracle for bulk data extraction.	When you need access to applications that are not available within BICC and custom reports developed within BIP.