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

Dixan Lal Thomas 60 Reputation points
2024-06-26T07:32:25.61+00:00

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?

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,646 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,006 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,140 questions
0 comments
Accepted answer
  1. BhargavaGunnam-MSFT 28,526 Reputation points Microsoft Employee
    2024-06-26T16:50:39.6433333+00:00

    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://video2.skills-academy.com/en-us/azure/data-factory/copy-activity-overview

    https://video2.skills-academy.com/en-us/azure/data-factory/connector-sharepoint-online-list?tabs=data-factory

    https://video2.skills-academy.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.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest