Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Entity Relationship Diagram for Adobe Campaign Classic

Avatar

Avatar
Give Back 3
Level 2
shansjtrex
Level 2

Likes

5 likes

Total Posts

13 posts

Correct Reply

0 solutions
Top badges earned
Give Back 3
Give Back
Ignite 1
Validate 1
Boost 5
View profile

Avatar
Give Back 3
Level 2
shansjtrex
Level 2

Likes

5 likes

Total Posts

13 posts

Correct Reply

0 solutions
Top badges earned
Give Back 3
Give Back
Ignite 1
Validate 1
Boost 5
View profile
shansjtrex
Level 2

14-08-2019

How do you generate an Entity Relationship Diagram for all Tables in Adobe Campaign Classic ? Can this be done with the client tool. Do we need to tap into the Classic API to do this ?

Replies

Avatar

Avatar
Establish
MVP
wodnicki
MVP

Likes

976 likes

Total Posts

1,096 posts

Correct Reply

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

Avatar
Establish
MVP
wodnicki
MVP

Likes

976 likes

Total Posts

1,096 posts

Correct Reply

514 solutions
Top badges earned
Establish
Affirm 500
Contributor
Shape 1
Give Back 100
View profile
wodnicki
MVP

15-08-2019

Hi,

This is the closest you'll get:

I've gotten this request a number of times now, it should be straightforward to write a script to generate an ERD from Campaign's schemas, just never had the time/budget.

Thanks,

-Jon

Avatar

Avatar
Give Back 3
Level 2
shansjtrex
Level 2

Likes

5 likes

Total Posts

13 posts

Correct Reply

0 solutions
Top badges earned
Give Back 3
Give Back
Ignite 1
Validate 1
Boost 5
View profile

Avatar
Give Back 3
Level 2
shansjtrex
Level 2

Likes

5 likes

Total Posts

13 posts

Correct Reply

0 solutions
Top badges earned
Give Back 3
Give Back
Ignite 1
Validate 1
Boost 5
View profile
shansjtrex
Level 2

15-08-2019

Thank you . How do you generate for custom built tables for different namespace.

Avatar

Avatar
Establish
MVP
wodnicki
MVP

Likes

976 likes

Total Posts

1,096 posts

Correct Reply

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

Avatar
Establish
MVP
wodnicki
MVP

Likes

976 likes

Total Posts

1,096 posts

Correct Reply

514 solutions
Top badges earned
Establish
Affirm 500
Contributor
Shape 1
Give Back 100
View profile
wodnicki
MVP

15-08-2019

You write a script to read the schemas written for the tables, then draw out the ERD from them.

You can also use an off-the-shelf ERD generator and manually draw in all the relationships; I only mention the above due to the complexity of the ootb db, ~300 tables, 500 joins. Some people find that kind of stuff calming though.

Avatar

Avatar
Give Back 3
Level 2
shansjtrex
Level 2

Likes

5 likes

Total Posts

13 posts

Correct Reply

0 solutions
Top badges earned
Give Back 3
Give Back
Ignite 1
Validate 1
Boost 5
View profile

Avatar
Give Back 3
Level 2
shansjtrex
Level 2

Likes

5 likes

Total Posts

13 posts

Correct Reply

0 solutions
Top badges earned
Give Back 3
Give Back
Ignite 1
Validate 1
Boost 5
View profile
shansjtrex
Level 2

19-08-2019

Thank you