ER Diagram for Adobe Campaign Database | Community
Skip to main content
M
mohiniu12161390
Level 2
July 18, 2019
Solved

ER Diagram for Adobe Campaign Database

  • July 18, 2019
  • 5 replies
  • 4483 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 pulkit2304

    mohiniu12161390​,

    Not an ER generation tool but you can refer the ERD's available here for Out of the box schema.
    Description of the main tables

    Your best bet will be to add you custom schema and create one manually.

    Also, this is not exactly what you are looking for, but there is an automated process to generate a data dictionary that will help you understand the struct of your data model.

    How to generate a Data Model or Data Dictionary

    Thanks,

    Pulkit

    5 replies

    P
    Adobe Employee
    pulkit2304Adobe EmployeeAccepted solution
    Adobe Employee
    July 19, 2019

    mohiniu12161390​,

    Not an ER generation tool but you can refer the ERD's available here for Out of the box schema.
    Description of the main tables

    Your best bet will be to add you custom schema and create one manually.

    Also, this is not exactly what you are looking for, but there is an automated process to generate a data dictionary that will help you understand the struct of your data model.

    How to generate a Data Model or Data Dictionary

    Thanks,

    Pulkit

      P
      Adobe Employee
      pulkit2304Adobe Employee
      Adobe Employee
      July 19, 2019

      Moderator, Can you please move this thread to Adobe Campaign Classic?

      Thanks,

      Pulkit

      pablo_rosero1
      pablo_rosero1
      Level 9
      July 22, 2019

      Moved to Adobe Campaign Classic​

      C
      Adobe Employee
      ChristopheProtatAdobe Employee
      Adobe Employee
      September 12, 2020

      Hi,

       

      Better late than never 🙂 Here is a custom UI to explore data model including links. This is full custom work and not supported as a Product Feature. That being said, it could be very useful for you : https://github.com/ChrisRedfield126/ac-campaign-analyzer

       

      Hope it will help

      Christophe

       

      C
      Adobe Employee
      ChristopheProtatAdobe Employee
      Adobe Employee
      September 12, 2020

      Submited twice. Sorry 🙂

      Terms & ConditionsAccessibility statement

      Loading footer...