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
Dynamics 365 FO CDMUtilSolution no tables appear in synapse
Wayne Bartkowski
586
Reputation points
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.
1 vote
-
BhargavaGunnam-MSFT 10,336 Reputation points Microsoft Employee
2023-03-03T00:30:25.02+00:00 Hello @Wayne Bartkowski,
I am checking to see if you got a chance to look into the above response. Please let me know if you have any further questions.
Hello @Wayne Bartkowski,
Welcome to the MS Q&A platform.
Did you check the logs of the CDMUtil_AzureFunction app to see if there are any errors or exceptions?
And please check CDMUtil_AzureFunction app has the necessary permissions to access the Azure Data Lake and the blob storage.
Hi @Wayne Bartkowski have you got the solution , I am facing the same issue .
Not yet - was called on to other projects. I am spinning this up in an environment where I have full access so I can check logs and so forth. But this may be a couple more days.
Sign in to comment