Dynamics 365 FO CDMUtilSolution no tables appear in synapse

Wayne Bartkowski 586 Reputation points
2023-02-28T03:21:06.72+00:00

I am deploying the components to read the csv and metadata files landing the azure datalake from the Dynamics 365 finance and Opertions system. I can see the folder and files in the blob storage container.

I deployed the CDM App in Azure, using the CDMUtil_AzureFunction app (not console) and configured everything as per the steps in https://github.com/microsoft/Dynamics-365-FastTrack-Implementation-Assets/blob/master/Analytics/CDMUtilSolution/deploycdmutil.md

Unfortunately I cannot see any tables being created or data moving into Synapse and can't see anyway to check that everything is connected and running as it should be. The event grid on the blob storage account should be triggering the CDMUtil_AzureFunction app when I add a file or blob but I can't see that it is. Then the app should be reading the manifest files etc in the datalake to create the tables in Synapse but can't see this happening.

Any suggestion on how to debug this would be handy or to check that the apps and events are talking as per the solution.

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
2,866 questions
1 vote