We have a sharepoint 2013 online tenant. We have some sql server databases that are on premise.

For this query we want to connect sharepoint 2013 online to those databases and read information from them and display this data on Sharepoint 2013 online. This will give users on user interface to everywhere.

What is the best and most secure way to do this?

Would it be beneficial to move these databases to azure to make this task a lot simpler?

Currently we are not sure how to connect these up.

1 Answer 1


Moving to Azure SQL might make things simpler, but this technet article details a Hybrid BCS Solution for SharePoint Online.

This picture details how the configuration ends up, in case the article goes away (unlikely) Picture detailing hybrid configuration

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.