I have a runtime application that basically keeps track of inventory etc. What im trying to accomplish :
I have an sql database in the cloud that just stores beer name, ABV, Origin, and Style. 4 fields.
What i would like to do is in the run time app, hit a button that says check for latest beers, and it queries that sql database in the cloud, if the modification date is newer then previous download , download latest list. Is this possible ? Can i make a direct connection to the SQL DB through runtime ? Or would SQL DB have to dump a csv file everyday and have the runtime app ftp to server and impor that way ?
I appreciate your help.