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 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy