4 Replies Latest reply on Oct 2, 2016 7:20 AM by user19752

    Connect to SQL DB  (Runtime App)


      Hey Everyone,


      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.