I’m creating some models for Oracle databases that are already in the database server using reverse engineering.
All objects and tables comes OK, but when an entity have a relationship with a table in another user schema (with permission and right relationships) it doesn’t show in the model. In order to Data Modeler bring all related tables I need to manually check them when doing the reverse engineering (in the screen that I check the tables).
This is OK in small databases, but is a pain in large ones.
I could not find an option to do this automatically, TDM have feature?
The easiest way I found to do this is create the ERD model using Toad for Oracle and them import it to TDM…