EA database details?

[Rudy]

Can anyone provide me with the details of the EA database, and how the information is stored in the database so I can define my own queries on the database, please?

I need to get a number of reports out of the system in Excel format and EA does not support me in creating these reports.

Thanks in advance.

[«Midnight»]

You can open an EAP file using MS Access. Access might open the file as read-only, but that's OK (or even better than OK if you are a klutz like me). Use Access to examine the file.

If you have experience with SQL it might be easier to download one or more (depending on which flavours of DBMS you are most comfortable with) of the DBMS set up scripts from the Resources section of the Sparx site. Look for the various xxxBaseModel.sql files. These contain the structure of the database as DDL statements.

Another idea is to play around with the EA Advanced Search. Not everyone uses this, but it can be a powerful tool - you can even enter your own SQL statements and save the searches.

You can reach the Search view from the EA main menu via View | Report and Search View. The hot key is Ctrl-Alt-R. There is even a toolbar button, but it is not displayed in the default configuration.

This view comes up in Report mode by default. Click Search View in the Mode radio button to get to the Search pane. Now click the Advanced button and set the Search List dropdown to something other than Simple. Now you're ready to experiment. You can enter SQL fragments in the Search Term box.

HTH, David

[Bruno.Cossi]

Reverse engineering an EAP file into EA actually helps a lot :-)

Bruno

[«Midnight»]

That's a much better idea...