 |
ZappySys develops tools and connectors for Microsoft Business Intelligence, Azure, Amazon AWS, MongoDB and more... We provide everyday tools to make developer life easy. Check outour products including many FREE tools. If you are an MVP you may qualify for FREE MVP License |
SSIS REST API Web Service Task
SSIS REST API Web Service Task can be used to send/receive data using HTTP Web Request (e.g. GET, POST, PUT etc.). You can validate and save Web Response to file or variable. This task also supports Basic/OAuth 2.0 Authorization to connect with a verity of services (e.g. Facebook, Twitter, Salesforce).
Features
- Call REST Style HTTP Web Service from SSIS (e.g. Perform HTTP GET, POST, LIST )
- Support for windows or basic authentication
- Save response to variable or file
- Filter JSON response using JSONPath to extract specific value inside response text
- Filter XML response using XPath to extract specific value inside response text
- Validate response using custom rules such as Response Code must be less than 300, Response Content must contain XYZ string, Response Header must contain certain key/value pair ... etc
- Support for Testing UI
- Support for dynamic variable replacement with format specifiers anywhere inside header or request data (e.g. {{User::MyVar}} {{User::MyDate,yyy-MM-dd}} {{User::MyAmount,C}} )
- Use of BASE64 format specifiers (e.g. {{User::Creds,BASE64ENC}} will replace value with Base64 Encoded string and {{User::Creds,BASE64DEC}} will decode Base64 string. This is very useful for sending Authorization Headers which is usually base64 encoded
- Support for SQL Server 2012, 2014, 2016, 2017 and 2019 (32 bit / 64 bit)
Screenshots
 |
SSIS PowerPack is a collection of 70+ high performance, drag and drop connectors/tasks for SSIS (i.e. Microsoft SQL Server Integration Services). SSIS PowerPack is designed to boost your productivity using easy to use, coding-free components to connect many cloud as well as on-premises data sources such as REST API Services, Azure Cloud, Amazon AWS Cloud, MongoDB, JSON, XML, CSV, Excel, Salesforce, Redshift, DynamoDB, Google API (i.e. Analytics, AdWords), SOAP/Web API, Facebook, Twitter, Zendesk, eBay and many more.
SSIS PowerPack also includes high quality FREE commercial components and tasks with full support/upgrade
Click here to read more ...
|
Why SSIS PowerPack?
- Coding free, drag & drop high performance suite of Custom SSIS Components and SSIS Tasks
- Used by many companies around the globe
- Easy to use, Familiar looks and feel and fully integrated in BIDS/SSDT
- No license needed if you are developing/testing in BIDS/SSDT
- Rapid update cycle and prompt support (See what's new). We will help you over phone, web meetings and via email.
- 30 days money back guarantee if not satisfied for whatever reason.
Data Integration Categories
| |
