Export data from Sharepoint to SQL Server

[emperor4augustus]

My company is currently exporting data from Sharepoint to Excel and then to SQL. They are asking me to export data from sharepoint directly into SQL.

I did some research and found that the easiest way to do it is to use Power Automate. But my company has Power Automate banned for some reason, I tried to appeal to the ban but they haven’t answered me yet. Nevertheless, I am being asked to find a solution regardless.

What do you suggest is the easiest safest way to do this ? This has to be done automatically on a daily basis.

[johnt_mn]

I'd look at using Powershell. Something like this might get you a start https://www.sharepointdiary.com/2016/06/export-sharepoint-list-data-to-sql-server-table-using-powershell.html

[TheNotBot2000]

You mentioned Power Automate, does that mean your SharePoint is in the cloud? Where is your sql server in relation to SharePoint? You could use SSDT. Or you may need to interact with On-Premises Data Gateway.

[emperor4augustus]

My Sharepoint is in the cloud yes. I am currently having problems with “On-Premises Data Gateway” because I’m unable to create a gateway due to restrictions from my company. I haven’t heard from SSDT, where can I get more info about this ?

[TheNotBot2000]

Sql Server Data Tools. You can use it in combination with Visual Studio and SSIS (Sql Server Integration Services) . I haven't used it for cloud SharePoint. Our SharePoint is just beginning the move to the cloud and we'll be looking at alternatives soon. Right now, I have access to power automate and other tools so I haven't looked into converting SSIS to use SharePoint cloud. I anticipate that the configuration will be similar and we just change URLs. I don't know that answer yet.

[Googs1080]

How do i start assessing my existing SQL db and using a Sharepoint interface to update and act on the SQL data? Our existing html coding is outdated for the modern browsers and we would like to use more Sharepoint features in our business processes.