Azure mobile data connection
The examples will provide the prototype team with a minimum number of challenges per example. The examples will become a chassis for the team’s own use.
The example resources link provides an app to be side loaded to the android tablet or device. The app creates tasks for a Todo list that is stored in a model app service SQL database. Team will
- create a connection in excel to the SQL server database
- explore the database to locate the TodoItem table
- insert the table into a excel sheet
- create additional tasks using the app and refresh excel to show the results
- test the same excel sheet from outside the local LAN
For ease of use the app and SQL table do not require a user ID and requests will be accepted from any IP address , security and restrictions will be added in subsequent examples.
Industry 4.0 Prototyping 