Forum Discussion
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.
1 Reply
Hello Fernando_Mota_013 ,
check out https://docs.microsoft.com/en-us/sharepoint/manage-business-connectivity-service-applications. 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.
