Using the OData connector
The exercises in this chapter can be followed along with by downloading the workbook associated with this chapter on https://public.tableau.com/profile/marleen.meier or by using the OData connector directly. The following steps explain how datasets from the web can be loaded directly into Tableau by using an OData endpoint:
- Navigate to https://data.cityofchicago.org/Public-Safety/Crimes-2020/qzdf-xmn8 and select the More icon (indicated by an ellipsis, …), followed by the Access Data via OData button:
Figure 6.1: Chicago Data Portal
- Copy the OData Endpoint value and open Tableau Desktop:
Figure 6.2: OData
- In the Data Source pane, search for
OData
, and select the OData option:Figure 6.3: OData connector
- In the Server field, copy in the OData endpoint from the Chicago Crime website. Authentication is not necessary, so select Sign In to get started:
Figure 6.4: Server name...