Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

XML Issues with table name length

Christelle B.Apr 23 2018 — edited Apr 25 2018

Hi,

I migrated ODI from version 10 to version 12c.

I have to load data from xml source into oracle table. Some of the elements from the xml(that ODI reverses as datastores) are more than 30 characters long.

In ODI 10, mapping is OK with datastore name > 30 characters.

In ODI12, there is an error with the name of datastore:

pastedImage_0.png

I can't modify datastorename because xml and dtd file come from external service.

In topology manager, when I edit XML technology, both "Maximum Table Name Length" and "Maximum Column Name Length" are set to 30. According to the documentation, ODI should truncate the table name to the maximum length specified. But when I reverse the xml model, the datastores with more than 30 characters are created and this causes my interface to fail. Is there a solution for this problem?

Appreciate your response.

Thanks!
This post has been answered by Adrian_Popescu-Oracle on Apr 23 2018
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 21 2018
Added on Apr 23 2018
#business-intelligence-applications, #data-integrator, #system-management-and-integration, #xml
3 comments
420 views