DED Utility

Avatar

Avatar
Validate 1
Level 1
vipin_b_mittal
Level 1

Like

1 like

Total Posts

2 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile

Avatar
Validate 1
Level 1
vipin_b_mittal
Level 1

Like

1 like

Total Posts

2 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile
vipin_b_mittal
Level 1

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)

Avatar

Avatar
Springboard
MVP
Venu_Reddy
MVP

Likes

163 likes

Total Posts

171 posts

Correct reply

53 solutions
Top badges earned
Springboard
Establish
Give Back 25
Give Back 10
Give Back 5
View profile

Avatar
Springboard
MVP
Venu_Reddy
MVP

Likes

163 likes

Total Posts

171 posts

Correct reply

53 solutions
Top badges earned
Springboard
Establish
Give Back 25
Give Back 10
Give Back 5
View profile
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)

Avatar

Avatar
Establish
MVP
wodnicki
MVP

Likes

977 likes

Total Posts

1,096 posts

Correct reply

516 solutions
Top badges earned
Establish
Affirm 500
Contributor
Shape 1
Give Back 100
View profile

Avatar
Establish
MVP
wodnicki
MVP

Likes

977 likes

Total Posts

1,096 posts

Correct reply

516 solutions
Top badges earned
Establish
Affirm 500
Contributor
Shape 1
Give Back 100
View profile
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