Skip to main content
Apr 23, 2019 8:39 AM UTC
Solved

DED Utility

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Venu_Reddy
Venu_ReddyAccepted solution
Level 6
Apr 23, 2019 9:29 AM UTC

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

2 replies

Venu_Reddy
Venu_ReddyAccepted solution
Level 6
Apr 23, 2019 9:29 AM UTC

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

Translate
Jonathon_wodnicki
Community Advisor
Community Advisor
Apr 23, 2019 8:26 PM UTC

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

Translate