DED Utility

vipin_b_mittal

23-04-2019

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

Accepted Solutions (1)

Accepted Solutions (1)

Venu_Reddy

MVP

23-04-2019

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

Answers (1)

Answers (1)

wodnicki

MVP

23-04-2019

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