Read data from CDM folder

Question

I have a CDM folder with data coming from Dynamics 365 Business Central.
I need to do some data cleaning/preprocessing and then apply my models on that data, but I didn't find a proper way to read CDM folders.
I found some code on the Microsoft github repository, but is marked as obsolete.

Azure-Samples/cdm-azure-data-services-integration

I'm searching for something like the Apache Spark CDM connector but to use within Azure Machine Learning service.

ps: I know that is possible to copy/transform files with Azure Data Factory and that is supports CDM folders too, but is not what I want. I want to read CDM folder from python, do my stuff (data cleaning, preprocessing, applying models, ecc) then save the results.

Is there any way?
Any advice is welcome.

Thanks.

Answer 1

Hi, thanks for reaching out. The data source you specified isn't a supported storage type in AML. If you're using unsupported storage, we recommend that you move your data to supported Azure storage solutions. Currently, we don't have a python connector for connecting to CRMs. A workaround would be to load your data to a database and connect to the database using python. Hope this helps, sorry for any inconvenience.