The author created an Excel file with metadata, data sources, and dependencies for D365FO data entities. They used the MetadataSupport library to get the metadata for each data entity and wrote it to a CSV file. They also used recursion to get all of the data sources utilized in the data entity and stored the data entity metadata, data sources, and table relationships in a SQL instance. The author then wrote queries against this data to generate the data entity dependencies. The Excel file contains five separate tabs, including data entity metadata, data entity root data sources, data entity all data sources, data entity assoc overview, and data entity assoc detailed. The author shared the Excel file for others to use.
Login now to access my digest by 365.Training