Jun 04 2021 10:38 AM
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.
Jun 08 2021 03:04 AM
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.