May 13, 2016 at 1:02 am
Hi there,
I work for a retail company, in a small team who look after all the reporting using SQL Server 2008R2 and SSRS.
Our bosses have requested to see weather data: temperature / rainfall, it's an open ended request, they don't really know what they want. The problem is that my knowledge is limited to querying SQL Server. I suspect I need to call an API and get the data into our SQL Server somehow.
I'm willing to learn all this, I just don't know where to begin. I just need a steer.
Could someone please advise me on what I need to learn to be able to do all this stuff? API calls, etc.
Thanks for reading,
Jim
May 27, 2016 at 8:02 am
Some web development may be required. And/or maybe some local scripts to pull the data from the API. Here's one I found with a quick search on Bing: http://openweathermap.org/API.
My personal experience has been with PHP, and this could be done in PHP. Also, will you want to store this data in your DB?
June 2, 2016 at 8:24 am
Someone did this with an SSIS script.
http://www.codeproject.com/Articles/679706/Weather-Scraper-to-Get-Weather
Bear in mind this was from 2013, so the API may have changed since then.
June 2, 2016 at 12:29 pm
Oh cool, thanks for the advice. I'll have go at that.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply