Copy file from Azure SQL to sharepoint

Question

Hello,
We have a requirement wherein we need to copy a file into Sharepoint library from Azure SQL.
Is it possible via ADF?
We were able to implement copying files from Sharepoint to blob but vice versa is not possible as we do not have http connector as Sink.

Answer 1

Hi @Nandan Hegde ,

Thanks for the ask. As mentioned in the Supported data stores and formats document currently ADF doesn't support Sharepoint/HTTP as sink. As @Vaibhav Chaudhari suggested you can give a try with Logic Apps or you can write your own code and use it in Custom Activity of ADF.

Here are few related existing feedback threads, please feel free to upvote and share your thoughts.

1. https://feedback.azure.com/forums/270578-data-factory/suggestions/42971007-support-sharepoint-folder-as-a-sink
2. https://feedback.azure.com/forums/270578-data-factory/suggestions/40236256-copy-a-file-from-a-blob-to-sharepoint
3. https://feedback.azure.com/forums/270578-data-factory/suggestions/31943653-sharepoint-list-destination

I have also shared this feedback internally to the product team, will keep this thread updated if I hear back anything on the same.

Thank you

----------

Please don’t forget to Accept Answer and Up-Vote wherever the information provided helps you, this can be beneficial to other community members.

Answer 2

@Nandan Hegde We currently doesn't have plan to support SharePoint as sink. Our plan is to support SharePoint as source first in 2H. we keep watching this demand but not yet n our plan as for now.