Sparx Systems Forum

Enterprise Architect => Automation Interface, Add-Ins and Tools => Topic started by: Paolo F Cantoni on November 24, 2017, 01:44:06 pm

Title: Foreign Key Associations didn't import from ODBC
Post by: Paolo F Cantoni on November 24, 2017, 01:44:06 pm

I just did my first DB schema import for a while (just two tables).  I ticked every option I could find on the import, but the Associations that represent the Foreign Key Constraints didn't import.  What did I do wrong?

IIRC, there used to be an option to show the FKs as Associations or not or is my memory failing me?

TIA,
Paolo

Title: Re: Foreign Key Associations didn't import from ODBC
Post by: Richard Freggi on November 28, 2017, 12:14:05 am

What RDBMS?  I reverse (and forward) engineer with SQLite using the OBDC driver mentioned in the user guide and my FKs and associations work.  EA 13.0.1310 on Win10)

Title: Re: Foreign Key Associations didn't import from ODBC
Post by: Paolo F Cantoni on November 28, 2017, 10:34:46 am

Quote from: Richard Freggi on November 28, 2017, 12:14:05 am

What RDBMS?  I reverse (and forward) engineer with SQLite using the OBDC driver mentioned in the user guide and my FKs and associations work.  EA 13.0.1310 on Win10)

SQL Server 2016.  The driver is marked as ODBC Driver 13 for SQL Server.

Paolo

Title: Reflexive Foreign Key Associations didn't import from ODBC
Post by: Paolo F Cantoni on January 18, 2018, 02:13:35 pm

So I changed the ODBC driver to SQL Server Native Client 11.0 and things started to improve.  But I've just noticed that Reflexive (that is back to the same table) FK associations aren't being imported.  They are present in the DB and will show up under the SQL Diagramming section.  They are present on the imported table as stereotyped FKs, but associations are nowhere to be found.

Anyone confirm or deny this?

Paolo