Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

ER Diagram for Adobe Campaign Database

Avatar

Level 2

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,

1 Accepted Solution

Avatar

Correct answer by
Employee

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

View solution in original post

5 Replies

Avatar

Correct answer by
Employee

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

Avatar

Employee

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

Thanks,

Pulkit

Avatar

Employee

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