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
This topic has been locked.
6 replies Latest Post - 2012-09-13T11:42:36Z by MarkOrmos
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 PostsACCEPTED ANSWER
Re: How to access relations on physical data models in IDA2012-07-26T18:41:22Z in response to MarkOrmosHi 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.
reital 27000030MC58 PostsACCEPTED ANSWER
Re: How to access relations on physical data models in IDA2012-07-31T04:04:18Z in response to MarkOrmosHello Mark.
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:36Z in response to reitalHi everybody,
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