web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Entity Relationship Di...
Microsoft Dynamics AX (Archived)

Entity Relationship Diagrams for AX7

(0) ShareShare
ReportReport
Posted on by Community Member

Looking for an Entity Relationship Diagram for AX 7 - I would specifically like the general ledger one.  They have some for AX 2012 R2 but none for AX7.  Any mention of ERDs are at least three years old in the forums (unless I missed something).  Does anyone know where I might find one?  (NOTE: I primarily have access to Management Studio.  If you are going to suggest doing it myself with data tools - some guidance on how to do this would be great)  Any and all help much appreciated.

*This post is locked for comments

I have the same question (0)
  • Martin Dráb Profile Picture
    Martin Dráb 236,320 Most Valuable Professional on at
    RE: Entity Relationship Diagrams for AX7

    Note that in many cases, the data model is the same as in AX 2012, so a diagram written three years ago for AX 2012 may still be exactly what you need.

  • Suggested answer
    botten Profile Picture
    botten 320 on at
    RE: Entity Relationship Diagrams for AX7

    Sorry for this late answer, it might not even work in your situation... Nevertheless you could try one of these descriptions.

    1. With MS SQL Server Management Studio follow these steps:

    • MS SQL Server management Studio > File menu > "Connect Object Explorer"
    • Choose your Database node and expand it. under this node you'll find a sub-node called "Database Diagrams"
    • Right click on "Database Diagrams" > "New Database Diagram" > Add tables that you wish to see their columns, relationships, ...

     

    2. With Visual Studio, follow these steps:

    • Open Visual Studio
    • Create a project or open an existing project (must be Visual Basic, Visual C# project, or Console Application)
    • Right-click the project and choose Add -> New Item
    • Under Visual C# Items select “Data”
    • Select the template “ADO.NET Entity Data Model”
    • Give it a name and click “Add”
    • Select “Generate from database” or “Empty model”
    • If “Generate from database” selected enter connection info, choose the database objects and done!
    • The model is stored as a “.edmx” file.

     

  • Martin Dráb Profile Picture
    Martin Dráb 236,320 Most Valuable Professional on at
    RE: Entity Relationship Diagrams for AX7

    The reason why this approach won't work is that AX stores information about relationships in the application, not in database. And JJK is probably looking for the diagrams because he doesn't know which tables are involved, so he wouldn't which tables to add.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Community Member Profile Picture

Community Member 4

#2
Nayyar Siddiqi Profile Picture

Nayyar Siddiqi 2

#2
Guy Terry Profile Picture

Guy Terry 2 Moderator

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans