Schedulable: means the tool supports scheduled (automated) updates.
Transformation: means the tool supports doing automated data transformation.
Socrata - DataSync
Safe Software - FME
Safe FME is an ETL tool enabling easily creating workflows to extract data from source systems, perform cleanup and transformation, and publish that data to Socrata.
Pentaho - Kettle
Kettle is a free and open source ETL tool made by Pentaho.
Socrata - API Resources
We have Libraries/SDKs and example code in various programming languages that make using our APIs much easier available at: http://dev.socrata.com/libraries
Libraries & SDKs:
* Good support for data publishing