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

Question

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.

Vervain

#1162881 kindly note declaring with double quotes is case sensitive – Fruit

The problem is, that ODI don't use double quotes in the generated DDL-code and I don't know how to tell ODI to do so. – Vervain

community.oracle.com/thread/2133118 this post recommends to handle it in the mapping – Fruit

Is this resolved ??? – Fruit

Unfortunately not. The problem is not my target table. It is the temp table created by the KM. I tried to modify the KM, but with no luck yet. – Vervain

Answer 1

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.

Eogene