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.


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

ActiveCampaign Connector

acumatica Connector

adp Connector

asana Connector

azure application insights Connector

basecamp Connector

bigcommerce Connector

constant contact Connector

copper Connector

docusign Connector

ebay Connector

elasticsearch Connector

eventbrite Connector

facebook business Connector

facebook business Connector

freshbooks Connector

freshdesk Connector

Freshsales Connector

GitHub Connector

gotowebinar Connector

infusionsoft Connector

insightly Connector

jira Connector

linkedin Connector

magento Connector

mailchimp Connector

mailgun Connector

Microsoft Dynamics 365 Connector

Microsoft Teams Connector

Microsoft To Do Connector

myob Connector

paypal Connector

pipedrive Connector

Quickbase Connector

sage Connector

paradot Connector

sendinblue Connector

SendGrid Connector

servicenow Connector

shopify Connector

slack Connector

smartsheet Connector

snapchat Connector

square Connector

stripe Connector

surgarcrm Connector

SuiteCRM Connector

surveymonkey Connector

teamwork Connector

TikTok Connector

trello Connector

twilio Connector

twitter Connector

wechat Connector

wordpress Connector

woocommerce Connector

xero Connector

Yammer Connector

YouTube Connector

zendesk Connector

Zoho Books Connector

Zoho CRM Connector

Zoho Desk Connector

Zoom Connector

Zuora 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.