At a high level, What's the recommended Development model if we want to consume local (On-Prem) SQL data from Office 365 SharePoint 2013 Cloud application?

Say we have a custom SharePoint List Form and we want a dropdownlist with data from a table in a database down in SQL On Premisis?

Presuming OAuth is the way to go. Can the authentication server be ACS on the cloud?

  1. What do we need to develop and configure On Prem and in SQL? Presume we have a SQL view ready.

  2. Can the consumer (and only code in SharePoint) be just JQuery?


  • OAuth is only ever used for server-to-server and server-to-(Provider/Auto-hosted) apps. OAuth won't save you here (though see my answer below).
    – James Love
    Commented Jan 24, 2013 at 20:24

1 Answer 1


If you have SharePoint in the Cloud (SharePoint Online/Office 365) and your data is in-house, here's one (supported) way you could do it:

Surface your data from SQL in a web service you host on-site. Access this via JavaScript/client script code running in a SharePoint App.

Create a Provider hosted SharePoint App, where your on-site hardware is the 'provider', and you can grab the access to the SQL data as if it were local. This is where OAuth comes in - as SharePoint Online directs to your Provider Hosted infrastructure (on your premises), and it can talk back to SharePoint by authenticating using OAuth.

Configuring IIS for Provider Hosted apps is quite a tedious process (from what I gathered), but Eric Schupps went through at the SharePoint Conference 2012, I think this is the right post, but if not, find his other stuff from SPC12.


  • In the above I would have to have SharePoint running Online and On-Prem right? Where would the Provider Hosted SP App run? Thanks.
    – Hell.Bent
    Commented Jan 24, 2013 at 23:19
  • 1
    You would 'deploy' the app to your SharePoint environment, but when people access it, the code actually runs on your on-prem hardware - i.e. the users are actually directed to your environment when they go to your app.
    – James Love
    Commented Jan 25, 2013 at 8:16

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.