ADF: Move Data from SQL Server On Prem to Sharepoint

Jay 556 Reputation points
2021-02-26T08:31:38.473+00:00

I need to move data from on-prem SQL Server into a csv file then onto Sharepoint, does Azure Data Factory have a Sharepoint connector?

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,895 questions
0 comments No comments
{count} votes

Accepted answer
  1. Nandan Hegde 29,996 Reputation points MVP
    2021-02-26T08:43:57.203+00:00

    Hey @Jay ,
    Based on my knowledge, there is no direct connector to sharepoint.
    So for you to achieve this, you can follow the below path :

    1. Copy activity : from SQL to Blob/file system
    2. copy activity from Blob/file system to sharepoint

    https://learn.microsoft.com/en-us/azure/data-factory/connector-sharepoint-online-list

    This link provides details on how to copy files between sharepoint and blob which you can leverage


0 additional answers

Sort by: Most helpful