Sparx Systems Forum
Enterprise Architect => Automation Interface, Add-Ins and Tools => Topic started by: Richard Freggi on October 20, 2023, 02:49:14 pm
-
Hello, EA 16 professional, *.qea project on my PC. I'm reverse engineering a SQL Server database; the ODBC connection worked fine. However I need to query the database system views to extract the DDL of views and procedures and view/procedure attributes (it was not retrieved with the reverse engineering). I've done this before using DBeaver, but I don't have JDBC connection to this database. Does EA have a SQL terminal window that I can open and run my queries on a non-project database? Can the results be exported as csv. I really don't want to install SSM or Azure studio. Thanks!
-
Yes, from the database builder you can execute queries on the target database.
https://sparxsystems.com/enterprise_architect_user_guide/16.1/modeling_domains/dbexplorer_scratchpad.html (https://sparxsystems.com/enterprise_architect_user_guide/16.1/modeling_domains/dbexplorer_scratchpad.html)
Geert
-
*sad noises* thanks Geert but professional does not have DB builder I think...
-
*sad noises* thanks Geert but professional does not have DB builder I think...
Could be. EA licenses start at Corporate for me.
Nobody should be using professional in a professional context.
Geert
-
When I did the trials I did not notice any major benefits in Corporate - for example the database builder thing is something I can do better myself I thought. What benefits do you see in Corporate version? Genuinely interested to know.
-
When I did the trials I did not notice any major benefits in Corporate - for example the database builder thing is something I can do better myself I thought. What benefits do you see in Corporate version? Genuinely interested to know.
- use a database backend
- scripting
Without those (especially the first) it's only good for hobbyists (or solo modellers)
EA's Corporate licenses are dirt cheap, the price difference between Professional and Corporate amounts to just a couple of hours work max (in Europe), so it's an easy ROI.
Geert
-
When I did the trials I did not notice any major benefits in Corporate - for example the database builder thing is something I can do better myself I thought. What benefits do you see in Corporate version? Genuinely interested to know.
- use a database backend
- scripting
Without those (especially the first) it's only good for hobbyists (or solo modellers)
EA's Corporate licenses are dirt cheap; the price difference between Professional and Corporate amounts to just a couple of hours work max (in Europe), so it's an easy ROI.
Geert
Wot 'e sed!
Plus, I find Database Builder (for Reverse Engineering at least) a big improvement on its predecessor.
Paolo