James no programming required. I went to the link you supplied, clicked their export icon (upper right list) then chose CSV. This gives you a text file that Tableau can connect to directly. Save the file then when establishing a connection choose Text file, couple of clicks and your done.
I've attached the data you pointed at.
Code Violations.twbx 1.3 MB
Sorry--I should have been more explicit. I'm specifically trying to establish a live database connection so that my visualizations (perhaps published eventually) will continue to update as the public data source updates. The goal is to publish a visualization on a local land use blog and it'd be nice if I didn't have to update the data periodically.
Thanks for the suggestion!
Good luck with that.
1 of 1 people found this helpful
The Open Data Portal of the Seattle code violations database | Data.Seattle.Gov | Seattle's Data Site is powered by Socrata. Socrata provides an Open Data API allowing developers to implement data exchange procedures to the data sources. It is not clear if Data.Seattle.Gov is exposing the Open Data API that allows to implement a live connection to that data source.
My recommendation to you is to search in or contact Data.Seattle.Gov to ask if they are providing that data exchange mechanism. If they are providing the data exchange service, a developer (a person with programming skills) should implement a middle ware application to extract the data from the data source and storing them in a format that Tableau Desktop are able to connect to.
I hope this information helps.