The Task Factory REST Source and Destination SSIS components can be configured in minutes to easily extract data from, and write data to, web or internal RESTful sources.
Task Factory provides dozens of high-performance SSIS components, including REST connectors, that save you time and money by accelerating ETL processes and eliminating many tedious SSIS programming tasks.
The REST Source in Task Factory allows you to connect to almost any web service/cloud application that utilizes a REST API and to bring that data right into your data flow. The component can handle both XML and JSON data being returned from the REST endpoints, which means it supports both legacy (XML based) and newly created (with JSON) REST endpoints.
With its support for Basic REST,
The REST Destination in SSIS makes it easy to create records quickly in a RESTful source. It's simple to configure in minutes, with many pre-built configuration files.
Common use cases include creating webinars in GoToWebinar, bulk
A Task Factory license is not required to use Task Factory when developing and running packages in Visual Studio/SSDT. However, a Task Factory license is required to use Task Factory for packages run outside of Visual Studio/SSDT.