Write back to Dataverse from Synapse

Kumar, Arun 336 Reputation points
2024-07-10T20:46:25.0466667+00:00

Hi,

I know we can pull data from Dataverse to Azure Synpse through pipelines. Is its possible to write back to Dataverse from Pipelines or Spark notebook?

I didnot see any documentation showing writing back to Dataverse.

Thanks,
Arun

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,927 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,714 questions
0 comments No comments
{count} votes

Accepted answer
  1. Nandan Hegde 32,421 Reputation points MVP
    2024-07-11T04:31:31.6266667+00:00

    You can use Copy activity to copy data into dataverse :

    User's image

    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Bhargava-MSFT 31,031 Reputation points Microsoft Employee
    2024-07-10T23:05:43.42+00:00

    Hello Kumar, Arun,

    Please correct me if my understanding is wrong. You want to write data from a lake database to Dataverse using Synapse.

    Using synapse copy activity/dataflow, I see the lake database as the source and Dataverse as the sink. So, I believe you can use copyactivty or dataflow to write data back to Dataverse.

    0 comments No comments

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.