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 connectors 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.
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 connectors offer data integration solutions for:
Act-On
ActiveCampaign
Acumatica
ADP
Asana
Azure Application Insights
Azure Table
BaseCamp
BigCommerce
Bill.com
Calendly
Ceridian Dayforce
Chargebee
Chargify
ClickUp
Constant Contact
Copper
Discord
DocuSign
Drift
eBay
Elasticsearch
Expensify
Eventbrite
Facebook Business
Facebook Messenger
Freshbooks
Freshdesk
Freshsales
GitHub
GoToWebinar
Keap (InfusionSoft)
Insightly
Jira
LinkedIn Business
JotForm
Magento
MailChimp
Mailgun
Mailjet
Microsoft Dynamics 365 Customer Insights
Microsoft Teams
Microsoft To Do
MYOB
Okta
PayPal
Pipedrive
Power BI
Prestashop
Quickbase
Sage Business Cloud
Salesforce Pardot
Sendinblue
SendGrid
ServiceNow
ShipStation
Shopify
Slack
SmartSheet
Snapchat Business
Square
Stripe
SugarCRM
SuiteCRM
SurveyMonkey
Teamwork
TikTok Business
Trello
Twilio
Twitter Business
Typeform
WordPress
WooCommerce
Xero
Yammer
YouTube Analytics
Zendesk
Zoho Books
Zoho CRM
Zoho Desk
Zoom
Zuora
SSIS REST components are all available in SSIS Productivity Pack.
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.