Manage Metadata (Oracle BICC)
Oracle Business Intelligence Cloud Connector (BICC) is Oracle's built-in tool for extracting bulk data from Oracle ERP Cloud. Because Oracle ERP Cloud routes all bulk data extraction through BICC, Data Hub manages this process by working directly with BICC extract jobs which are pre-configured definitions that specify which tables and columns to extract.
When your Oracle ERP Cloud environment is provisioned and the connection is configured, Data Hub automatically creates the BICC jobs and makes them available on the Manage BICC Jobs page. From there, you can keep your local metadata and Oracle BICC in sync using Retrieve from Oracle and Send to Oracle, and import new or updated job definitions when needed.
BICC Jobs List
To open the Manage BICC Jobs page:
- Go to Data Hub > Connections.
- In the Actions column, select Manage Metadata from the menu for the Oracle BICC connection.
The Manage BICC Jobs page lists all BICC jobs registered in Data Hub. Use the search bar to filter jobs by any column.
| Column | Description |
|---|---|
Job Name |
The BICC job name. For example, XXIS_BusinessUnitPVO. |
BICC Job ID |
Oracle's assigned job identifier. For example, 500001245. |
Data Store Name |
The underlying data source path. |
Last Synced |
The number of days since the metadata was last synchronized. |
Status |
The current state of the job's metadata synchronization. |
Columns |
The number of columns in the extraction. |
Actions |
Options to retrieve and send metadata for an individual job. |
Retrieve from Oracle
Use Retrieve from Oracle to pull the latest job metadata from Oracle BICC into Data Hub. Do this when changes have been made in Oracle BICC, for example, when columns have been added or job configurations have been updated, and you want Data Hub to reflect those changes.
When you select Retrieve from Oracle > Start Retrieve, Data Hub will:
- Connect to the Oracle BICC service.
- Fetch metadata for all registered jobs.
- Update local job definitions with the latest data from Oracle.
To retrieve metadata for a single job, select Retrieve in the job's row in the list.
Send to Oracle
Use Send to Oracle to push your local job configurations from Data Hub to Oracle BICC. Do this when changes have been made locally and you want Oracle BICC to reflect those changes.
When you select Send to Oracle > Start Send, Data Hub will:
- Validate all local job definitions.
- Connect to the Oracle BICC service.
- Send each job's metadata to Oracle.
To send metadata for a single job, select Send in the job's row in the list.
Import Jobs
Use Import Jobs when you need to add new job definitions or make significant updates to existing ones. This is not required for initial setup. When your Oracle ERP Cloud environment is provisioned and the connection is configured, Data Hub automatically creates and loads the BICC jobs.
To import BICC job definitions:
- Select Import Jobs.
- Upload the metadata ZIP file exported from your Oracle ERP system.
- Select an import option:
Option Description Replace all jobs
Removes all existing jobs and imports all jobs from the ZIP file.
Import new and replace existing jobs
Replaces jobs with matching names and adds new jobs from the ZIP file.
Import only new jobs
Imports only jobs that do not already exist. Skips jobs with matching names.
- Select Import Jobs.
- Review the table for new jobs added, jobs updated, and any errors.
For information on replication tasks, see the Data Replication section.