Sparx Systems Forum
Enterprise Architect => Automation Interface, Add-Ins and Tools => Topic started by: Liaison00 on November 05, 2020, 07:43:58 am
-
I'm coming from PowerDesigner and have an extensive dictionary of terms associated to Tables/Columns. Is there a way by looping through tables/attributes to update the note/description of a table/column elements via scripting?
-
Yes sure. Best to start here https://www.sparxsystems.com/enterprise_architect_user_guide/15.2/automation/automation_interface.html (https://www.sparxsystems.com/enterprise_architect_user_guide/15.2/automation/automation_interface.html)
Tables are EA.Elements (table: t_object), columns are EA.Attributes (table: t_attribute)
Geert
-
Sounds like you are migrating your data models from PowerDesigner to Sparx EA. Not clear how far you are with that process but there is more to it than just the tables and attributes. For example Indexes, Primary Keys, Foreign Keys, Relationships, cardinality etc.If you have a large number of tables then you could also consider creating a C# plug-in to extract from Power Designer and populate Sparx EA which would run faster then scripting. That is what we did last year.
Before you ask - Sorry can't share the code.
-
Hi,
I have a team who have PDM built with PowerDesigner and that we'd like to import in EA.
I looked at a PowerDesigner pdm sample file and it looks like the information is there to import both the structure and diagrams in EA, yet the effort seems quite important.
@Sunshine: did you manage to import the diagrams layout as well as the structure ?
Note: the value is on the diagrams/views since the DBs are available for EA reverse engineering.
-
Just saw your message a few minutes ago.
IIRC as its was back in 2020 since we wrote the C# plugin I believe the diagrams turned out to be too difficult however we dragged all the elements on to a diagram in Sparx EA then ran auto layout.