Can ADF read an excel file which is placed in a SharePoint portal and load it to SQLDB?

Question

Hi all,

Is it possible for azure data factory, to read an excel file from the Sharepoint portal and process it?

Thanks!

Answer 1

Not sure if this is possible, but someone has raised the feedback on having this SharePoint connector ability. Consider upvoting the feedback.

https://feedback.azure.com/forums/270578-data-factory/suggestions/40917553-add-connector-for-sharepoint-folder-file

One option is to use Logic app to copy the SharePoint file to Azure storage and then use ADF to load excel data to SQL. (or use Logic App itself to load to SQL)

---

Please don't forget to Accept Answer and Up-vote if the response helped -- Vaibhav

Answer 2

Hi @xyz_chatter ,

Yes, it's possible to read files from SharePoint, do transformation and load it into SQLDB using ADF. For details, please see the link below:

https://learn.microsoft.com/en-us/answers/questions/53586/copy-files-from-sharepoint-into-azure-data-lake-st.html

Thanks!