ER diagram for Campaign

Avatar

Avatar

mohiniu12161390

Avatar

mohiniu12161390

mohiniu12161390

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

AbdulZa

Avatar

AbdulZa

AbdulZa

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

ramon_bisswange

Employee

Avatar

ramon_bisswange

Employee

ramon_bisswange
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

pablo_rosero1

Avatar

pablo_rosero1

pablo_rosero1

18-07-2019

Moved to Adobe Campaign Classic​. Thanks Ramon!

Avatar

Avatar

ramon_bisswange

Employee

Avatar

ramon_bisswange

Employee

ramon_bisswange
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

mohiniu12161390

Avatar

mohiniu12161390

mohiniu12161390

18-07-2019

Thanks!

Avatar

Avatar

mohiniu12161390

Avatar

mohiniu12161390

mohiniu12161390

18-07-2019

Thanks for the direction here...