We currently have SP hosted in Office365 but have our SQL servers on-prem. Â I want to connect our SP site back to our SQL servers so I can get to the SQL tables and report data.
I’m struggling with this setup. Â Any guidance would be much appreciated.
Thank yo
(Visited 38 times, 1 visits today)
The traditional route would be to allow O365 to connect to your database (typically via a proxy server in a perimeter network.) You could also put a web service around your data and host that similarly instead. If you do not mind using Azure, you could use a hybrid connection to get your data into the cloud before connecting to it from O365. PowerBI supports some scenarios for connecting to on-prem data if that is you end goal, too.Â
(Visited 1 times, 1 visits today)
