How To Handle 30 Character Limit of Column Names in Oracle Database When Copying Models between Technologies in ODI 12c Studio (Doc ID 2291171.1)

Last updated on AUGUST 21, 2017

Applies to:

Oracle Data Integrator - Version 12.1.2.0.0 and later
Information in this document applies to any platform.

Goal

Some Data Servers, such as Salesforce.com and SAP, allow column names (attributes) to have more than 30 characters maximum. Oracle database version 12c R1 and below only allows 30 characters.

When loading data from one technology to another, one of the features offered by Oracle Data Integrator (ODI) Studio is to copy the model from one technology to the other, and then have ODI create the tables. Ie, to load data from Salesforce.com to Oracle DB, the existing Salesforce.com models can be copied into an Oracle model using ODI Studio.

However, this causes issues as some of the "attributes" or column names can be larger than 30 characters in Salesforce.com, which is not allowed by Oracle.

How to truncate the attribute names intelligently and automatically so that the 30 character limit on Oracle database is respected? The column names must be unique.

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms