Finance | Project Operations, Human Resources, ...

Data dictionary export

(0) Share

Report

Posted on by Yuji

4,131

Hi,

Is there any way to export D365FO data dictionary from AOT?

Thanks,

I have the same question (0)

All responses (8)

Answers (0)

Suggested answer

nmaenpaa 101,166 Moderator on at

Like (0)

Report

There is no Data dictionary in AOT in D365, it was only there in earlier AX versions.

Can you share some details about what you wish to achieve?

Was this reply helpful? Yes No
Yuji 4,131 on at

Like (0)

Report

Hi Nikolaos,

Basically the table schemas.

Thanks,

Was this reply helpful? Yes No
nmaenpaa 101,166 Moderator on at

Like (0)

Report

The whole table definitions are stored as xml files in AOSService/PackagesLocalDirectory, along with all source code.

Is this what you are looking for?

Or some UML document about database schema? Or something else?

Was this reply helpful? Yes No
Yuji 4,131 on at

Like (0)

Report

Our customer would like to have an Excel format data schema.

Was this reply helpful? Yes No
Suggested answer

nmaenpaa 101,166 Moderator on at

Like (0)

Report

"Excel" is not a type of database schema description.

Anyway, I think you could quite easily develop either x++ code, or a PowerShell script, that iterates all table definitions in AOSService/PackagesLocalDirectory and gathers the required information in Excel. You need to start by describing the exact expected output, for example by creating an example Excel file with your customer.

Was this reply helpful? Yes No
Suggested answer

Rahul Mohta 21,032 on at

Like (0)

Report

could leverage example in this link to export

community.dynamics.com/.../get-menu-extensions

Was this reply helpful? Yes No
Suggested answer

Joris dG 17,775 on at

Like (2)

Report

Keep in mind that if you get this in Excel, it will be a MASSIVE amount of data, which is questionable how useful that is. Additionally, you would have to get a new sheet every time you an install an update, since new tables or fields can always be added, etc.

Finally, my experience has been that customers who ask for this have some idea that they can find the right table to write records into. This is of course not true, as these records are created through logic and you can't just write your own record in a table you want.

Sounds to me you need to have a conversation with your customers about what they are trying to achieve with this, as the request may seem reasonable at the surface, but it's almost guaranteed that it is not what they should do or want.

Was this reply helpful? Yes No
Suggested answer

Rahul Mohta 21,032 on at

Like (0)

Report

Joris has some nice advice should take it and have a conversation on need and rework on approach

Was this reply helpful? Yes No