.png "Employee"){kind=icon}
Overview
When loading data from Oracle Cloud, BICC (Business Intelligence Cloud Connector) is the most commonly used tool. It provides access to a majority of Oracle Cloud tables via View Objects (VOs) prepared by Oracle specifically for this purpose. However, BICC does not cover all Oracle Cloud tables, and requesting support for additional tables can be a lengthy process. This new connector is designed to fill that gap by leveraging another Oracle tool, BI Publisher (BIP), to support tables not currently available through BICC.
Key Strengths:
- Extended Coverage: Extracts data when a View Object (VO) is not available through BICC. This is essential for custom reports or tables not seeded in BICC.
- Source-Level SQL Execution: Run sample SQL queries directly on source tables, bypassing the need for custom report creation.
- Chunking & CDC Support: The connector enables Change Data Capture (CDC) and data chunking, allowing efficient management of large datasets.
Install and Config
- Documentation for this connector
- Login to the Incorta cluster
- Install the Oracle BIP connector from the Incorta Marketplace→Connectors. (Supports Incorta versions 2024.1.7+ 2024.7.x and later)
- Create a new data connection and add the oracle cloud erp url and bicc admin login details
- Make sure the user has the BI admin role added in the Oracle cloud ERP . For more details please check this link.
- Refer to the screenshot below
Using the connection
- Go to the Schema tab and use the Schema wizard to create a new schema or use an existing schema , select the above connection and select tables and save the tables in the schema.
- Optional - add incremental sql (eg select * from table WHERE last_update_date > ?)
- If you are using chunking make sure BIP-based tables include the ORDER BY ROWID clause, especially for tables containing more than 1 million records.
- Load the schema. If there are any rejected rows, fix the table’s column data type, save and reload.
