Where are tagged values stored in the DB?

[seanassurant]

I'm writing some custom reporting services reports for EA and wondered if anyone knew where tagged values (like those attached to a Node element) were stored? And how they are linked to the element.

[Geert Bellekens]

Look in

• t_taggedValue
• t_attributeTag
• t_connectorTag
• t_operationTag

[Dermot]

In the SQL search editor - have a look at the description for t_objectProperties as well as t_TaggedValues. The first is the general table used for objects - second is for connectors.

[Dave_Bullet]

Actually, connector tagged values are held in t_connectortag

[Eve]

But tagged values on connector ends are stored on t_taggedvalues.

So:
Element tags: t_objectproperties
Attribute tags: t_attributetag
Operation tags: t_operationtag
Parameter tags: t_taggedvalue
Connector tags: t_connectortag
Connector end tags: t_taggedvalue

[fwoolz]

In general, one good way to get the feel for the EA database structure is to import an EAP file into EA as a database schema. Alternatively, create a new Access database and link to the tables in the EAP file of interest. The EAP file is, after all, a Jet (= Access, at least prior to 2007) database file! This presents the possibility of making changes to the EAP file in EA and observing the results on the database in Access and vice-versa. Just make sure to refresh the one application after making changes in the other!

Cheers,
Fred W