Dynamics 365 Finance
Category
Sep 11, 2023
Published date
Text
Article Type
AI Summary
- The author created an Excel file to centralize information about D365FO data entity metadata, data sources, and dependencies.
- The metadata for each data entity, including name, label, public collection name, and entity name, was obtained using the MetadataSupport library and written to a CSV file.
- The data sources for each data entity were also retrieved, with the initial data source considered the "root" data source. A recursive method was used to obtain all data sources for a data entity.
- The author discovered that the AX 2012 ERD hosted on their website could be used to find parent-child associations of data sources and data entities.
- Files starting with "Fky" and containing the string "ChildParents" were found to contain the desired relationship information. These files were stored in a single folder.
- By analyzing the raw HTML of these files, the author was able to extract the desired data using specific character strings.
- The extracted data, including data entity metadata, data sources, and table relationships, was stored in a SQL instance to enable querying and generation of data entity dependencies.
- The end result is an Excel file with 5 tabs: Data Entity Metadata, Data Entity Root Data Sources, Data Entity All Data Sources, Data Entity Assoc Overview, and Data Entity Assoc Detailed. The file provides information on the name, label, data sources, and dependencies of each data entity.
Registered users can view the full text for FREE!
Sign In Now!