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
BedrockMission!

Learn more

View all

Sign in to view all badges

Entity Relationship Diagram for Adobe Campaign Classic

shansjtrex
Level 2
Level 2

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 ?

4 Replies
wodnicki
Community Advisor
Community Advisor

Hi,

This is the closest you'll get:

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
Level 2
Level 2

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

wodnicki
Community Advisor
Community Advisor

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.