Data ingestion to Microsoft Cloud for Sustainability using Azure Data Factory

Kuldeep Singh 16 Reputation points
2022-08-25T16:02:00.023+00:00

Microsoft Cloud for Sustainability comes with a user interface to manually upload the data. I have 2 questions:

  1. Is there any way I can ingest the data into Sustainability tool using Azure Data Factory?
  2. Is there any way I can access the uploaded data using Azure Data Factory?
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,672 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Kuldeep Singh 16 Reputation points
    2022-09-04T07:21:29.407+00:00

    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:

    1. Is there any way I can ingest the data into Sustainability tool using Azure Data Factory? Yes (Dataverse Connector)
    2. 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

    1 person found this answer helpful.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.