Codeless solution for consuming REST API in SSIS

Working with REST APIs in SSIS can be challenging and time consuming. Our SSIS add-on components simplify the process and offer easy-to-use SSIS components to work with any REST or SOAP endpoint.

REST API Connection

Establish connection to API

All processes begin with the connection. Using our HTTP Connection Manager developers can connect to any REST or SOAP endpoint easily. The connection manager will support custom and third-party APIs including those requiring OAuth2 authentication.


Retrieve hierarchical data

Using JSON Source component developers can quickly retrieve JSON documents from your REST endpoint and extract the data into column data. The same process can be done with endpoints using XML by using XML Source.

SSIS REST Destination

Send hierarchical data

Using JSON Destination component developers are able to merge column data into hierarchical JSON structure before writing to the target REST destination. The same processes can be done with endpoints using XML by using XML Destination.

How to Work with RESTful Endpoints in your SSIS ETL Process: See our blog post on how to use our components to integrate with a REST API in SSIS using ZenDesk as an example.

We didn't have any experienced development skills internally but a lot of SQL/SSIS experience - getting the SSIS Productivity Pack enabled us to build connections to numerous API's in a timely fashion and pull the data into our data warehouse.

Philip Schonewille

Integration with an Enterprise or Commercial web application?

Our REST components can still be used to integrate with these applications but we may have an even greater solution available for you. See our current solutions to see if we have SSIS components built to interact specifically with your online application (Such as Dropbox, Google Analytics, HubSpot, Salesforce and many more). Since these components were built exclusively for their web application they offer significantly greater functionality and ease of use. You are able to integrate with these REST or SOAP endpoints with the data already structured into column format, with many additional functional features available.

If you are integrating with an application we do not yet have dedicated components for, please let us know!