Need help with SSIS 2008R2 methods for extracting from RESTful API
-
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.
-
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.
-
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