ER Diagram for Adobe Campaign Database

[mohiniu12161390]

Hi All,

I am looking for some way to generate the ER diagram on the Adobe campaign v7 database. Tried to use the ERD tools available like DB viewer etc.but it is not showing any cardinality or linking between the tables on the keys.

Can someone please guide me on how can we generate the ER diagram from underlying database used by Adobe Campaign. Showing the links is very important in this case.

Thanks,

[pulkit2304 · Accepted solution]

mohiniu12161390​,

Not an ER generation tool but you can refer the ERD's available here for Out of the box schema.
Description of the main tables

Your best bet will be to add you custom schema and create one manually.

Also, this is not exactly what you are looking for, but there is an automated process to generate a data dictionary that will help you understand the struct of your data model.

How to generate a Data Model or Data Dictionary

Thanks,

Pulkit

[pulkit2304]

Moderator, Can you please move this thread to Adobe Campaign Classic?

Thanks,

Pulkit

[pablo_rosero1]

Moved to Adobe Campaign Classic​

[ChristopheProtat]

Hi,

Better late than never Here is a custom UI to explore data model including links. This is full custom work and not supported as a Product Feature. That being said, it could be very useful for you : https://github.com/ChrisRedfield126/ac-campaign-analyzer

Hope it will help

Christophe

[ChristopheProtat]

Submited twice. Sorry