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
BCS is what you want then. Can wire that up using SPD to create the model and external list for it.