Expand my Community achievements bar.

Announcing the launch of new sub-community for Campaign Web UI to cater specifically to the needs of Campaign Web UI users!
SOLVED

DED Utility

Avatar

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

Avatar

Correct answer by
Level 8

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

Avatar

Correct answer by
Level 8

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

Avatar

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