Data ingestion to Microsoft Cloud for Sustainability using Azure Data Factory

Question

Data ingestion to Microsoft Cloud for Sustainability using Azure Data Factory

Kuldeep Singh 16

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

Is there any way I can ingest the data into Sustainability tool using Azure Data Factory?
Is there any way I can access the uploaded data using Azure Data Factory?

KranthiPakala-MSFT 46,647 Reputation points Microsoft Employee Moderator

2022-08-26T21:58:03.1+00:00

Hello @Kuldeep Singh ,

Thanks for the question and using MS Q&A platform.

As per my understanding you would like to know if there is a way to connect to Microsoft Cloud for Sustainability using Azure Data Factory and access or ingest data. Please correct if I'm not accurate.

There is no ADF connector to access or ingest data to Microsoft Cloud for Sustainability. Hence the answer is no. In case if there is a rest API or SDK available for Microsoft Cloud for Sustainability, then you may explore [REST Connector][1] or [Custom Activity][2] in ADF. To move data to/from a data store that the service does not support, or to transform/process data in a way that isn't supported by the ADF service, you can create a Custom activity with your own data movement or transformation logic and use the activity in a pipeline

And if you have any feedback for feature request, we recommend you log it in IDEAS forum here: https://feedback.azure.com/d365community/forum/1219ec2d-6c26-ec11-b6e6-000d3a4f032c. Once it is logged, please do share the link here so that others with similar requirement can up-vote and comment on it to help increase the priority of it.

Hope this will help. Please let us know if any further queries.
KranthiPakala-MSFT 46,647 Reputation points Microsoft Employee Moderator

2022-08-30T23:23:57.357+00:00

Hello @Kuldeep Singh ,

Just checking in to see if the below information was helpful. If it answers your query, do click Accept Answer and Up-Vote for the same. And, if you have any further query do let us know.

1 answer

Your answer

KranthiPakala-MSFT 46,647 Reputation points Microsoft Employee Moderator

2022-08-26T21:58:03.1+00:00

Hello @Kuldeep Singh ,

Thanks for the question and using MS Q&A platform.

As per my understanding you would like to know if there is a way to connect to Microsoft Cloud for Sustainability using Azure Data Factory and access or ingest data. Please correct if I'm not accurate.

There is no ADF connector to access or ingest data to Microsoft Cloud for Sustainability. Hence the answer is no. In case if there is a rest API or SDK available for Microsoft Cloud for Sustainability, then you may explore [REST Connector][1] or [Custom Activity][2] in ADF. To move data to/from a data store that the service does not support, or to transform/process data in a way that isn't supported by the ADF service, you can create a Custom activity with your own data movement or transformation logic and use the activity in a pipeline

And if you have any feedback for feature request, we recommend you log it in IDEAS forum here: https://feedback.azure.com/d365community/forum/1219ec2d-6c26-ec11-b6e6-000d3a4f032c. Once it is logged, please do share the link here so that others with similar requirement can up-vote and comment on it to help increase the priority of it.

Hope this will help. Please let us know if any further queries.
KranthiPakala-MSFT 46,647 Reputation points Microsoft Employee Moderator

2022-08-30T23:23:57.357+00:00

Hello @Kuldeep Singh ,

Just checking in to see if the below information was helpful. If it answers your query, do click Accept Answer and Up-Vote for the same. And, if you have any further query do let us know.

Answer 1

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

KranthiPakala-MSFT 46,647 Reputation points Microsoft Employee Moderator

2022-09-05T23:33:34.21+00:00

Hello @Kuldeep Singh ,

Thank you so much for your response and sharing the above details. This is very helpful. I wasn't sure that the Microsoft cloud for sustainability data is stored in Dataverse. If that is the case, then yes, Dataverse connector/Synapse Link are the options for accessing the data.

Appreciate much again for sharing this knowledge!

Have a good day!

Share via

Data ingestion to Microsoft Cloud for Sustainability using Azure Data Factory

1 answer

Your answer