Personalized Community is here!
Quickly customize your community to find the content you seek.
Choose your path Increase your proficiency with the Dynamics 365 applications that you already use and learn more about the apps that interest you. Up your game with a learning path tailored to today's Dynamics 365 masterminds and designed to prepare you for industry-recognized Microsoft certifications.
Visit Microsoft Learn
2020 Release Wave 2Discover the latest updates and new features to Dynamics 365 planned through March 2021.
Release overview guides and videos Release Plan | Preview 2020 Release Wave 2 TimelineWatch the 2020 Release Wave 1 virtual launch event
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Upcoming TechTalks
I'm a new hired employee and my new company has Dynamics AX. I replaced a guy who left and was handling the Dynamics. Now that I've arrived, they asked me to connect their BI tool (Qlikview) directly to the Dynamics data base.
So i got questions :
- where can I get a documentation describing Dynamics AX data model definition ?
- Can I technically and easily connect my BI tool to the database ?
Understanding AX Data model fully is matter of years and there is no Complete Reference to describe existing data model, as AX is very big with 8000+ Tables.
Despite there are ways e.g. for many entities the data model has been described on AX ERD Page
Most of times we developers of AX, are dependent upon, looking at relationships of tables inside AOT. Each tables has relationship node, where it is defined the relationship with other tables.
To know what tables are being used behind a screen/form, you can always right-click the field and click on Personalize.
Additionally as AX has its own reporting framework, so most of time, we are dependent upon that, which is based On SSRS.
Connecting AX to other reporting tools violates security and company based data partitioning. By this line I am not going against you tool, but it’s just what we usually do(AX-SSRS Framework).
As most us might not be aware of your 3rd party tool, so all we can say at this moment, is that you can connect to Business/Transactional Database of AX, taking it as a data source in you Tool, and you may proceed with your work. At the same time, we do understand that it’s little hard to understand existing tables structure if you have just started, But with passage of time, you can learn and you can ask your specific question by creating threads here on community.
There are static data models available from Microsoft of key areas, or you could try Safyr which is a product for getting data definitions into data model form for Dynamics AX
Business Applications communities