COZYROC SSIS+ 2.1 now officially released

Thursday, June 23, 2022 - 11:11

COZYROC has the pleasure to announce the official release of the COZYROC SSIS+ 2.1 library. The new version includes support for 31 additional applications. In addition, we have introduced COZYROC Message Queue Task Plus, making the interaction with message queue systems a breeze. The COZYROC REST framework has been further improved with support for WSDL (SOAP) definitions import, token generation using the latest Microsoft Edge browser and expression design dialog for assisting with data extraction. If you have a need to generate complex XML documents, it is now possible with the new XML Destination component.

The COZYROC Team

Summary of the products available immediately for purchase:

SSIS+ Ultimate Subscription at $1199/Year.
SSIS+ 2.1 perpetual license at $7,999
SAS® Adapters license at $2,499.95
USPS Address Database / One time purchase at $299.95
USPS Address Database / Monthly Subscription at $2,399.95/Year
SSIS+ Premium Support at $499.95/Year

For more information, check the purchase page.

Summary of the new / updated components

Blackbaud Connection

New: Defined 'Financial | Fixed Asset' resource.
New: Defined 'Financial | Fixed Asset Transaction' resource.
New: Defined 'School | Meeting' resource.
New: Included definition for new /creditmemos API.
Fixed: Corrected pagination for 'Church | Action' resource.

Database Source

Fixed: Design time issue when using SELECT DISTINCT clause.
Fixed: Issue with handling nvarchar(max) columns in SQL Server.

Derived Column

New: Included encodeBase64Bytes and decodeBase64Bytes functions to work with DT_BYTES, DT_IMAGE columns.
Fixed: Many improvements and cleanup.

Excel Source

New: TrimColumnNames parameter to specify whether to remove whitespace from start/end of column names.

Jira Connection

New: Updated to use new Project read endpoint.
Fixed: Corrected default service base url.

Microsoft Graph Connection

New: Defined 'Communication | Direct Routing Call' resource.
New: Defined 'Communication | PSTN Call' resource.

Power BI connection

New: Included client_credentials authentication.

REST Connection

New: [OpenAPI Import] Support for schema types with multiple references.
New: [WSDL] integrations are now using JSON definitions everywhere.
New: [GraphQL] Improved support for mutations.
Fixed: Error when trying to use variables in GraphQL query (Thank you, Christina).
Fixed: Incomplete data transfer when streaming from one REST connection to another.
Fixed: [OData] Performance issues with large XML responses.