Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 53 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 291 Oracle Analytics and AI News
- 57 Oracle Analytics and AI Videos
- 16.3K Oracle Analytics and AI Forums
- 6.5K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 116 Oracle Analytics and AI Trainings
- 21 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Guarantee Order of Columns from BICC Extract
Organization Name
The Cleveland Clinic Foundation
Description
Create a way to ensure the order of the columns from an extract using Business Intelligence Cloud Connector Console (BICC).
A few ideas:
- Ensure every extract has the columns in alphabetical order
- Allow BICC to configure the column's order in a Data Store
- Have the orders be driven by the order seen in the Metadata file
Use Case and Business Need
The Business Intelligence Cloud Connector Console (BICC) is being used to extract data from Oracle ERP Cloud, and the extracted files are used to load into a Data Hub.
Part of the process of loading the file into the Data Hub is to leverage the ETL tool, Informatica.
Informatica reads the files and expects the order of the columns to be consistent across each load, and when moving from one environment to the next.
Currently, there is no way for BICC to guarantee the order of the columns in the extract, and therefore this is introducing errors for the ETL tool to load the file.
The expectation is to have consistency in extractions, especially when migrating to a higher environment.
More details
Existing Bug: 28281988
Original Idea Number: 782a33759f