Author Topic: Can I use EA as frontend to run SQL queries on SQL server database?  (Read 3066 times)

Richard Freggi

  • EA User
  • **
  • Posts: 483
  • Karma: +18/-7
    • View Profile
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!

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13179
  • Karma: +549/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: Can I use EA as frontend to run SQL queries on SQL server database?
« Reply #1 on: October 20, 2023, 03:26:56 pm »
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

Geert

Richard Freggi

  • EA User
  • **
  • Posts: 483
  • Karma: +18/-7
    • View Profile
Re: Can I use EA as frontend to run SQL queries on SQL server database?
« Reply #2 on: October 20, 2023, 03:31:06 pm »
*sad noises* thanks Geert but professional does not have DB builder I think...

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13179
  • Karma: +549/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: Can I use EA as frontend to run SQL queries on SQL server database?
« Reply #3 on: October 20, 2023, 03:35:44 pm »
*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

Richard Freggi

  • EA User
  • **
  • Posts: 483
  • Karma: +18/-7
    • View Profile
Re: Can I use EA as frontend to run SQL queries on SQL server database?
« Reply #4 on: October 20, 2023, 11:29:09 pm »
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.

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13179
  • Karma: +549/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: Can I use EA as frontend to run SQL queries on SQL server database?
« Reply #5 on: October 20, 2023, 11:45:26 pm »
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

Paolo F Cantoni

  • EA Guru
  • *****
  • Posts: 8571
  • Karma: +254/-129
  • Inconsistently correct systems DON'T EXIST!
    • View Profile
Re: Can I use EA as frontend to run SQL queries on SQL server database?
« Reply #6 on: October 21, 2023, 03:25:07 pm »
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
Inconsistently correct systems DON'T EXIST!
... Therefore, aim for consistency; in the expectation of achieving correctness....
-Semantica-
Helsinki Principle Rules!