This article shows the necessary steps to quickly and easily load historical weather data sets for any location of the world into TIBCO Spotfire via ODATA request. The tutorial shows step-by-step how to construct the query in the Visual Crossing Weather web interface, how to access the automatically generated connection string and then create a data connection to load the historical weather data to analyze it together with your business data in your TIBCO Spotfire Analytics Application.
If you are interested in how to import weather forecast into TIBCO Spotfire , be sure to check out the article How to load weather forecast into TIBCO Spotfire.
Step 1 – open Visual Crossing Weather Data Services
Open the Visual Crossing Weather Data Services log-in page and sign into your Visual Crossing Weather account. If you don’t already have an account, you can sign up for a free trial on the same page. Signing up for a free trial account will give you immediate access to a full 15-day weather forecast for any location.
Step 2 – specify your locations
The first page will prompt you to add the locations to retrieve the weather history data for. There are two options in the web interface to manually add locations. As direct entry of either the physical address in clear text or as bulk entry in form of a file upload. In this scenario we go with the manual option. Simply enter the details of your location the text box and hit the ‘Choose forecast or historical data’ button afterwards. For more details please see the Visual Crossing Weather Data Tutorial section
Step 3 – Request Historical Weather Data
On the next page you can select the type of data you want to download.
The options are forecast, weather history queries, historical data summary reports, and hourly data. This tutorial will continue with the daily historical option. Please see those or reach out to us if you need more information on the other options or browse our tutorial and video section for more details.
Select the ‘Historical Data’ option, set your date range and click the ‘Request Weather Data’ button.
Step 4 – Review the historical weather data
The default view for the query results is the weather calendar. This view provides a simple overview of the result data.
Step 5 – Generate the Query string
To automatically generate a query string for your locations click the ‘Query API’ button
Step 6 – Select query options and copy the string
The query can retrieve data using GET, POST or ODATA. For the TIBCO Spotfire use case please select ODATA.
The ‘Content Type’ section allows to chose between CSV and JSON data format. For TIBCO Spotfire select the CSV format.
Besides the unit group drop down (US, Metric, UK) you have additional option in the ‘More query options’ section. For the details please see our ‘Getting Started Guide’. To copy the query string to the clipboard click the ‘Copy full query’ button.
Step 7 – Log in to your TIBCO Spotfire and add a connection
Login to TIBCO Spotfire account
Select the ‘Connect to’ option on the data exploration splash screen
Select the OData entry from the menu.
Step 8 – Configure your OData connection
Click the ‘New Connection Button’ and copy the ‘Service URL’ you created in Step 6 of this tutorial into the corresponding form field. You don’t need to enter any of the other fields since the authentication is encrypted in your connection string.
you need to add the following text at the end of your copied string: /WxRequest
Finally hit the ‘Connect’ button.
Step 9 – Select view and columns needed for you analysis
The ‘Views in Connection’ editor allows to select from multiple data tables available form the data source. In our case the view containing the actual data is called ‘WxRequest’ and this needs to be added by clicking the ‘Add’ button. On the right hand window you will see the columns of the selected table to check or uncheck those relevant or not needed for your analysis.
Once the selection is made hit the ‘OK’ button.
Step 10 – Add the selection to the analysis
Give your new dataset a name and hit the ‘OK’ button.
Step 11 – Start analyzing and visualizing
Your weather dataset is now ready to be used in the TIBCO Spotfire analytics flow.
Select for example the ‘Start from visualizations’ area…
…and start building your graphs
As you can see, importing weather data into TIBCO Spotfire is simple and straightforward. Do you have questions or comments? Please comment below or send us an email at email@example.com.