Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Messages - Eamonn John Casey

Pages: 1 [2] 3 4 ... 7
General Board / Re: SQL to find mult connectors between to elements
« on: January 11, 2018, 01:32:28 am »
Thanks! I now got a start point to tweek With.

The scenario I am looking for is (using ArchiMate speak):
A is Assocaited With B
B is Serving A

So I am looking for Connectors in both directions and of same or different types. I'll post the result when I get to it.  :)

/ Eamonn J. //

General Board / SQL to find mult connectors between to elements
« on: January 10, 2018, 11:04:40 pm »
Does anyone want to share a nifty SQL that finds more than one Connector between to elements? Using "Hide Connector" and similar functionality has been a complete disaster for us. There are some pairs of elements in our model that have many connectors btween them. Makes creating New diagrams labourous to hide unnecessary eones.

I know the tables involved but not really a SQL guru!

Eamonn J.

Bugs and Issues / HTML Publish automation and the need to be logged in
« on: January 05, 2018, 07:40:15 pm »
I have made a utility to run the HTML Publish automatically on a Schedule but the user needs to be logged into the machine for it to work. Does anyone know of a workaround to make this work? I read about a Windows Service wrapper but that only seems to wrap my utility and not the Enterprise Architect instance.

What I really want is to be able to Reference models from Confluence where we do documentation.
Will WebEA/Pro Cloud help here?

Thanksin advance,
Eamonn J.

Bugs and Issues / ArchiMate 3 and Aggregation/Composition nesting
« on: November 14, 2017, 06:04:46 pm »
I have noticed an issue With some elements in the ArchiMate 3 MDG when using Aggregation\Composition and Nesting. In some elements (Application Component) when putting one element inside the other the relationship should hide but it doesn't. Trying the same With elements in Stretagy or Motivation seems to work. The relationship hides when the elements are nested.
Eamonn J.

I use SharpDevelop. Developing in C#.
My wrapper is available here:

Automation Interface, Add-Ins and Tools / C# EA Wrapper available
« on: September 21, 2017, 09:17:10 pm »
If anyone wants it, I have been working on a wrapper for EA API in C#.
includes functions like:
Code: [Select]
EA.Element GetElementByName(int packageID, string elementName, string stereoType)
EA.Connector FindorCreateConnector(string fromElementGUID, string toElementGUID, string connectorDirection, string connectorStereoType)
EA.Element FindOrCreateElement(Package rootPackage, string elementName, string stereoType)
Package FindOrCreatePackage(Package parent, String packageToFind, String packageType)
List<EAQueryResults.EAConnector.Row> GetConnectorsByGuid(String fromGuid)

General Board / Re: Pro Cloud/WebEA and log in (Single Sign On)
« on: September 21, 2017, 07:35:56 pm »
When importing users from Active Directory the EA Client understands it is a Active Directory credential and uses SSO. But coming through WebEA (which could be from anywhere) EA does not have a reference point so it defaults to the internal t_secuser credential.

So if you want to use Pro Cloud and WebEA you need to set your password inside in the EA Client.

But this is sort of logical because not everyone outside needs to have an Active Directory account.

General Board / Re: Update EA Repository Query
« on: September 21, 2017, 07:21:15 pm »
Yes. Tried that. But what I was trying to point out was directly manipulating the database bypasses a certain amount of logic. So you need to know what you are doing. Often one update results in lots of small updates in other places in the database. So this also must be replicated.

General Board / Re: What is your top 10 features in EA 15.x
« on: September 21, 2017, 07:09:48 pm »
 ;D v13 I meant. Finger trouble.

For me, this works as expected. I started trying to set everything I thought was reasonable but when you hit the .Update() EA takes over.

Code: [Select]
public EA.Connector FindorCreateConnector(string fromElementGUID, string toElementGUID, string connectorDirection, string connectorStereoType)
EA.Element fromElement = eaRepository.GetElementByGuid(fromElementGUID);
EA.Element toElement = eaRepository.GetElementByGuid(toElementGUID);
EA.Connector connectorFound = null;

foreach (EA.Connector connector in fromElement.Connectors) {
if (connector.SupplierID == toElement.ElementID) {
connectorFound = connector;
if (null == connectorFound) {
connectorFound = (EA.Connector)fromElement.Connectors.AddNew("", connectorStereoType);
connectorFound.SupplierID = toElement.ElementID;
connectorFound.Direction = connectorDirection;
return connectorFound;

ArchiMate in the Motivation Layer has specific elements for exactly what you need. What is great about EA is that you can model in any language you like and as many of them as you like. If SysML can't do what you need have a look at ArchiMate Motivation. My company went down the route of customizing and even creating custom MDGs. When the base language gets a new version - you got a huge job to update your language BUT also all of the diagrams too.

General Board / Re: Versionhandling?
« on: September 21, 2017, 03:00:37 am »
As mentioned earlier in this thread EA is really bad on version control. The reason for this is at the model level there is no need for it. BUT at the code level where programmers live a line of code, a new field in the database, etc. is important.

Tools like Magic Draw that is close to code do this very well.

My technique is to use a general element (ArchiMate Application Process) that rerely changes and make Specialisations of this. At the modelling level the names of the boxes never change. It is the arrangement and the inclusion and removal over time.

Så EA does not do versioning. Time Aware Modeling I have not tried. But the thought around modelling as apposed to code is: Does it really matter what was delivered in the previous release?

General Board / Re: Pro Cloud/WebEA and log in (Single Sign On)
« on: September 21, 2017, 02:44:24 am »
The answer I found was to go into EA Client and change your password inside in the EA model database (not Active Directory). It is this password that is used in the Pro Cloud /WebEA login and has nothing to do with SSO/Active Directory password.

Oversight in the documentation maybe. But it makes sense if the user is not a network user. i.e. Guest/Guest.

General Board / Re: Update EA Repository Query
« on: September 21, 2017, 02:39:26 am »
I have been using the API extensively and especially the SQLQuery. The API just like the SQL Scratch Pad rejects anything that is not SELECT.
The work-around (and this is really dangerous in some conditions) is to go direct to the database using your favorite DB API.

Please post the SQL you are attempting. Maybe there is some API or easier way.

Pages: 1 [2] 3 4 ... 7