Author Topic: EA data model  (Read 830 times)

michielper

  • EA User
  • **
  • Posts: 120
  • Karma: +1/-0
    • View Profile
EA data model
« on: July 31, 2018, 08:04:46 pm »
Where do I find the complete EA data model? All tables and attributes that one can use in SQL queries.

peterc

  • EA User
  • **
  • Posts: 73
  • Karma: +4/-0
    • View Profile
Re: EA data model
« Reply #1 on: July 31, 2018, 09:51:16 pm »
Option 1 - the Automation.pdf guide in the PDF library (under Resources at the top of this page).
Option 2 - Change the extension of the EAP file (so long as you are using that format) to MDB and open it in Microsoft Access.

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 9305
  • Karma: +252/-27
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: EA data model
« Reply #2 on: July 31, 2018, 10:02:47 pm »
Reverse engineer an EA model into EA.

Geert

Sunshine

  • EA User
  • **
  • Posts: 846
  • Karma: +65/-4
  • Its the results that count
    • View Profile
Re: EA data model
« Reply #3 on: August 01, 2018, 06:48:50 am »
I've done what Geert recommends in the past and reverse engineered the repository to get a view of the database tables etc.
If you want to do queries you can use the search SQL Scratch pad built into Sparx EA or use MS Access for eap files or Visual Studio for SQL repositories.

However if you want to update stuff then its recommended you use the API and reference the automation documentation.
https://www.sparxsystems.com/resources/user-guides/14.0/index.html#automation

In addition Geert has also published a truck load of stuff on GitHub that can help with automation. Sorry don't have a reference for that at hand.

Hope that helps



Happy to help
:)

qwerty

  • EA Guru
  • *****
  • Posts: 10460
  • Karma: +230/-187
  • I'm no guru at all
    • View Profile
Re: EA data model
« Reply #4 on: August 01, 2018, 10:30:36 am »
For what purpose do you need it?

q.

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 9305
  • Karma: +252/-27
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: EA data model
« Reply #5 on: August 01, 2018, 03:51:26 pm »
In addition Geert has also published a truck load of stuff on GitHub that can help with automation. Sorry don't have a reference for that at hand.

You can find my Github stuff here: https://github.com/GeertBellekens

Geert

Guillaume

  • EA User
  • **
  • Posts: 763
  • Karma: +22/-0
    • View Profile
    • www.umlchannel.com
Re: EA data model
« Reply #6 on: August 01, 2018, 04:16:56 pm »
Inside EA ebook will provide all the details you're looking for. I recommend to purchase Scripting EA.

https://leanpub.com/InsideEA
Guillaume

Blog: www.umlchannel.com | Free utilities addin: www.eautils.com