Codeless solution for consuming REST API in SSIS. 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.
Working with REST APIs in SSIS can be challenging and time consuming. 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.
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.
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
BaseCamp
BigCommerce
Constant Contact
Copper
DocuSign
eBay
Eventbrite
Facebook Business
Freshbooks
Freshdesk
Freshsales
GitHub
GoToWebinar
Keap (InfusionSoft)
Insightly
Jira
LinkedIn Business
Magento
MailChimp
Mailgun
Microsoft Dynamics 365 Customer Insights
Microsoft To Do
MYOB
PayPal
Pipedrive
Quickbase
Sage Business Cloud
Salesforce Pardot
Sendinblue
SendGrid
ServiceNow
Shopify
Slack
SmartSheet
Snapchat
Square
Stripe
SugarCRM
SuiteCRM
SurveyMonkey
Teamwork
TikTok Business
Trello
Twilio
Twitter Business
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.