ER diagram for Campaign | Community
Skip to main content
Level 2
July 18, 2019
Solved

ER diagram for Campaign

  • July 18, 2019
  • 6 replies
  • 6666 views

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,

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 AbdulZa

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.

6 replies

Adobe Employee
July 18, 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.

Adobe Employee
July 18, 2019

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

pablo_rosero1
Level 9
July 18, 2019

Moved to Adobe Campaign Classic​. Thanks Ramon!

AbdulZaAccepted solution
Level 3
July 18, 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.

Level 2
July 19, 2019

Thanks for the direction here...

Level 2
July 19, 2019

Thanks!