Insert Excel Data in Sharepoint/Onedrive to SQl DB using ADF - cannot use Storage Account

Question

Insert Excel Data in Sharepoint/Onedrive to SQl DB using ADF - cannot use Storage Account

Dixan Lal Thomas 60

I want to insert the data in Excel placed in a Sharepoint/Onedrive, into a DB using ADF. I found that this can be done using a storage account. My requirement is not to use a Storage account.

Can anyone guide me?

Accepted answer

0 additional answers

Your answer

Answer 1

Bhargava-MSFT 31,261 Microsoft Employee Moderator

Hello Dixan Lal Thomas

Welcome to the Microsoft Q&A forum.

You can configure the Copy Activity to read data from the Excel file dataset and write data to the SQL Server dataset.

Copy activity supports "SharePoint Online" as a source and Azure SQL as sink

Here you need to setup a linked service for sharepoint and connect to excel file and setup Linked Service for the SQL Database/Azure SQL.

Create a copy activity pipeline to transfer the data.

Please follwo these reference documents:
https://learn.microsoft.com/en-us/azure/data-factory/copy-activity-overview

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

https://learn.microsoft.com/en-us/azure/data-factory/connector-azure-sql-database?tabs=data-factory

I hope this answers your question. Please let me know if you have any further questions.

Bhargava-MSFT 31,261 Reputation points Microsoft Employee Moderator

2024-06-27T19:36:45.5866667+00:00

Hello Dixan Lal Thomas

I am checking in to see if the above answer is helpful.

If this answers your query, do click "Accept the answer” for the same, which might be beneficial to other community members reading this thread. And, if you have any further query do let us know.

Share via

Insert Excel Data in Sharepoint/Onedrive to SQl DB using ADF - cannot use Storage Account

0 additional answers

Your answer