d-fens GmbH
Audit and Consulting of Information Systems and Business Processes
Everything related to modelling, architecture and processes.
This blog post is about how to create model documents by using the Sparx Enterprise Architect (EA) API. Model documents are part of EA Virtual Documents and are modeled as child elements of report packages. Therefore the creation of model documents described hereafter requires an existing report package. Of course, report packages can also be created using the Sparx EA […]
When cloning a structure in Sparx Enterprise Architect (EA) as a new version, that contains at least one diagram, every newly created diagram (clone) gets quickly opened and closed again during cloning process. In EA v14.1 build 1429 the EA_OnPostOpenDiagram events can be caught successfully however the EA_OnPostCloseDiagram are not thrown by EA in this case. I figured this out […]
While I was working on a feature for an Enterprise Architect (EA) Add-In I had to get information about the scripts, which are stored in EA. The scripts are stored in table t_script and the information I needed was Name and Language. Both properties reside inside the Notes column. Selecting Notes of table t_script with the following SQL query in […]
To implement a feature for an Enterprise Architect (EA) Add-In I needed to show a dialog to the user, which allows him to select a package. The repository class provides a method called InvokeConstructPicker to do so. It seemed to be pretty simple. It was, but you have to consider a small detail, which I did not do in the […]
While working with Enterprise Architect (EA), it has already happened a few times that for unknown reasons objects in EA database referred to classifier GUIDs that are not or no longer existing. If the underlying database is an oracle database, such entries can be found by using the following SQL query.
I grabbed the task to transfer a Enterprise Architect repository from one MSSQL server to another. Sparx Enterprise Architect ships with an action called “Project Transfer” that supports repository transfer […]
In this post I will show you how to easily work with Sparx Enterprise Architect Baseline information in C#. Baseline processing in Enterprise Architect is exposed via the ProjectClass (EA.Repository.GetProjectInterface()). […]
Today’s post will be rather quick. I will show you how a unit/integration test class that can interact with real model data in Sparx Enterprise Architect. Beyond the well known Interop.EA assembly there is another assembly called SparxSystems.Repository that provides the intersting feature to connect to a running EA instance: Services.GetRepository(). We can use this to write unit/integration tests that […]
Sparx Enterprise Architect provides a means for AddIns to display Windows via Repository.AddTab() which are based on System.Windows.Forms.UserControl. However the call AddTab expects a name for the actual tab and a PROGID. EA actually takes this PROGID and loads the UserControl via the registry (as it is actually an Active COM Control). In this post I show you how these […]
This is a followup to the last article Easy Conversion from Enterprise Architect XML SQL Queries to C# Objects. Every time we execute a query that returns results from more than one table we have to use aliasing in the SQL statement to differentiate columns with the same name. See below a query that retrieves all connectors of an element […]
In this article I show you how to easily convert arbitrary SQL query results in Enterprise Architect to native C# objects. The Enterprise Architect object model provides several methods which you can use to make direct SQL queries against the underlying database. And while Repository.GetElementSet really returns a Collection of native EA.Elements (but not connectors) the more versatile Repository.SQLQuery only […]
Sparx Systems Enterprise Architect supports the extension of the built-in search functionality by creating search queries with add-ins called Add-In Search. In this article I show you how to create […]
This blog post serves as a thought support and describes the necessary steps to create a Sparx Enterprise Architect project in a Microsoft Azure SQL database. Prerequisites Enterprise Architect v14 […]
This is a follow-up to the blog post [HOWTO] Convert Images to Enterprise Architect Model Images. As already described there, we wanted to use the official cisco network topology icons […]
We wanted to use the official cisco network topology icons (B/W: EPS (7.6 MB) | JPG (4 MB)) in Enterprise Architect to associate them with elements. To avoid importing these […]
Developing an AddIn for Sparx Enterprise Architect is tedious, even with the existence of support such as the great work of Geert Bellekens. However, since Visual Studio 2015 we can […]
d-fens GmbH 