Forum Discussion
Fernando_Mota_013
Jun 04, 2021Copper Contributor
Integrate SharePoint with SQL Server
I'm needing to integrate an online SharePoint list with SQL Server database, creating a table inside my database with the data from the SharePoint table. Making a direct connection to get real time data, would you have any suggestions on how to get it directly without using Access and Excel?
Thank you very much in advance.
- ZdenekHavelCopper Contributor
Hello Fernando_Mota_013 ,
check out Business Connectivity Services. It's an old and sometime forgotten technology. BCS allows you to connect external data sources (such as SQL table or view) and use them like lists.