Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

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?

Thanks.

share|improve this question
    
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 Jan 24 '13 at 20:24
add comment

1 Answer

up vote 1 down vote accepted

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.

http://www.binarywave.com/blogs/eshupps/Lists/Posts/Post.aspx?ID=267

share|improve this answer
    
In the above I would have to have SharePoint running Online and On-Prem right? Where would the Provider Hosted SP App run? Thanks. –  cyberpine Jan 24 '13 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 Jan 25 '13 at 8:16
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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