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
Great, thanks. Once the proxy server is up then that will be possible. Much appreciated.
BCS is what you want then. Can wire that up using SPD to create the model and external list for it.
I assume each option has it’s pluses and minuses, depending on the objective. At this point, all I’m looking to do is read our SQL data into a SP list and throw it into views. I don’t need to write back to it. Knowing that, what would be the quickest and easiest way to implement that? Thx
That’s one way to use the data. You could use a 2013 workflow to interact with your data if you wrap it in a web service. You could also create custom apps that leverage the data.
Also, I assume once a proxy server is setup I have to setup a BCS to it?
