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: A custom editor to replace the basic one.
- New: All previous configuration properties are now available in the new EDI Connection. This is the recommended way of configuring the component.
- New: A new parameter InsertSequenceTerminator to support "composite records"-compatible formatting of output data.

- New: Support for Excel 2019.
- New: A new parameter DateTimeFormat to specify string format when writing DateTime values.

- New: Support for 'Analytics', 'Association', 'Ticket', 'Product', 'Line Item', 'CRM Object Property' resources.

- New: Updated web service proxy to version v2018.2.
- New: Support for token-based authentication.

- New: Support for reading from 'Email', 'Email Stats' resources.
- New: Authentication now placed in request header as required by service.

- New: Support for QuickBooks Online OAuth 2.0 authentication.
- New: Updated QuickBooks Desktop web service proxy to version 13.
- New: A new parameter QBXMLVersion for use with QuickBooks Desktop connections.
- Fixed: Failed with error when using 'ItemSites' object (Thank you, Joel).

- New: Ability to author configurations to arbitrary REST services.
- New: Slight modifications in the RCM configuration format for improved consistency.
- New: Getting Help now opens a more relevant documentation page (depending on the selected configuration and current tab).
- New: Included option to tweak user agent of web browser used in 'New Token' wizard dialog.

- New: A new parameter Endpoint to explicitly specify the endpoint used for data retrieval.
- New: Usability improvements in the UI for managing parameters.
- New: A design-time log, accessible via a new 'View Log' button (for troubleshooting purposes).
- New: Enhancements in the logging output.

- New: Improved the metadata initialization when using SOQL statements (no more missing columns if the result contains empty fields).
- New: Support for Bulk mode for SOQL statements.
- Fixed: The "Preview" failed with "EXCEEDED_ID_LIMIT" error under some conditions.

- New: Support for 'Inventory Item', 'Inventory Level', 'Inventory Location' resources.

- New: A new parameter Compression.
- New: Included support for Curve25519 elliptic curve algorithm.