Guarantee Order of Columns from BICC Extract

Bradley Q-Oracle

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

User_UP0BI

Having control over the column order in the extract would be very useful.