With the REST components found within SSIS Productivity Pack, ETL developers can easily connect and integrate with various REST endpoints without writing a single line of code.

Our REST components make it easy to integrate with popular applications that offer a REST API to interact with the application. Each endpoint available has been developed to work with all the intricacies of that particular web service. This way developers spend less time developing and can focus on quickly getting the right data into the right spot.

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.

SSIS REST Source


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.

Using REST components, you can integrate these endpoints with virtually any other application or database system.

Our REST components offer data integration solutions for:

act-on connector

acumatica connector

adp connector

asana connector

azure application insights connector

basecamp connector

bigcommerce connector

constant contact connector

ebay connector

eventbrite connector

eventbrite connector

facebook business connector

facebook business connector

freshbooks connector

freshdesk connector

infusionsoft connector

insightly connector

jira connector

linkedin connector

magento connector

mailchimp connector

microsoft teams connector

myob connector

paypal connector

sage connector

paradot connector

servicenow connector

shopify connector

slack connector

smartsheet connector

square connector

stripe connector

surgarcrm connector

surveymonkey connector

teamwork connector

trello connector

twilio connector

twitter connector

wordpress connector

zuora connector

woocommerce connector

xero connector

yammer connector

zendesk connector

Don't see the service you are looking for?

We offer many other connectivity solutions, browse our product page for the full list or take a look at our JSON/XML components to integrate with virtually any API.