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