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: Implemented to create OAuth2 version 2.0 access tokens for Exchange Online.

- New: Support for Salesforce connection.
- New: A new AdditionalOptions parameter for specifying additional action options.
- New: Support for recursive upload of sub-folders and files.
- New: Parameters for Retry On Error.

- New: Introduced parameters for specifying client id/secret during the authentication token generation.

- New: Support for Google OAuth 2.0 authentication.
- New: Support for Microsoft OAuth 2.0 authentication.

- New: Implemented to create OAuth2 version 2.0 access tokens.
- New: Support for FetchXml data retrieve.
- New: Support for 'continue-on-error' data processing.
- New: Support for Update/Upsert with alternate keys.
- New: Support for Upsert using 'Duplicate Detection Rules' definition.
- New: A new action parameter IgnoreNullValue to ignore NULL input values.
- New: A new action parameter IgnoreMissingIdentifier to ignore missing lookup identifiers.
- New: A new action parameter IgnoreUnchanged to avoid making updates where the input data is same as current.
- New: 'listmembers' resource for list members maintenance.

- New: WSDL Import.
- New: A new feature to prepare the JavaScript expression for the
Result
element in theRead
action by detecting common usage patterns. - New: A new feature to store authentication token in a database.
- New: Support for client certificate configuration.
- New: Enable retrieving API tokens within Microsoft Edge web browser component.

- New: Updated web service proxy to version 54.
- New: Support for Salesforce library files maintenance with File Transfer Task.
- New: Parameters for Retry On Error.

- New: Updated 'Single Send' resource metadata as required. For further information, check here.

- New: Support for Google OAuth 2.0 authentication.
- New: Support for Microsoft OAuth 2.0 authentication.