Has anyone successfully connected SharePoint Online or O365 to a SQL on prem server? If yes, a detailed how would be lovely.
-
you want to connect SharePoint OnLine to an SQL Server like External Content using BDC (Business Data Connectivity)???– MarcoCommented Sep 9, 2015 at 21:41
-
You can also manipulate data of SQL Server via javascript (by calling webservices) or you can build a SharePoint app. You should give us more details on what are your needs.– Sylvain GantoisCommented Sep 10, 2015 at 3:06
Add a comment
|
1 Answer
The easiest way (in my opinion)
Is to create a REST service that communicates with your SQL database, And from there make REST calls to your service in javascript, using this guide as an example.
You should also read this, which is a similar question to yours