Entity Relationship Diagram for Adobe Campaign Classic

[shansjtrex]

How do you generate an Entity Relationship Diagram for all Tables in Adobe Campaign Classic ? Can this be done with the client tool. Do we need to tap into the Classic API to do this ?

[Jonathon_wodnicki]

Hi,

This is the closest you'll get:

• https://docs.campaign.adobe.com/doc/AC6.1/en/technicalResources/IMG/datamodel_diagram.png

I've gotten this request a number of times now, it should be straightforward to write a script to generate an ERD from Campaign's schemas, just never had the time/budget.

Thanks,

-Jon

[shansjtrex]

Thank you . How do you generate for custom built tables for different namespace.

[Jonathon_wodnicki]

You write a script to read the schemas written for the tables, then draw out the ERD from them.

You can also use an off-the-shelf ERD generator and manually draw in all the relationships; I only mention the above due to the complexity of the ootb db, ~300 tables, 500 joins. Some people find that kind of stuff calming though.

[shansjtrex]

Thank you