question

xyzchatter-0237 avatar image
0 Votes"
xyzchatter-0237 asked MartinJaffer-MSFT commented

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

Hi all,

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

Thanks!

azure-data-factory
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@xyzchatter-0237 did either of these community answers solve your question? If so, please mark as accepted answer, otherwise say how you can be better helped.

0 Votes 0 ·

@xyzchatter-0237 if you found your own solution, please share it here with the community.

0 Votes 0 ·
nasreen-akter avatar image
0 Votes"
nasreen-akter answered nasreen-akter edited

Hi @xyzchatter-0237,

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://docs.microsoft.com/en-us/answers/questions/53586/copy-files-from-sharepoint-into-azure-data-lake-st.html


Thanks!

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

VaibhavChaudhari avatar image
0 Votes"
VaibhavChaudhari answered

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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.