Data Integration Made Easy
Unlock the full potential of
your REST services with KingswaySoft's feature-rich SSIS Productivity Pack.
No More Complex Coding
ETL developers can effortlessly integrate REST services
with any application or database system.
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. Our HTTP Connection Manager allows you to 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.
Using REST components, you can integrate these endpoints with virtually any other application or database system.
See our blog post on how to use our components to integrate with a REST API in SSIS using ZenDesk as an example:
How to Work with RESTful Endpoints in your SSIS ETL Process
Supported
REST Applications
Act-On
ActiveCampaign
Acumatica
ADP
Airtable
Asana
Authorize.Net
Azure Application Insights
Azure Table
BambooHR
BaseCamp
BigCommerce
Bill.com
Blackbaud
Calendly
Crelate
Ceridian Dayforce
Chargebee
Chargify
ClickUp
Constant Contact
Copper
Discord
DocuSign
Drift
Duo Security
eBay
Elasticsearch
Emarsys
Emfluence
Expensify
Eventbrite
Extensiv
Facebook Business
Facebook Messenger
Freshbooks
Freshdesk
Freshsales
Freshservice
GetResponse
GitHub
Google Calendar
Google Classroom
Google Forms
Google Maps
Google People
Google Search Console
Google Tag Manager
GoToWebinar
Keap (InfusionSoft)
Insightly
Jira
LinkedIn Business
JotForm
Magento
MailChimp
Mailgun
Mailjet
Microsoft Dynamics 365 Customer Insights
Microsoft Planner
Microsoft Teams
Microsoft To Do
MYOB
Okta
OneLogin
Open Accounting
OpenAI
Paycor
PayPal
Ping Identity
Pipedrive
Power BI
Prestashop
Quickbase
Replicon
RingCentral
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
Webex
WordPress
Wrike
WooCommerce
Xero
Yammer
YouTube Analytics
Zendesk
Zoho Books
Zoho CRM
Zoho Desk
Zoho Expense
Zoho Invoice
Zoho Sheet
Zoom
Zuora
REST Components are available in our
SSIS Productivity Pack
Familiar UI
A performant and flexible ETL platform
Our solution is built utilizing Microsoft SQL Server Integration Services (SSIS), allowing your team to take advantage of the technologies and skills they already have. The drag-and-drop user interface makes it easy to set up powerful integrations within a matter of minutes.
More Resources
Download our Data Sheet for
SSIS Productivity Pack
Make a Suggestion
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.