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

ER diagram for Campaign

Avatar

Level 2

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,

1 Accepted Solution

Avatar

Correct answer by
Level 4

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.

View solution in original post

6 Replies

Avatar

Employee Advisor

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

Employee Advisor

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

Avatar

Correct answer by
Level 4

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.