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.
[HOWTO] Identify objects in EA database that refer to non existing classifiers
2020-08-05 by Leave a Comment
[SecondFirstTry] Connecting to a server based repository in Sparx Enterprise Architect with TLS 1.2 correctly
2019-08-12 by 1 Comment
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 from DBMS to DBMS, so I decided to use this built-in functionality. Before the project transfer can be started the transfer type (in my case […]
Converting Sparx Enterprise Architect Baseline Information from XML into C# objects
2019-08-11 by Leave a Comment
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()). From there we have to use a two-step approach to get a baseline and its stored information: Invoke project.GetBaselines() with a PackageGuid to get the […]
[NoBrainer] Simplifying and Speeding Up Testing in Sparx Enterprise Architect
2019-08-09 by Leave a Comment
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 […]
Easy Conversion from Enterprise Architect XML SQL Queries to C# Objects
2019-07-05 by 1 Comment
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) […]
Using Enterprise Architect Add-In Search Methods with XmlSerializer
2019-06-30 by Leave a Comment
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 an Add-In search that returns results to the “Find in Project” dialogue using an XML serialiser. Add-In Search Methods XML structure Serialisation Add-In Search Methods […]
[HOWTO] Create an EA Project in a Microsoft Azure SQL Database
2018-12-17 by Leave a Comment
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 Microsoft SQL Server Management Studio 18 (for direct download click here) Enterprise Architect Schema Creation Scripts for Microsoft SQL Server EASchema_1220_SQLServer.sql EASchema_1220_SQLServer_Update1.sql Enterprise Architect Initial […]
[HOWTO] Create Enterprise Architect Stereotype Reference Data using PowerShell
2018-11-05 by Leave a Comment
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 (B/W: EPS (7.6 MB) | JPG (4 MB)) in Enterprise Architect to associate them with elements. The import of the images into Enterprise Architect has […]
