SSIS REST integration Framework | COZYROC SSIS+ components suite

COZYROC REST Framework for integration with any REST service. Sync and import / export data from any REST API service to SQL Server.

The connectivity to REST APIs is implemented thru an XML configuration file which can contain both statically defined elements and also JavaScript custom code for additional flexibility.

By utilizing this unique and powerful framework we are able to very quickly provide support for many other REST-based applications. This framework can also be utilized by our customers to create their own connectivity to REST-based applications for which there is no pre-built configuration available yet. You can use any application, service or database supported by SQL Server Integration Services (SSIS) or COZYROC’s toolkit as the source or destination for REST.

The REST SSIS integration package consists of four parts: ⬅️ Click here to download the latest version.

REST Connection Manager

• Stores the credentials and functionality for connecting to REST service.
• Support for any authentication based on parameters or token.
• Support for web service call retry, including ability to retry only in specific situations.
• Support for web service calls per seconds throttling.
• Well documented API for use by user-defined scripts.

REST Source component

• Retrieves data from a REST resource.
• The source can be dynamically modified at runtime using an SSIS expression.
• Support for resource metadata extension (XML definition) for additional customization.
• Natural support for reading composite objects (i.e. line items) where a separate output is configured for each composite object.

REST Destination component

• Inserts or updates data in REST resource.

• Supports of up to four resource actions: Create, Update, Delete or Upsert

• Provides information about records with errors as well as the identifier assigned for new records created.

• Support for resource metadata extension (XML definition) for additional customization.

• Natural support for writing composite objects (i.e. line items) where a separate input is configured for each composite object.

• COZYROC SSIS REST framework video. With the COZYROC SSIS REST framework you can connect to any Web service and consume any Web API. Free for download and development https://www.cozyroc.com/ssis/rest

COZYROC SSIS+ Components Suite is free for download and development within Visual Studio

✔️ Free developer license.

✔️ Support for SQL Server 2012, 2014, 2016, 2017, 2019, 2022

✔️ COZYROC SSIS+ suite includes more than 250 tasks and SSIS components for ETL and Data Integration

✔️ A licensed version can be deployed on-premises, on Azure-SSIS IR and on COZYROC Cloud

✔️ One-time migrations and data transfers are completely FREE.

The COZYROC SSIS+ components suite also includes:

The powerful and elegant Data Flow Task Plus, not found in any other competitive product on the market. Data Flow Task Plus allows creation of Dynamic data flows at runtime and can be used with COZYROC's REST adapters.

Check the SSIS Data Flow Task demo video in our Youtube channel.

• COZYROC SORT Plus SSIS component video. With COZYROC’s Sort Plus SSIS component, you can sort ANY amount of data and any number of records. Free for download and development https://www.cozyroc.com/ssis/sort

• For a full compatibility list and more information about the COZYROC SSIS+ Components, please visit the COZYROC website

Try COZYROC Cloud for free. The COZYROC.Cloud hosted service allows you to Lift & Shift legacy SSIS workloads to the cloud in a breeze at a very affordable price which includes a license for the COZYROC SSIS+ suite.

Get in touch with us:

• For support or any questions connect with us