How to get Foreign Key Columns using Script?

[patrik.slechta]

Dear All,
I am trying to extract structure of DataModel, so: tables, columns, primary key, foreign keys from EA Repository to JSON metadata file (to be used in another software outside EA).
Tables, columns, primary keys are quite clear but I feel stuck for days with Foreign Key detailed information. Especially the "Involved Columns" displayed on "Foreign Key Constraint" EA screen.

Foreign Keys itself seems to be defined in EA Repo following two places:
- as EA.Method stores in myTable.MethodsEx where StereotypeEx == "FK", providing simple list of Foreign Keys
- as EA.Connector stored in myTable.Connectors where Type == "Association" providing additional handy FK details

The Connector object contains many information for example:
- ForeignKeyInformation - contains DST=PK_name:SRC=FK_name:
- ClientEnd.Role - containt FK name separatelly
- SupplierEnd.Role - containt PK name separatelly
- SupplierEnd.Cardinality - contains Source Cardinality: 1
- ClientEnd.Cardinality - contains Target Cardinality: 0..*

Where the problem is?
I am stil unable to find actual columns (list of columns), which are used as part of the defined Foreign Key.
I am missing or overlooking something in the repositoy?

It would be nice if you could share some experience or inspire my next steps, please! 
Kind Regards,
Patrik

[patrik.slechta]

As my exploration (just nicer name for troubleshooting) continued, there are some fresh findings.
Sharing it here, because somnebody can use it too...

Looks like the columns participating on the Foreign Key are stored in Repo as:
- myTable.MethodsEx.Parameters
- there is list of column names (Name) and colum position (Position) in defined Foreign Key

It is quite complex way of storing Foreign Key definition with information scattered between:
Method - there are Primary Keys and Foreign Keys defined for the table
Method.Parameters - there are Primary Key and Foreign Key participating columns stored
Connection - there are links between Foreign Key and refferenced Primary Key stored

So the FK columns are stored the same way as PK columns.
I have been just misled by all the other FK details present in paralell structure of Connection object

[Richard Freggi]

You may find it easier to forward engineer your EA data model to some DBMS, then reverse engineer from that DBMS to the other tool

[patrik.slechta]

Definitelly if used occasionally. We are under some transition period and the exchange of current data model structures might be qute frequent (due to the ongoing changes and development) for limited time.
It took few days of exploration and troubleshooting, but currently the import/export to/from JSON of tables, columns, datatypes, comments, primary keys, foreign keys... almost everything works fine.
It is not the state of the art solution but it works sufficiently 

[Geert Bellekens]

Looks like you pretty much found all the bits and pieces. I feel your pain. I had to go through the same thing a few years ago myself

Geert

[patrik.slechta]

Thank you Geert,
your EA related scripts, tutorials and responses here in the forum have been huge support on my suffering fascinating exploration
Patrik