Messages

1

General Board / Re: Evaluating EA 16: UML 2.x XMI export incredibly slow

« on: August 02, 2022, 01:00:09 pm »

Confirmed!  XMI 1.1 export works fine.  So it is a bug on 2.1 but 1.1 is fine for me.  Thanks Paolo!!!

2

General Board / Evaluating EA 16: UML 2.x XMI export incredibly slow

« on: August 02, 2022, 01:49:25 am »

I downloaded eval copy of EA 16, imported some models from my old EA 13 via UML 2.1 XMI, no problem.
Now I'm exporting them back from EA16 to UML 2.1 XMI and it's incredibly slow, minutes per object and I have 10K objects in the model

Before I submit a bug report I'd like to check if others are seeing the same thing?
PS I know there's native XMI now, just wanted to know if UML 2.x is a bug or what

3

Automation Interface, Add-Ins and Tools / Re: v16 - Project Integrity Check does NOT check Object Type

« on: July 21, 2022, 10:54:47 am »

Having an object of the wrong type is not necessarily an integrity issue, so I'm not convinced that EA integrity check should necessarily correct it.  What would it change it to? There could be multiple options for the object type.

My thinking is that wrong object type is a design validation issue and I don't think EA has that feature.

4

General Board / Re: Messages from one sequence diagram to another?

« on: July 05, 2022, 02:04:24 am »

I haven't done interaction diagrams for several months so working from memory.  If I understand what you want to do I think it's possible but you have to follow UML.
I think you would need to use an interaction use = a combined fragment of REF type.  The interaction use is self-contained so don't write it as a part of a larger interaction diagram and expect to use that snippet in another diagram.  That is not UML.  You need to make a separate complete sequence diagram for the interaction use, then drag it  onto the OTHER sequence diagrams that use it.  Dragging will create a combined fragment of type REF. 

Using classes instead of objects in sequence diagrams can be problematic both in UML proper as well as in Sparx EA specifically.  I'm not sure if your model would be negatively affected by using objects of the application classes for the diagrams.

I think every operation in a class should be used in as many scenarios as possible, so hopefully the cardinality "class operation" : "interaction diagram" (regardless if normal interaction, combined fragment or interaction use) should be 1 .. m and not 1 .. 1.  Otherwise you will have a lot of redundant operations that do similar things in different interactions.

uml-diagrams.org remains the best introduction to UML ... you can find more details here:

https://www.uml-diagrams.org/sequence-diagrams.html#interaction-use

HTH!

5

General Board / Re: Confirm that EA 16 is NOT buggy for PostgreSQL reverse engineering? [solved]

« on: June 24, 2022, 06:31:02 pm »

Answering my own question.  No problem with PostgreSQL and EA 16, I used the 64 bit driver in my computer (incompatible with EA 32 bit) and it worked fine.

6

General Board / Re: SQLite is way faster than SQL Server

« on: June 17, 2022, 12:32:16 am »

Hey Geert,
I'd be be curious to know if you have found a way to make the SQLite repository work in-memory ("file::memory:" parameter).
I don't know if EA supports this repository mode, and it would not be ACID until the database is saved to disk.  But potentially it could be a real ripper!

p.s. also PRAGMA journal_mode = off and PRAGMA synchronous = off may speed even further if EA can tolerate them.

7

General Board / Re: WITH RECURSIVE support in Model Search / RTF templates

« on: June 14, 2022, 09:36:11 pm »

You should be able to access the EA QEA file with an SQLite frontend (DBeaver, SQLite studio... even the CLI) and run common table expressions which should support recursive queries

8

General Board / Re: SQLite Can't add 1+1?

« on: May 05, 2022, 02:50:18 pm »

It's treating "1" as TEXT datatype, so it's concatenating 2 strings

9

General Board / Re: SQLite Can't add 1+1?

« on: May 05, 2022, 12:57:47 am »

Your query runs on my native SQLite (I don't have EA V16)

By ANSI SQL I meant

SELECT 1+1 AS "Two", typeof(1) AS "Type1", typeof(1+1) AS "Type2"

|Two|Type1  |Type2  |
|----|--------|---------|
|2   |integer |integer |

SQLite defaults to TEXT datatype whenever possible, so it may be the EA 16 SQLite driver that's playing games on you

10

General Board / Re: SQLite Can't add 1+1?

« on: May 04, 2022, 08:48:45 pm »

Read up on sqlite.org, your syntax is off (SQLite is ANSI SQL, your query is not)

11

General Board / Re: Is EA 16 noticeably faster than previous versions?

« on: April 28, 2022, 12:24:25 am »

Thanks all.  So I should not expecting performance improvements, that's OK.  I need to keep my work machine as lean as possible so *.feap is good enough, no motivation to go to Oracle or other.  I do have a thing for open source solutions though after being burned by proprietary license changes a couple of times, so Firefox and SQLite and all related ecosystem solutions are definitely my favorites.

12

General Board / Is EA 16 noticeably faster than previous versions?

« on: April 27, 2022, 03:28:43 pm »

I'm using v 1310 and my *.feap (Firebird) model is about 1GB.  The PC is Win10 Intel i7 16GB RAM,  500M SSD.
It takes me about 15 hours to import total 500K elements (classes, attributes) into my model using Geert's importer.
It takes about 20 seconds to delete a single element from the project explorer.
It's possible that EA is slowed down by some antivirus thingy from my work PC, but I don't think so.

One hope of V16 is that using the lighter footprint SQLite (and maybe Sparx can find a way of letting us use SQLite 'memory' mode, with database loaded fully in RAM?) , I can reduce these times significantly.  Can anyone comment on performance improvement with *.QEA files compared to *.eap or *.feap?

13

Automation Interface, Add-Ins and Tools / Re: Import of connector data from Excel

« on: April 14, 2022, 12:32:50 pm »

Thanks to all for their contributions.
I'm still amazed...but I guess I'll have to do it in script.
The tools my customer has been looking at to do Architecture-management have loads of built-in importers for all kinds of data - not as addins, but part of the core proposition. I'm just embarassed...by EA's shortcomings, and my lack of product knowledge.

As far as I remember Office MDG is included in the ultimate version, so you could argue that EA does provide it out-of-the-box.  And EA's cost is just a fraction of the leading tools, so does not seem too bad from my perspective

14

Automation Interface, Add-Ins and Tools / Re: Import of connector data from Excel

« on: April 11, 2022, 09:49:35 pm »

I've looked extensively into it a couple of years back and I have not found any out-of-the-box way to import connectors (nor attributes!) into EA.  You must use Geert's importer (it can be modified to import connectors) or a plugin (I use Sparx Office integration MDG although I'm not a fan).

The reason is that in EA implementation, connectors and object properties like attributes are NOT objects themselves, so they are treated as an after-thought.  This may well be the UML spec, don't know, but surely makes our life more difficult.

p.s. if you are reverse engineering a database, you can import attributes and relationships automatically.  But you must connect to the database instance (no DML import)

15

General Board / EA 16: can anyone confirm if PostrgeSQL reverse engineering bug has been fixed?

« on: April 10, 2022, 06:12:54 pm »

On EA 1310 I cannot reverse engineer PostgeSQL, I remember seeing posts that explained that there was a bug in EA.
Is anyone evaluating v 16 able to confirm if PostgreSQL reverse engineering works on this version?  Thanks!!!