CODEWITHSUNDEEP
xmloracle-databaseoracle-data-integrator
DirkNM
DirkNM

Reputation: 2664

XML model with ORACLE keyword as column not translated while reverse engineering

I'm using ODI to load XML files from a webservice into the database. The schema file (XSD) defines an element named "share". This is a keyword in oracle. When reverse engineering the XML model, ODI makes a column names "SHARE". Later when building and executing a mapping, which should load the data into a database table, ODI fails to create a temp table, because "SHARE" is a keyword in oracle. The documentation tells, that keywords in XML schema files will be marked with an underscore character (i.e. SELECT will be renamed to SELECT_), but obvisiously the keyword SHARE is not part of that list ODI uses.

Is there any chance to extend the keyword list or any other idea to solve this problem. I cannot change the schema file, because it is not under my control.

Upvotes: 12

Views: 775

Answers (1)

Stian Indal Haugseth
Stian Indal Haugseth

Reputation: 36

Have you tried the built in (in memory) engine? It might not have the same issue with SHARED being a reserved name.

Worth a shot if you use external database for storage? If you remove any "External DB Properties" it should revert to built-in engine.

Upvotes: 0

Related Questions