Sparx Systems Forum
Enterprise Architect => General Board => Topic started by: HLidstrom on February 18, 2020, 05:13:31 am
-
I am turning to the collective wisdom of the Forum.
My organization has decided on enterprise architecture modeling with TOGAF – ArchiMate – Sparx EA.
My organization already has an established practice of data modeling with IDEFX1 in erwin.
The EA model needs to show how logical data relates to the rest of the EA. Therefore we have a need to import logical data models and show the erwin entities as ArchiMate Data Objects in the EA Model.
What is the best approach to this Extract – Transform – Load (ETL) task?
I am considering the Data Miner feature. It seems to be designed for a need like mine.
I have gotten as far as setting up a data miner model, pointing it to an XMI file generated by erwin and running the default ProcessData script. It lists the XMI file in Session.output. So far so good.
Next step would be to actually do something with the data. I was thinking if I can create packages and classes, same as the built in XMI import does, then I should be well on the way.
Does anyone have a better suggestion than Data Miner for converting erwin entities to ArchiMate Data Objects in Sparx EA?
Thank you,
Håkan Lidström
-
I'm not sure how much you gain using the data miner as opposed to simply writing a tool (script, C#, whatever) to read the Erwin output and create the packages and classes in EA.
Geert
-
Thanks Geert!
I see your point. I would end up writing a script anyhow with the Data Miner approach, so why bother with the overhead?!
/Håkan
-
Thanks Geert!
I see your point. I would end up writing a script anyhow with the Data Miner approach, so why bother with the overhead?!
/Håkan
Yes, indeed. On top of that I often see that things such as the Data Miner impose certain restrictions that you don't have when you write a regular script or C# program
Geert