Hello @KranthiPakala-MSFT
Last week I discussed this topic with one of your Microsoft CSU colleague.
Microsoft cloud for sustainability stores the data into Dataverse. I found there is a native connector for Dataverse from Azure Data Factory. So we can connect to Dataverse from ADF using below properties:
- Service URI: Dynamics organization url
- Authentication types: Service principal, Office 365, User assigned managed identity.
I am able to connect to Dataverse using service principal now. So the answers to my questions are:
- Is there any way I can ingest the data into Sustainability tool using Azure Data Factory? Yes (Dataverse Connector)
- Is there any way I can access the uploaded data using Azure Data Factory? Yes (Dataverse Connector/ Azure Synapse link)
ref:
https://learn.microsoft.com/en-us/power-apps/maker/data-platform/data-platform-intro
https://learn.microsoft.com/en-us/azure/data-factory/connector-dynamics-crm-office-365?tabs=data-factory