Integrate SharePoint with SQL Server

%3CLINGO-SUB%20id%3D%22lingo-sub-2417113%22%20slang%3D%22en-US%22%3EIntegrate%20SharePoint%20with%20SQL%20Server%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2417113%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20needing%20to%20integrate%20an%20online%20SharePoint%20list%20with%20SQL%20Server%20database%2C%20creating%20a%20table%20inside%20my%20database%20with%20the%20data%20from%20the%20SharePoint%20table.%20Making%20a%20direct%20connection%20to%20get%20real%20time%20data%2C%20would%20you%20have%20any%20suggestions%20on%20how%20to%20get%20it%20directly%20without%20using%20Access%20and%20Excel%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20very%20much%20in%20advance.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2417113%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EIntegrate%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESQL%20Server%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

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 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.