Just FYI.
If you create a data model via the Import DB schema from ODBC tool and the MS SQL database that you are accessing actually has multiple schemas (owners), EA may not correctly create the associations between the obects. (tables or views).
This occurs when the same name is used for multiple objects. Seems EA does not take into account the schema (owner) of the objects when drawing the connection on the diagram.
For example, given:
Database has 3 schemas, "S1", "S2" and "S3".
Each of the 3 schemas have the same objects:
"T1" - table
"T2" - table
("T2" has a FK association to PK of "T1")
"T1" - view, which basically defines T1 table as a view, thus is associated with the T1 table.
"T2" - view, which basically defines T2 table as a view, thus is associated with the T2 table.
When EA creates the diagram via the Import schema, it correctly creates the tables and views with the name of the schema set as the OWNER tag. (FYI: setting "Show Data Model Owner" under the Element menu tag of the diagram's properties will display the owner name with the object name).
However, in my experience it does not correctly draw the associations.
For the views, it not only shows the association between the view and the table within the each schema, it erroneously shows additional associations between the view and the tables/views in the other schemas that have the same name.
As for the FK association between the tables, it sometimes will draw the association connection to a view instead of the table of the same name.
