Sorry for the late reply, but I just had the same question and maybe what I found could still be helpful.
Esri has an ETL engine called Koop that can convert data into a lot of different formats as well as make resources from other platforms work in ArcGIS Online. There is a provider written for Socrata resources that might help in this specific use case.
Definitely check out the docs, but using your example dataset, here's what the URL would look like: http://koop.dc.esri.com/socrata/austex/hye6-gvq2/FeatureServer/.
Now you can load that data into a web map that would look familiar to the users you're thinking of:
The functionality of services registered this way may not be as complete as one registered via file upload, but try it out. Koop is an open source project so if there's any functionality you find missing, feel free to open an issue.
Hope that helps!
#koop #etl #spatial etl #etl tools #spatial etl tool #socrata