This walkthrough goes through the steps of taking data from any system that uses ODBC and then loads that into an existing Socrata table using write.Socrata from RSocrata
Step 1: Install Required Packages
Step 2: Connect to ODBC Database
Create constants so that R can access your database instance.
Step 3: Write to Your Data Frame
Use con to write to data.frame:
Step 4: Identify Destination Dataset
Ensure that you have a Socrata dataset with proper fields and proper datatypes to write to. Capture the 4x4 ID for the dataset you want to publish to.
Step 5: Write Your Dataset
For full documentation on RODBC please see https://cran.r-project.org/web/packages/RODBC/vignettes/RODBC.pdf