September 7, 2014 at 9:30 pm
I use SSIS Business Intelligence Development Studio 2008R2 to handle ETL tasks from relational databases and flatfiles.
One client has asked me to extract from a third parties RESTful API which I have never done before.
I have authentication information from the Third Party Vendor (APIKey, APISecret, Username and Pwd)
I have information on the URL syntax for HTTPS GET requests.
I do not know how to put this all together within SSIS and need a point in the right direction to get started.
Thanks.
September 7, 2014 at 10:07 pm
DAVID.MANGATAL (9/7/2014)
I use SSIS Business Intelligence Development Studio 2008R2 to handle ETL tasks from relational databases and flatfiles.One client has asked me to extract from a third parties RESTful API which I have never done before.
I have authentication information from the Third Party Vendor (APIKey, APISecret, Username and Pwd)
I have information on the URL syntax for HTTPS GET requests.
I do not know how to put this all together within SSIS and need a point in the right direction to get started.
Thanks.
Quick thought, there are few possible options, two most obvious ones are to find a third party component or use a script task and write the code yourself.
September 8, 2014 at 12:00 am
In theory a Script Component used in a Data Flow Task could work for you.
Some links that may help get you started:
Here is one that demos using a Script Component as a Source: http://www.selectsifiso.net/?p=578
This one uses a Script Component that consumes a REST service, but it sets up the Component as a Transformation not a Source, however that may be what you want depending on your requirements : http://markarlenplace.wordpress.com/2010/12/30/consuming-restful-web-services-in-an-ssis-script-transformation/%5B/url%5D
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 3 posts - 1 through 3 (of 3 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