Working with Synonyms

By default, on the ODI models, you can select “Synonym” as a type of object to reverse-engineer. They will appear in the “Selective Reverse-Engineering” tab and you can ‘partially’ reverse engineer them, however the “Attributes” tab of the data store for each synonym will be empty.

To resolve the issue, a couple of key/value needs to be added to the required data server.


Topology -> Physical Architecture -> Technologies -> Oracle -> [Data Server] -> JDBC tab -> Properties section


A new property needs to be added with the following values:

Key = includeSynonyms

Value = true


It will look like this:


After that setup, please disconnect & connect again to the ODI repository to be able to reverse engineer synonyms properly.


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s