Saturday, November 14, 2015

Unable to Reverse Engineering Synonym in ODI 12c

Unable to Reverse Engineering Synonym in ODI 12c


Issue:
We can able to see the Synonym but after Reverse Engineer structure of datastore is empty

     Steps to be the followed to fix:

1. Check your Logical Schema and context for that model

2. Logical Schema will be available in overview tab of model and context will be available under Reverse Engineer Tab of the model

3.Go to Topology Navigator then Logical Architecture  and check logical schema for that particular context and find out your data Server (for eg: xyz.abc that means xyz is Data Server and abc is Physical Schema)

4.In the physical Architecture, go to Data server and then properties tab and add the following:
"key= includeSynonyms and value= true"

5.Now you are able to perform Reverse Engineer for synonym !!!!!!!!

4 comments:

  1. Can we reverse engineer public synonyms with the above process? I have done above steps and could not reverse engineer the synonym.

    ReplyDelete
    Replies
    1. Vamsi,
      Are you able to see the synonym in under that model?
      If yes then one more question your not getting structure or not able to reverse engineer.
      If no then you need use reverse engineering knowledge modules..

      Delete
  2. in windows press restore windows from default

    ReplyDelete