Import Oracle DB Schema - Missing Synonyms

[DJTinter]

Using EA 14. Trying to reverse engineer database model by importing db schema. Functions and Stored procedures import correctly. However, tables represented by synonyms are not recognized and therefore not imported.

Any suggestions?

[Geert Bellekens]

Are the actual table missing, or only the synonyms?

I guess the import doesn't know about Oracle synonyms and therefore isn't able to import those.
The underlying tables however should import correctly.

To be sure you better contact Sparx support.

Geert

[DJTinter]

The import popup finds the schema. For Table, Object and Advanced Filters, I've select true for all. When it displays all available objects, it shows only the System objects. None of the defined synonyms.

[DJTinter]

Sparx support responded today....


EA imports database information using a series of SQL queries based on each DBMS's schema information system objects, tables defined as synonyms are not included in the normal system objects and as such not imported in the normal way.
At this stage EA does not support the definition of table synonyms, and unfortunately it is not a simple feature to add since all components of database engineering (defining, importing, DDL generation, show differences etc) would need to be updated so in order for EA to support them. This is something we can look at adding in a future release of EA.