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 - Richard Freggi

Pages: [1] 2 3 ... 33
1
General Board / Re: Incomplete or Buggy Snowflake DB Engineering
« on: July 19, 2025, 12:48:57 pm »
I had a few emails with Sparx sales and support because I bought the 17.1 license specifically for Snowflake and it failed completely to reverse engineer our database.  The parser threw errors where schema names were enclosed in double quotes (as needed) and when view columns had masking statements (as needed).  There were so many parser errors that I could not determine what else it could not do.  Sparx was nice enough but I recommend all interested to also email Sparx sales to increase the visibility of the fact that their product is useless for Snowflake and encourage them to come quickly up with a fix!

2
General Board / Re: Incomplete or Buggy Snowflake DB Engineering
« on: July 11, 2025, 10:05:38 pm »
I also have issues with Snowflake in EA 17.1.  I updated my license from 16 after obtaining written confirmation from Sparx Sales that 17.1 would reverse engineer Snowflake DDL.  it sorta kinda does -ish as long as the DDL is very plain.  In my case reverse engineering fails when views DDL has column masking statements.  So I have to manually edit the DDL before it's run thru EA. 

I really expect that Sparx matures its Snowflake offering before my license needs renewal!

3
No you still need a brain.  And lots of hard work. 

4
General Board / Re: Publish to Standard HTML
« on: June 20, 2025, 09:56:48 am »
I have the same problem... would be good to get a solution from Sparx!

5
I think this is normal.  I extract the column names by querying Oracle metadata and import them into the model with the Belleken importer.

6
Uml Process / Re: Best UML Diagrams for Requirements Gathering?
« on: May 16, 2025, 08:52:08 pm »
Use case diagrams for sure - but there's an art to structuring them to maximize their value. 
Under each use case, one or more sequence diagram.  The sequence diagram is by far the best way to capture who is using what information, what attribute, how they use it and why.  This is invaluable for data modeling but also system architecture, and also test definition.
Activity diagrams don't add much value beyond maybe user interface design as they just show procedural steps without capturing what information is used, where it comes from, where it goes to.  Personally I avoid them.

My 2c good luck!

7
Bugs and Issues / Re: Enterprise Architect Database SQL Issue
« on: February 27, 2025, 10:00:16 pm »
ChatGPT to convert DDL code from one DBMS to another?  Never tried it but may be worth a shot...

8
YESSSSSS!  Thank you very much

9
I reverse engineer several database types by querying their metadata objects, exporting to Excel and using Office MDG to import into EA (16.1).  Works well except that primary key columns are imported as <<pk>> stereotype but in EA it is treated as any stereotype and the PK -  NN boxes in the Properties window remain unchecked: EA does not recognize it as a primary key.  So I have to manually check the PK box for every column with a <<pk>> stereotype.
I would like to do that via a DML script like (pseudocode:) UPDATE t_attribute SET somethingsomething = 'pk' WHERE stereotype = 'pk' .  But In Inside EA book I could not find what table column needs to be updated and how.  If anybody knows please help!  Thanks!
ps sorry no time to learn VB or scripting languages... my only option is to run DML on the project database

11
General Board / Re: Elements and Associations are moving on their own...
« on: October 10, 2024, 01:57:57 am »
Use lock diagram menu (right click on the diagram)

12
Bugs and Issues / Re: Transfer from QEA to EAP fails
« on: September 03, 2024, 07:18:29 pm »
Looks like a wise suggestion from the Sparx gods.  Isn't MS access going to be discontinued?  (And the word will be a better place for it...)


13
Does UML support relationships between (different) relationships?
Not explicitly, but several of the relationships (eg. Dependency) have ends defined by types that include a number of relationships.

That doesn't necessarily mean that it's expected. LiteralNull is also a specialization of Element, so you could also have a dependency on a particular literal null. I don't think that's a reasonable interpretation of the intention of the specification.

Surprisingly I can draw a trace relationship from a relationship to itself in SparxEA. Is this intended?
I don't see a constraint on the specification that disallows it. You could argue that it's not expected by the authors of the spec, but I don't know how end users are using it. If you don't think it makes sense, don't use it.

I vaguely remember that in UML a relationship is a class and as such it can have its own associations to other classes.  In EA I can draw an association between a class and an association (eg intersection entity in a ERD diagram).  Am I remembering it wrong?

14
This one still hurts me bad:
Quote
In the current Office MDG it's impossible to set primary/Foreign key constraint on import of classifiers of type <<table>>.  This is a pity because the MDG allows us to reverse engineer any database using the DBMS object metadata.  My suggestion is:
3. Add capability to assign primary key constraint to any column to the classifier import profile (keep in mind composite keys)
4. Add capability to assign primary and foreign key constraint to any column to the connector detail profile (keep in mind composite foreign keys and primary key that include a FK)

PKs don't register as stereotype in reverse engineered tables, this seems like an oversight... such a basic but important feature....

15
General Board / Re: Get all elements of hierarchy
« on: August 10, 2024, 02:51:05 pm »
You can't use recursive queries in EA searches, or Repository.SQLQuery
They need the query to start with Select

You can cheat EA with internal query syntax, like below:
Code: [Select]
SELECT q.* FROM (
  <any_query_not_starting_with_select_keyword>
) q;

It works on PostgreSQL repository, and I'm pretty sure, this syntax (or similar) is possible in many other SQL engines.

I know I tried this a few years ago and couldn't get it to work for searches in SQL Server. I never really bothered anymore once the #Branch# macro became available.

Geert

Tried it in EA 16.1 on local SQLite project: EA crashed... too bad...

Pages: [1] 2 3 ... 33