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

SOLVED

DED Utility

vipin_b_mittal
Level 1
Level 1

Hi Team,

Is there any utility to check the data model available in the instance. We need to check what all links are there in schema's in that complete data model.

Regards,

Vipin Mittal

1 Accepted Solution
Venu_Reddy
Correct answer by
Community Advisor
Community Advisor

Hello Vipin,

Using the Campaign Console Explorer view, write a simple JavaScript utility in Administration > Configuration > JavaScript codes.

Change the strOutputFile value to add the destination directory where you would like to create the Open Office document.

click here for more details How to generate a Data Model or Data Dictionary

And please find the similar thread Adobe Campaign Classic System tables data dictionary

Regards,

Venu

View solution in original post

2 Replies
Venu_Reddy
Correct answer by
Community Advisor
Community Advisor

Hello Vipin,

Using the Campaign Console Explorer view, write a simple JavaScript utility in Administration > Configuration > JavaScript codes.

Change the strOutputFile value to add the destination directory where you would like to create the Open Office document.

click here for more details How to generate a Data Model or Data Dictionary

And please find the similar thread Adobe Campaign Classic System tables data dictionary

Regards,

Venu

View solution in original post

wodnicki
Community Advisor
Community Advisor

Hi,

The data model generator will only show fields, similar to psql's \d.

Links is either a manual process of picking through the tables and noting their connections, or something automated via simple scripting.

ERD discovery tools can't be used since relationships are managed by Campaign, not the db, i.e. no foreign keys to read.

Thanks,

-Jon