ER diagram for Campaign

Avatar

Avatar
Ignite 1
Level 2
mohiniu12161390
Level 2

Likes

3 likes

Total Posts

9 posts

Correct reply

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

Avatar
Ignite 1
Level 2
mohiniu12161390
Level 2

Likes

3 likes

Total Posts

9 posts

Correct reply

0 solutions
Top badges earned
Ignite 1
Validate 1
Boost 3
Boost 1
View profile
mohiniu12161390
Level 2

18-07-2019

Hi All,

I am looking for some way to generate the ER diagram on the Adobe campaign v7 database. Tried to use the ERD tools available like DB viewer etc.but it is not showing any cardinality or linking between the tables on the keys.

Can someone please guide me on how can we generate the ER diagram from underlying database used by Adobe Campaign. Showing the links is very important in this case.

Thanks,

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Boost 5
Level 4
AbdulZa
Level 4

Likes

43 likes

Total Posts

50 posts

Correct reply

8 solutions
Top badges earned
Boost 5
Boost 3
Boost 25
Boost 10
Boost 1
View profile

Avatar
Boost 5
Level 4
AbdulZa
Level 4

Likes

43 likes

Total Posts

50 posts

Correct reply

8 solutions
Top badges earned
Boost 5
Boost 3
Boost 25
Boost 10
Boost 1
View profile
AbdulZa
Level 4

18-07-2019

Hi,

You can use data modeling tool (e.g., ERwin) to reverse engineering the ACC system DB (mart tables) and it will produce the physical data model. As Ramon said, if the PK-FK relationships are not enforced in the DB by ACC, the physical model will not reflect such relationships. However, it should not be a hard task to go table by table to define these relationships in your data model based on experience, common column names and as well as simple data profiling/queries. For example, Operation and Delivery are 1:M, Delivery and BroadLogRcp are 1:M, etc.

Probably, this is 8-10 hour task if you are good in using a data modeling tool, else it will take someone 24-32 hours to build a correct data model (w/ all columns) to reflect the ACC system tables (NMS, XTK, etc.)

Thanks.

Answers (5)

Answers (5)

Avatar

Avatar
Boost 250
Employee
ramon_bisswanger
Employee

Likes

270 likes

Total Posts

397 posts

Correct reply

198 solutions
Top badges earned
Boost 250
Affirm 100
Give Back 25
View profile

Avatar
Boost 250
Employee
ramon_bisswanger
Employee

Likes

270 likes

Total Posts

397 posts

Correct reply

198 solutions
Top badges earned
Boost 250
Affirm 100
Give Back 25
View profile
ramon_bisswanger
Employee

18-07-2019

The links are not enforced as FOREIGN KEYs on the database side.

Thus, you can't automatically create it just based on the DB information.

You rather would have to implement something which is parsing the schemas within Adobe Campaign and translate that into a diagram.

Avatar

Avatar
Validate 250
Level 10
pablo_rosero1
Level 10

Likes

81 likes

Total Posts

348 posts

Correct reply

77 solutions
Top badges earned
Validate 250
Validate 100
Validate 50
Validate 25
Validate 10
View profile

Avatar
Validate 250
Level 10
pablo_rosero1
Level 10

Likes

81 likes

Total Posts

348 posts

Correct reply

77 solutions
Top badges earned
Validate 250
Validate 100
Validate 50
Validate 25
Validate 10
View profile
pablo_rosero1
Level 10

18-07-2019

Moved to Adobe Campaign Classic​. Thanks Ramon!

Avatar

Avatar
Boost 250
Employee
ramon_bisswanger
Employee

Likes

270 likes

Total Posts

397 posts

Correct reply

198 solutions
Top badges earned
Boost 250
Affirm 100
Give Back 25
View profile

Avatar
Boost 250
Employee
ramon_bisswanger
Employee

Likes

270 likes

Total Posts

397 posts

Correct reply

198 solutions
Top badges earned
Boost 250
Affirm 100
Give Back 25
View profile
ramon_bisswanger
Employee

18-07-2019

pablo.rosero​: can you move this to the Campaign Classic forum just to have it at the right place.

Avatar

Avatar
Ignite 1
Level 2
mohiniu12161390
Level 2

Likes

3 likes

Total Posts

9 posts

Correct reply

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

Avatar
Ignite 1
Level 2
mohiniu12161390
Level 2

Likes

3 likes

Total Posts

9 posts

Correct reply

0 solutions
Top badges earned
Ignite 1
Validate 1
Boost 3
Boost 1
View profile
mohiniu12161390
Level 2

18-07-2019

Thanks!

Avatar

Avatar
Ignite 1
Level 2
mohiniu12161390
Level 2

Likes

3 likes

Total Posts

9 posts

Correct reply

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

Avatar
Ignite 1
Level 2
mohiniu12161390
Level 2

Likes

3 likes

Total Posts

9 posts

Correct reply

0 solutions
Top badges earned
Ignite 1
Validate 1
Boost 3
Boost 1
View profile
mohiniu12161390
Level 2

18-07-2019

Thanks for the direction here...