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:

cap4

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

Advertisements

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

w

Connecting to %s