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.