As my title states, I'm looking for some help/resources on how I can pull data from SQL server and display it on SP Online. The added kicker is, we'd like this data to be view-able on mobile devices.
I've read and it appears there are a few options we have.
- Use report server. We do have a report server but users must be on local domain to access the reports.
- Use excel and create a connection to the data set.
- Use BCS and ECT to create a list that displays the data.
What would be the best way to allow users access to the data and also make sure it's accessible on mobile devices? I am not sure what exactly I should be searching for to accomplish this so I'm sorry if this is a double post.