Leanpub Header

Skip to main content
Go to Leanpub.comLeanpub

Inside Enterprise Architect

Querying EA's Database

Thomas Kilian
If you ever wondered what happens behind the scenes in Enterprise Architect you should have a look into this book. It's the prefect map for the twisty little passages, all alike in EA. The current issue has been updated to match the new GUI found in V12.

Minimum price

$17.99

$26.99

You pay

$26.99

Author earns

$21.59
$

...Or Buy With Credits!

You can get credits monthly with a Reader Membership
PDF
EPUB
WEB
127
Pages
About

About

About the Book

This book shows details of what is at the low level of EA: its database. The information gathered in this book is a summary of what has been found out by quite a number of EA users including me. If you need to dive into details which the official API does not provide, this book is what you might have been looking for.

Share this book

Categories

Software

Feedback

Email the Author

Author

About the Author

Thomas Kilian

Working since mid 1970's in the IT industry. Having gone through development and management in almost all industries (international but based in Germany). Currently focused on UML based projects (Embedded Systems/SysML, SOA, BPMN). Using (and dissecting) EA since 2003 (version 3.5) until today. Honestly I stopped at version 13.5 since it got only worse and washing my hands did not feel being enough. I might hop on the train again if the situation will get better.

Contents

Table of Contents

1.Preface

2.Copyright and Disclaimer

3.Accessing the Database

  1. 3.1Inspecting EA’s Tables
  2. 3.2Ways to Query Tables
  3. 3.3A List of All Tables

4.Most Important Tables

  1. 4.1More things than you find in the Project Browser: t_object
  2. 4.2The Repository Structure: t_package
  3. 4.3The Diagram Frame: t_diagram
  4. 4.4Elements Inside Diagrams: t_diagramobjects
  5. 4.5Non-Standard Connectors: t_diagramlinks
  6. 4.6Connecting Elements: t_connector

5.Element Feature Tables

  1. 5.1Attributes: t_attribute
  2. 5.2Operations: t_operation

6.Tagged Value Tables

  1. 6.1Element Tagged Values: t_objectproperties
  2. 6.2Attribute Tagged Values: t_attributetag
  3. 6.3Operation Tagged Values: t_operationtag
  4. 6.4Connector Tagged Values: t_connectortag

7.Security Related Tables

  1. 7.1Settings: t_secpolicies
  2. 7.2Users: t_secuser
  3. 7.3Groups: t_secgroup
  4. 7.4Assignment of users to groups: t_secusergroup
  5. 7.5Group permissions: t_secgrouppermission
  6. 7.6User permissions: t_secuserpermission
  7. 7.7Locks: t_seclocks

8.Rarely Used Tables

  1. 8.1Stereotypes: t_stereotypes
  2. 8.2Not the Tagged Values: t_taggedvalue
  3. 8.3Attribute Constraints: t_attributeconstraints
  4. 8.4Table Attribute Tags: t_attributetag
  5. 8.5Linked Documents and Baselines: t_document
  6. 8.6Mixed option: t_genopt
  7. 8.7Alternate Images: t_image
  8. 8.8User Defined Scripts: t_script
  9. 8.9Element Requirements: t_objectrequires
  10. 8.10Element Constraints: t_objectconstraints
  11. 8.11Element Files: t_objectfiles
  12. 8.12Scenarios for (mainly) Use Cases: t_objectscenarios
  13. 8.13Parameters for Operations: t_operationparms
  14. 8.14Various Profiles: t_trxtypes
  15. 8.15Status Types: t_lists
  16. 8.16Maintenance: t_objectproblems
  17. 8.17Various Profiles: t_xrefsystem
  18. 8.18RTF: t_rtf
  19. 8.19Repository Settings: usys_system
  20. 8.20Auditing: t_snapshot

9.Marvelous References

  1. 9.1A simple table: t_xref
  2. 9.2Definition of Multi-Stereotypes
  3. 9.3Default Composite Diagrams
  4. 9.4Profile file locations

10.API Cross References

  1. 10.1t_package — EaPackage
  2. 10.2t_object — EaElement

