Read data from CDM folder

asked 2021-05-08T12:49:29.427+00:00
Alberto Vaccariello 21 Reputation points

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.

Azure Machine Learning
Azure Machine Learning
An Azure machine learning service for building and deploying models.
1,630 questions
No comments
{count} votes

Accepted answer
  1. answered 2021-05-10T22:59:13.12+00:00
    GiftA-MSFT 11,096 Reputation points

    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.

    No comments

0 additional answers

Sort by: Most helpful