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.