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.
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.)
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.
Thanks for the direction here...