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
Perhaps my words were poorly chosen. None of those scenarios moves your database. It all still remains in your on-prem SQL Server.
Thank you. I would like to keep my data where it’s at for now but connect to it from O365. It looks like a proxy server would work. I’ll have to research what’s involved in that. I appreciate the reply.
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.
