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)???
    – Marco
    Commented 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. Commented Sep 10, 2015 at 3:06

1 Answer 1


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

  • I heard that there was an OData WCF Service way? Commented Sep 10, 2015 at 22:02

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.