Working with REST APIs in SSIS can be challenging and time consuming. Our SSIS add-on components simplify the process and offer easy-to-use SSIS components to work with any REST or SOAP endpoint.
Connecting to REST API
All processes begin with the connection. Using our HTTP Connection Manager developers can connect to any REST or SOAP web endpoint easily. The connection manager will support custom and third-party APIs including those requiring OAuth2 authentication.
SSIS REST Source
Using our 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 our XML Source instead.
SSIS REST Destination
Using our JSON Destination component developers are able to merge column data into JSON by creating hierarchical JSON structure before writing to the target REST destination. The same processes can be done with endpoints using XML by using XML Destination.
Integration with an Enterprise or Commercial web application?
Our REST components can still be used to integrate with these applications but we may have an even greater solution available for you. See our current solutions to see if we have SSIS components built to interact specifically with your online application (Such as Dropbox, Google Analytics, HubSpot, Salesforce and many more). Since these components were built exclusively for their web application they offer significantly greater functionality and ease of use. You are able to integrate with these REST or SOAP endpoints with the data already structured into column format, with many additional functional features available.