DED Utility | Community
Skip to main content
New Participant
April 23, 2019
Solved

DED Utility

  • April 23, 2019
  • 2 replies
  • 2680 views

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.
Best answer by Venu_Reddy

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

Jonathon_wodnicki
New Participant
April 23, 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

Venu_Reddy
Venu_ReddyAccepted solution
New Participant
April 23, 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