How to determine which tables extract data from (SQL connection in Excel)

(0) Share

Report

Posted on by Mathias Laursen

Hello everyone,

I hope this is the proper place to ask this question, otherwise I apologize.

It's a somewhat basic question, but I'm unable to find an answer to it.

I'm trying to extract data from AX into Excel by connecting to the AX SQL-server within Excel. I'm able to establish a connection to the SQL-server and see all the available AX data. My difficulty however lies in determining, which of the available tables in the established connection I'm supposed to extract data from?

After all, there're >5000 tables and a ton of data; Suppose therefore I'd like to see the balance of all ledger accounts; How would I as an AX user be able to determine the name of the table within my SQL-connection, from which I'd need to extract data from?

I hope my question makes sense.

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

RodRodriguez on at

Like (0)

Report

RE: How to determine which tables extract data from (SQL connection in Excel)

Howdy Mathias,

So, what you would need to know is what entity (table) is the ledger balance a part of? Then you would look in that table to find the field that has that data

In the following picture for example the dbo.account is the account entity, and if you were to open it up you would see the fields for that entity

Here is a Microsoft Document page talking about the tables

https://docs.microsoft.com/en-us/dynamicsax-2012/developer/tables-overview

And here is a third party webpage that talks about getting SQL data from Dynamics
https://microsoft-business-applications.hcltech.com/dynamics-365/use-sql-to-query-data-from-cds-and-dynamics-365-ce/

Hope that helps you find what you are looking for!

Was this reply helpful? Yes No