Saturday, September 5, 2020 - 12:00
COZYROC has the pleasure to announce the official release of the COZYROC SSIS+ 2.0 library. The new version includes major improvements in usability during design time. With the addition of Database Destination (for easy Upserts and fast DB loads), COZYROC SSIS+ now offers the most powerful toolbox for developing data warehousing solutions (see also Table Difference, Lookup Plus and Sort components). The COZYROC REST framework has been further refined and you can now access, directly from Visual Studio, a rapidly growing library of pre-built templates/accelerators for consuming numerous popular third-party web APIs (currently 40+ services).
The COZYROC Team
Summary of the products available immediately for purchase:
- SSIS+ Ultimate Subscription at $899/Year.
- SSIS+ 2.0 perpetual license at $4,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
- New: Destination components now have the ability to preserve existing columns mapping.
- New: Ability to access data flow component properties expression without leaving the dialog.
- New: Vastly improved destination component columns mapping with fine-grained filtering.
- New: Ability to select a prebuilt template as a starting point for your REST configuration efforts.
- New: Available reusable JavaScript scripts are now easy to access directly from Visual Studio.
- New: COZYROC components group in the SSIS Toolbox for convenience.
- New: The library is no longer dependent on certain SSIS design-time components.
- New: An enhanced dialog for FLEE expression definition.

- New: Support for Azure Flexible File Source and Destination components.
- New: Context menu item "Remove Static Columns" when right-clicking on a component.
- New: SSDT installation is no longer required during runtime.

- New: A new optional attribute segname for segment element in configuration file. If specified, the component will provide segment name information.

- New: The result returned from 'Get remote files list' action can now be iterated using the standard 'Foreach ADO Enumerator'.

- New: Support for RFC 6749 compliant OAuth2 authentication.
- New: Updated to GoToWebinar 2.0 REST API.

- New: The result returned from 'Get remote files list' action can now be iterated using the standard 'Foreach ADO Enumerator'.

- New: Support for join fields in a saved search.
- New: Improved support for custom fields in a saved search (Thank you, Mauro).

- New: A new parameter ServerHost to support the new OpenAir service host requirement. The old ConnectionType parameter is no longer relevant and has been removed.

- New: Updated QuickBooks Online web service proxy to version 43.
- New: A new parameter 'Start on Open' in QuickBooks Desktop Edition Gateway to automatically start the gateway when the application is opened.
- New: Support for QuickBooks Online sandbox environment.

- New: The result returned from 'Get mail list' action can now be iterated using the standard 'Foreach ADO Enumerator'.

- Breaking Change:
Resource.Field.Default
attribute has been removed from the configuration schema. - New: Enable retrieving API tokens within a modern Chromium-based web browser component (as an alternative to the IE-based one).
- New: OpenAPI import.
- New: Authentication template for Google User Account.
- New: Authentication template for Google Service Account.
- New: Authentication template for Amazon Web Services Signature v4.
- New: Iterator template for OData services.

- New: Experimental feature to explicitly specify authentication token when using MFA-enabled service. For further information please review 'Establish connection to MFA-enabled service' Quick Start.
- New: Support for on-premises servers that use ADFS authentication.

- New: If key-file authentication fails, the connection will attempt password-only authentication (Thank you, Pavel).

- New: A new 'Diagnostic Log' output to analyze the differences on a more granular level.