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

    Connect to SQL DB  (Runtime App)

    ZoocMan85

      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.

       

      Thanks

       

      ZoocMan