Entity Relationship Diagram for Adobe Campaign Classic | Community
Skip to main content
shansjtrex
shansjtrex
Level 2
August 14, 2019

Entity Relationship Diagram for Adobe Campaign Classic

  • August 14, 2019
  • 1 reply
  • 7908 views

How do you generate an Entity Relationship Diagram for all Tables in Adobe Campaign Classic ? Can this be done with the client tool. Do we need to tap into the Classic API to do this ?

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

    1 reply

    Jonathon_wodnicki
    Community Advisor
    Jonathon_wodnickiCommunity Advisor
    Community Advisor
    August 15, 2019

    Hi,

    This is the closest you'll get:

    I've gotten this request a number of times now, it should be straightforward to write a script to generate an ERD from Campaign's schemas, just never had the time/budget.

    Thanks,

    -Jon

      shansjtrex
      shansjtrexAuthor
      Level 2
      August 15, 2019

      Thank you . How do you generate for custom built tables for different namespace.

      Jonathon_wodnicki
      Community Advisor
      Jonathon_wodnickiCommunity Advisor
      Community Advisor
      August 15, 2019

      You write a script to read the schemas written for the tables, then draw out the ERD from them.

      You can also use an off-the-shelf ERD generator and manually draw in all the relationships; I only mention the above due to the complexity of the ootb db, ~300 tables, 500 joins. Some people find that kind of stuff calming though.

        Terms & ConditionsAccessibility statement

        Loading footer...