I'm developing a Pluglet, where I traverse a whole Physical data model, and I also liked to access the Relations between the tables.
By now I can access the schemes, tables and columns but not the relations.
I would be very thankful if you could give me a hint.
Best regards and thanks
Pinned topic How to access relations on physical data models in IDA
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-09-13T11:42:36Z at 2012-09-13T11:42:36Z by MarkOrmos
SystemAdmin 110000D4XK374 Posts
Re: How to access relations on physical data models in IDA2012-07-26T18:41:22ZThis is the accepted answer. This is the accepted answer.Hi Mark,
You may want to take a look at the Constraints diagram of the SQL Model in DTP following this link http://www.eclipse.org/datatools/project_modelbase/modelbase_doc/umlJan2009/SQLModel/root.html. For example, you will find that BaseTable contains 0..n TableConstraints and ForeignKey is derived from TableConstraint. The tables in a database are BaseTables, and you may do a type cast.
Hope it helps.
Re: How to access relations on physical data models in IDA2012-07-30T12:18:15ZThis is the accepted answer. This is the accepted answer.
- SystemAdmin 110000D4XK
reital 27000030MC58 Posts
Re: How to access relations on physical data models in IDA2012-07-31T04:04:18ZThis is the accepted answer. This is the accepted answer.
- MarkOrmos 270005H875
If you want to get diagrams from DataModelResource ,You can use API in
com.ibm.datatools.diagram.core.services.IRegistrationManager.getDiagrams(Resource/File) . OR if you already got SQLObject from a physical Data Model, You can try to use API in com.ibm.datatools.diagram.core.util.DiagramHelper.
Re: How to access relations on physical data models in IDA2012-09-13T11:40:36ZThis is the accepted answer. This is the accepted answer.
- reital 27000030MC
I need your help again....:)
I would like to export the diagrams of a physical data model as image files (png, gif, whatever). From the context menu its an easy job, but I would like to do it automatically. Is there a way to access the graphics of the diagrams? Currently I traverse the diagrams with the com.ibm.datatools.diagram.core.util.DiagramHelper. Does the DiagramHelper have some functionality I could use for this job? (sorry I cant find the corresponding API).
Best regards and thanks for your help