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?

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 : Copy activity : from SQL to Blob/file system 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

ADF: Move Data from SQL Server On Prem to Sharepoint

Accepted answer

Nandan Hegde 33,241 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 :

Copy activity : from SQL to Blob/file system

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
Please sign in to rate this answer.
Jay 561 Reputation points

2021-02-26T09:07:37.26+00:00

OK thanks I'll give that a go, seems a shame to write data twice, guessing also adds to cost.

Nandan Hegde 33,241 Reputation points MVP

2021-02-26T09:23:11.76+00:00

Yes, definitely.
You can vote for direct sharepoint connector in azure.feedback.com as there are multiple users gunning for that property

Jay 561 Reputation points

2021-02-26T10:03:16.49+00:00

I don't understand why these things aren't out of the box already in here, I'm also seen with other things like ADF daylight saving only recently added when user complained, ADF export to XML, in Azure there isn't even a simple ftp service, I have a user who had to go over to Amazon to setup an ftp.

Thanks NandanHegde-7720 I'll do an upvote.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

ADF: Move Data from SQL Server On Prem to Sharepoint

0 additional answers

Your answer