Messages

1

General Board / Re: Repository.Execute no longer works in JScript

« on: August 10, 2026, 09:58:29 pm »

I've sent an email to support about this one, and the restrictions on Repository.SQLQuery (where you can't select from certain tables anymore, e.g. t_seclocks)

Hoping for an alternative

If they can't provide an alternative solution, I'm guessing I'll have to resort to a direct database connection to execute these type of queries/updates.
The upside of that would be that it would be a lot faster then going through Repository.SQLQuery
Obvious downside if that you have to manage your own database connection.

Geert

2

General Board / Re: Repository.Execute no longer works in JScript

« on: August 10, 2026, 04:55:19 pm »

I'm guessing this is one of the "security" fixes, but I'm pretty worried about that myself.

There are quite some things that are not possible in the API without resorting to the Repository.Execute backdoor method.
If this method is indeed no longer available, that would break quite a few of my add-ins and scripts.

Geert

3

Automation Interface, Add-Ins and Tools / Re: Database Query Restrictions in Enterprise Architect 17.2

« on: August 10, 2026, 04:51:57 pm »

Additionally, the `Repository.SQLQuery()` method apparently only allows `SELECT` queries, meaning that it can no longer be used to execute `INSERT` or `UPDATE` statements.

This has always been the case. For insert or update statements, you needed Repository.Execute(), which apparently has been disabled as well.

Geert

4

General Board / Re: Performance impact of reverse-engineering large databases

« on: August 10, 2026, 04:48:31 pm »

Hi Andrea,

The reverse engineering process itself, importing thousands of tables might take a (very) long time.
Once imported I don't believe it will have an impact on the performance of your repository.
I don't see a benefit to splitting that up into different repositories.

But you might want to think about the whole reverse engineering/comparing those very large databases.
We eventually settled on importing only a the subset of tables that we were actually using (of a large ERP system). That is about 600 tables instead of 8000. That was much faster to import/compare

Geert

5

Automation Interface, Add-Ins and Tools / Re: Link icons to my Azure cloud toolbox page in my MDG profile

« on: June 11, 2026, 01:59:16 pm »

That actually does not works on my side  but does it means that Azure Image collection content (or at least the few dozens images I need..) should be loaded in IM one by one after being converted ?
 

Eric

Yes, I think so. It's been a while since I played with images in shapescripts.
In general I prefer to draw my igages with an actual shapescript and not use those images. They tend to slow down loading a diagram if you have a lot of them.

Geert

6

Automation Interface, Add-Ins and Tools / Re: Link icons to my Azure cloud toolbox page in my MDG profile

« on: June 11, 2026, 02:18:39 am »

Eric, there are two types of "images".

The icon you assign your stereotype. That will be shown in the toolbox and project browser
And then the image you want to show on the diagram.

That is actually set in the shapescript.
Assinging an image to your stereotype element doesn't have any effect in your MDG.

Geert

7

PCS Frequently Asked Questions / Re: Possible to check differences through a web interface?

« on: June 05, 2026, 09:22:53 pm »

Hi Mikael, kind of late to respond, but I wanted to add that Prolaborate has a Versions Explorer mechanism which can be used to show the different versions of your EA model for Prolaborate users.

https://prolaborate.sparxsystems.com/resources/v5-documentation/version-explorer

The caveat is that it requires each version of the model to be maintained in its own separate repository. Not sure if it fits your use case, but figured it was worth mentioning.

Nabil

Nabil,

Have you really tried to use that feature in the real world?
In my experience, clients who purchase Prolaborate are larger organizations that generally use a central database
They can't be creating a new repository for each "version" of each diagram.

For me this is a pure "sales" feature. It looks good in a demo, but it utterly useless in the real world.

Geert

8

Automation Interface, Add-Ins and Tools / Re: Reading EA Version

« on: June 02, 2026, 09:48:37 pm »

I don't think there's a direct property in the API you can query.

So you'll have to do it with a workaround. And that workaround will be different depending on the langueage you are using.

On Stackoverflow I found something like this https://stackoverflow.com/questions/7759715/check-if-my-program-is-running-in-32-bit-mode-on-a-64bit-machine-if-running-in#:~:text=You%20can%20use%20IntPtr.,if%20running%20as%2064%20bit.

Code: [Select]

private static bool Is64BitConfiguration()
{
     return System.IntPtr.Size == 8;
}
Geert

9

Automation Interface, Add-Ins and Tools / Re: Make an attribute a PK in target table of a transformation to DDL

« on: May 26, 2026, 07:13:07 pm »

Hi Richard,

I'm not convinced the transform templates are capable of correctly transforming a logical model into a relational database model.
I think there is too much, and too complex logic involved to be able to solve that with the template approach.

I wrote an add-in for a specific client to automate this transformation https://bellekens.com/ea-database-transformer/
This add-in is unlikely to be useful for anyone else, but the logic involved in transforming an LDM to a DB model is not simple.

There are a lot of complexities to think about
- flattening inheritance
- datatype transformation
- naming conventions
- converting associations into FK's (especially many-to-many associations)
- ...

Geert

10

Automation Interface, Add-Ins and Tools / Re: Set Label Colour and Transparency in Shape Scripts

« on: May 26, 2026, 07:06:09 pm »

You can override the standard labels, and define how they should look like.
I guess that is where you can also set the fontcolor etc...

Code: [Select]

label middlebottomlabel
{
      println("#NAME#");
}
Geert

11

General Board / Re: Security Vulnerability with Sparx EA CVE-2026-42098

« on: May 21, 2026, 06:42:23 pm »

I think the "security" feature is a bit of a misnomer.
It's more like a feature to protect users from themselves.

It's not "real" security.
If you know what you are doing you can quite easily give yourself admin rights in EA and do whatever you want.

If you give users access to your repository you should trust them to not be bad actors.
If you can't, you shouldn't give them access.

That's different for something like Prolaborate. This product is intended to be accessible from the (big bad) internet, and it should have "real" security.

Geert

12

Bugs and Issues / Re: Attributes not displayed in same order i WebEA as in Sparx

« on: May 19, 2026, 12:00:27 am »

How they show on a diagram is not specific for WebEA (or Prolaborate).
The diagram is shown as an image, and it generated by EA.

It could be that WebEA is still showing an old version of the diagram (with attributes in a different order).
You can test that by changing something else on the diagram, and saving it.
That should trigger the re-generation of the diagram image.

Geert

13

General Board / Re: How to Disable Stereotypes Globally EA 17.1

« on: May 16, 2026, 03:41:46 pm »

The easiest will be to use the template package I think.

Geert

14

General Board / Re: Property Type via Script

« on: May 12, 2026, 08:40:07 pm »

Not sure if this applies to your case as well, but for attributes there are actually two field.
One field
t_Attribute.Type is the name of the type
t_Attribute.Classifier is the ID of the datatype for this attribute.

The standard dropdown (int, string, boolean) only sets the type field. If you use Select Type, the Classifier will be filled in (as well as the type field)

Geert

15

Bugs and Issues / Re: "Set as model default" does not appear

« on: May 07, 2026, 04:15:19 am »

https://sparxsystems.com/enterprise_architect_user_guide/17.1/modeling_fundamentals/usr_model-default_diags.html

Geert