+1 617-209-4151

REST API CUSTOM TASK FOR SSIS

REST API CONNECTION TASK

SSIS REST API Task is your one stop solution to integrate REST API Web Service Call in SSIS package. Innovative Drag and Drop approach. REST API Task can be used to send and receive HTTP GET, POST Web Request. You can also validate and save Web Response.

Rest API Web Service Task for SQL Server Integration Services (SSIS)




Rest API Web Services for SSIS
  • 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 2005, 2008, 2012, 2014 (32 bit and 64 bit)
  • Fully supported products with new releases and updates 1-3 times a year
  • Customer focused technical support – Phone, Web, Chat, Email

  • Transferring data can being time-consuming, tedious, error-prone and ties up valuable employee time.
  • How proficient are you at writing code? (time+errors = $$)
  • Do you have access to development staff to write code. (time+delays = $$)
  • Do use outside resource to write code? (tech service costs = $$$)


Perpetual Licensing

  • SSIS Rest API Source Connection Task
  • Perpetual Licensing
    (1 Year Support and Upgrades Included)
  • Integrates Directly into Business Intelligence Studio (BIDS)

$849.00 USD







Subscription Licensing

  • SSIS Rest API Source Connection Task
  • Subscription Licensing (12 Month Annual)
  • Integrates Directly into Business Intelligence Studio (BIDS)

$399.00 USD




  • Easy to use simple drag and drop, familiar look and feel, fully integrated in BIDS/SSDT.
  • Web Demos, Training Videos, Online Product Help, Blog, Forum, White Papers

Additional JSON Components for SQL Server Integration Services (SSIS)

Export JSON File
Task for SSIS
JSON Generator Transform for SSIS
JSON Integration
Pack for SSIS

JSON Parser Transformation

JSON Parser
Task for SSIS


Connect to all your Data Sources!

There is more to 'Reaching for the Clouds' than just infrastructure. it’s about building a system that applies to your business and in doing so creating efficiencies and workflow processes that ultimately reduces overall operational costs. Anyone can use technology. It’s about peeling back the onion and truly understanding the reasons behind how and why you are building it. The world as we know it is evolving at rapid speeds, becoming more mobile with each technological advancement.

Connect to Microsoft SQL Azure!

With SQL Azure 99.9% guaranteed uptime and their higly secure billion dollar data centers makes it a logical decision. Can your company guarantee your databases won't be breached? The term 'cloud computing' refers to a variety of Internet-based computing services. The difference between cloud-based and traditional software is that when you access the cloud, your desktop or laptop isn't the thing doing the actual computing, reducing overall operational costs. Check out our SQL Azure Tasks if Microsoft is your cloud choice.

With Amazon leading the charge in Cloud Computing . Reach for the Clouds, Inc. had to supply it's clients a way to move their data to Amazon Cloud. Can your company guarantee your databases won't be breached? The term 'cloud computing' refers to a variety of Internet-based computing services. The difference between cloud-based and traditional software is that when you access the cloud, your desktop or laptop isn't the thing doing the actual computing, reducing overall operational costs. Check out our Amazon Tasks and Adapters.

Reach for the class has a staff that has been delivering Microsoft SSIS products for the last decade for SQL Server. Schedule a demo or simply trial the software for free. We are here to make you experience a truly successful one so please do not hesitate to reach out to our certified cloud professionals.

There is more to 'Reaching for the Clouds' than just infrastructure. it’s about building a system that applies to your business and in doing so creating efficiencies and workflow processes that ultimately reduces overall operational costs. Anyone can use technology. It’s about peeling back the onion and truly understanding the reasons behind how and why you are building it. The world as we know it is evolving at rapid speeds, becoming more mobile with each technological advancement.

Reach for the Clouds focuses on delivering modern business solutions that are innovative and proactive, connecting organizations with their people and their ecosystem, allowing organizations to deploy individual business scenarios.

Connect to all your Data Sources!

There is more to 'Reaching for the Clouds' than just infrastructure. it’s about building a system that applies to your business and in doing so creating efficiencies and workflow processes that ultimately reduces overall operational costs. Anyone can use technology. It’s about peeling back the onion and truly understanding the reasons behind how and why you are building it. The world as we know it is evolving at rapid speeds, becoming more mobile with each technological advancement.

Connect to all your Data Sources!

There is more to 'Reaching for the Clouds' than just infrastructure. it’s about building a system that applies to your business and in doing so creating efficiencies and workflow processes that ultimately reduces overall operational costs. Anyone can use technology. It’s about peeling back the onion and truly understanding the reasons behind how and why you are building it. The world as we know it is evolving at rapid speeds, becoming more mobile with each technological advancement.

Connect to all your Data Sources!

There is more to 'Reaching for the Clouds' than just infrastructure. it’s about building a system that applies to your business and in doing so creating efficiencies and workflow processes that ultimately reduces overall operational costs. Anyone can use technology. It’s about peeling back the onion and truly understanding the reasons behind how and why you are building it. The world as we know it is evolving at rapid speeds, becoming more mobile with each technological advancement.