Socrata was acquired by Tyler Technologies in 2018 and is now the Data and Insights division of Tyler. The platform is still powered by the same software formerly known as Socrata but you will see references to Data & Insights going forward.

RSocrata

RSocrata is a free and open source package that is listed in CRAN for the data science language R. The City of Chicago has been using this on the consumption side for a number of years and helped to write the initial package. Now there is also a method for the RSocrata that allows publishing to datasets as well. This opens up a new side of using R as an ETL framework for publishing data to Socrata Open Data Portals.

Lots of companies and the community have created extensions into R for their solutions including Oracle, MySQL, and Salesforce to just name a few.

R Resources

Getting Started Guides