11.Bits and Pieces

  1. 11.1CSV Lists
  2. 11.2Object Types
  3. 11.3What is an Instance
  4. 11.4Concurrency
  5. 11.5GUID
  6. 11.6Object Run State Property
  7. 11.7TPos Property
  8. 11.8Object StyleEx Property
  9. 11.9Package Flags Property
  10. 11.10Diagram PDATA Property
  11. 11.11Diagram Swimlanes Property
  12. 11.12Diagram StyleEx Property
  13. 11.13DiagramObject ObjectStyle Property
  14. 11.14Connector SubType Property
  15. 11.15Connector Direction Property
  16. 11.16Connector PDATA5 Property
  17. 11.17Connector StateFlags Property
  18. 11.18Connector StyleEx Property
  19. 11.19Binary Data
  20. 11.20RGB Values
  21. 11.21Boundaries and Placeholders

12.User Settings

  1. 12.1Registry
  2. 12.2APPDATA
  3. 12.3PROGRAMFILES
  4. 12.4Multiple EAs in Parallel

13.GUI References

  1. 13.1Element
  2. 13.2Diagram
  3. 13.3Diagram Element Context
  4. 13.4Connector
  5. 13.5Attributes
  6. 13.6Operations
  7. 13.7Miscellaneous

14.Query Caveats

  1. 14.1Debugging SQL

15.SQL Search Builder

  1. 15.1Search Results
  2. 15.2Search Tagging
  3. 15.3Some Sample Queries
  4. 15.4Combine Script with Search

16.Further Reading

  1. 16.1Feedback
  2. 16.2Scripting Enterprise Architect
  3. 16.3Sparx Forum
  4. 16.4Sparx Community
  5. 16.5SQL in General
  6. 16.6Geert Bellekens

Get the free sample chapters

Click the buttons to get the free sample in PDF or EPUB, or read the sample online here

Download Sample PDFDownload Sample EPUBRead Sample OnlineRead online

The Leanpub 60 Day 100% Happiness Guarantee

Within 60 days of purchase you can get a 100% refund on any Leanpub purchase, in two clicks.

Now, this is technically risky for us, since you'll have the book or course files either way. But we're so confident in our products and services, and in our authors and readers, that we're happy to offer a full money back guarantee for everything we sell.

You can only find out how good something is by trying it, and because of our 100% money back guarantee there's literally no risk to do so!

So, there's no reason not to click the Add to Cart button, is there?

See full terms...

Earn $8 on a $10 Purchase, and $16 on a $20 Purchase

We pay 80% royalties on purchases of $7.99 or more, and 80% royalties minus a 50 cent flat fee on purchases between $0.99 and $7.98. You earn $8 on a $10 sale, and $16 on a $20 sale. So, if we sell 5000 non-refunded copies of your book for $20, you'll earn $80,000.

(Yes, some authors have already earned much more than that on Leanpub.)

In fact, authors have earned over $14 million writing, publishing and selling on Leanpub.

Learn more about writing on Leanpub

Free Updates. DRM Free.

If you buy a Leanpub book, you get free updates for as long as the author updates the book! Many authors use Leanpub to publish their books in-progress, while they are writing them. All readers get free updates, regardless of when they bought the book or how much they paid (including free).

Most Leanpub books are available in PDF (for computers) and EPUB (for phones, tablets and Kindle). The formats that a book includes are shown at the top right corner of this page.

Finally, Leanpub books don't have any DRM copy-protection nonsense, so you can easily read them on any supported device.

Learn more about Leanpub's ebook formats and where to read them

Write and Publish on Leanpub

You can use Leanpub to easily write, publish and sell in-progress and completed ebooks and online courses!

Leanpub is a powerful platform for serious authors, combining a simple, elegant writing and publishing workflow with a store focused on selling in-progress ebooks.

Leanpub is a magical typewriter for authors: just write in plain text, and to publish your ebook, just click a button. (Or, if you are producing your ebook your own way, you can even upload your own PDF and/or EPUB files and then publish with one click!) It really is that easy.

Learn more about writing on Leanpub