Automate data upload process like reports

Automate data upload process like reports

I'll start with the end in mind.  I want to basically keep certain creator tables updated with data that are in a sql database/tables in our office (employees, active jobs, employee positions) so I can reference that data and not have to duplicate it by hand every time someone adds a new job or employee in the office desktop software.  Here are some thoughts I had about how to do this, but am unsure as to whether any of them are actually possible and how to go about it from there:
  1. Is there any way to automate the data upload process to creator like the Reports Upload tool?  The upload tool gets me half the way there.  I can export data from my sql database and the upload tool converts it to a nice little csv file, but is there a way to automate the process of uploading that csv file to creator and replacing all current entries in a table with the contents of the csv file?  
  2. Alternatively, is there a way to use creator as a front end to Reports databases?  I could then just use the Reports UploadTool and just use stateless forms to reference that data.  If this is possible, please point me in the right direction to implement this.  
  3. Or, could I dynamically update the content of a creator table with the contents from a Reports table?  I've already spent considerable time figuring out CloudSQL and getURL and know that there is a way that i can use the Reports API and Cloud SQL select query url formated for XML to import data, but I don't think it will update the contents of the form, just add to the existing contents.  Again, if this is the best solution, could someone point me in the direction I need to go to do this?
 Thank you!
Andy