EA Data model

[aghy]

I'd like to get some documentations about the EA database model. I mean, we've got an EA model with a MS SQL 2000 Database (used by OLE DB Provider), and I'd like understand the back-end database.
Could I do that?

Thanks,
Agnes

[thomaskilian]

Likely not. You can ask for the COM interface (which in my opinion deserves a bit of support ) but the database itself is not public. Any tips on using the database are ON YOUR OWN RISK.

[aghy]

Thx.

I'd just like to query (not to modify) the database, because we need some reports on it.

[thomaskilian]

I found that using my brain simply helped me in understanding the most important concepts. Also I got some hints from other users in this forum. So the best way would by to a) see what you can understand starting from t_object and b) asking the forum if it's something special. You can get recommendation even from Sparx themselves

[KP]

Agnes,

Further to Thomas's suggestions...

You might like to import the DDL schema of the database into EA to get a better visualisation of the database structure. Create a target package and right-click on it in the Project View, select "Code Engineering | Import DDL Schema from ODBC". Click the elipsis (...) button next to "Database Name", on the "Machine Data Source" tab double-click "MS Access Database", and in the Select Database dialog find an EAP file (C:\Program Files\Sparx Systems\EA\EABase.EAP will do as well as any other). Back at the Import DDL dialog click Import, Select All, OK, sit back and enjoy!

You can get some idea of the uses of the various tables by looking at Reference section of the Automation Interface help.

HTH,

Neil

[thomaskilian]

  That's exactly what I did in the beginning. But I simply forgot the model once I understood the main concepts.

[sargasso]

.... but I'd reeeeeelly like a copy of the automation model to assist in designing add-ins.

bruce