Sparx Systems Forum

Enterprise Architect => General Board => Topic started by: michielper on August 30, 2018, 06:39:33 pm

Title: show connectivity/dependency chain
Post by: michielper on August 30, 2018, 06:39:33 pm
An interesting piece of information that is hidden in an architecture repository are the connectivity and dependency chains between components. These are the answers to questions like: "via which other components and connectors is application A connected to application B". Perhaps narrowed down to certain connector types or component types.

As far as I can see, this type of query/report is not supported out of the box in EA but it should be possible to create it, perhaps by using SQL and/or template fragments.... My question is, has anyone thought about this and created a solution?

Thanks in advance!
Title: Re: show connectivity/dependency chain
Post by: Geert Bellekens on August 30, 2018, 06:57:54 pm
I've create a number of specific searches and excel export scripts to get this type of information.

I'm not aware of a generic solution, and frankly, I'm not sure if such a generic solution would even be possible (as in, is less complicated then writing your own query/script from scratch)

Geert
Title: Re: show connectivity/dependency chain
Post by: michielper on August 30, 2018, 07:39:39 pm
I've create a number of specific searches and excel export scripts to get this type of information.

I'm not aware of a generic solution, and frankly, I'm not sure if such a generic solution would even be possible (as in, is less complicated then writing your own query/script from scratch)

Geert

Alright, so can you lift a tip of the veil on how to do this, where to start? Template fragments?
Title: Re: show connectivity/dependency chain
Post by: Geert Bellekens on August 30, 2018, 08:50:43 pm
Hi Michiel,

I wrote an article about SQL searches here: https://bellekens.com/2015/02/15/instant-impact-analyses-in-enterprise-architect-with-sql-searches/ (https://bellekens.com/2015/02/15/instant-impact-analyses-in-enterprise-architect-with-sql-searches/)

Examples of scripts that can be used from the search window: https://github.com/GeertBellekens/Enterprise-Architect-VBScript-Library/tree/master/Projects/Project%20A/Search%20Group (https://github.com/GeertBellekens/Enterprise-Architect-VBScript-Library/tree/master/Projects/Project%20A/Search%20Group)
An example of a script that generates an excel file directly: https://github.com/GeertBellekens/Enterprise-Architect-VBScript-Library/blob/master/Projects/Project%20A/A%20Scripts/Create%20UMIG%20CodeList%20Export.vbs (https://github.com/GeertBellekens/Enterprise-Architect-VBScript-Library/blob/master/Projects/Project%20A/A%20Scripts/Create%20UMIG%20CodeList%20Export.vbs)

Note that my scripts include a lot of other scripts. See https://bellekens.com/2015/12/27/how-to-use-the-enterprise-architect-vbscript-library/ (https://bellekens.com/2015/12/27/how-to-use-the-enterprise-architect-vbscript-library/) for more info about that.

Geert