COZYROC has the pleasure to announce the official release of the COZYROC SSIS+ 1.9 library. We are very excited about the possibilities this new version provides to our customers for easier connectivity to any REST service. The other major highlight of the 1.9 release is the support for JavaScript scripting, which can dramatically simplify the implementation of custom parts in a solution by enabling a rapid development of reusable, easily-configurable components and tasks.

Those new capabilities, not available in any other product on the market, further increase the value of our SSIS+ suite, which is well-known for bringing major innovations to SSIS customers with the support of dynamic data flows, composite records modelling, etc. By choosing COZYROC SSIS+ 1.9 you can rest assured you are purchasing the most advanced technology on the market for solving even the most challenging problems in your integration projects. And the best part is that we still offer the most affordable subscription for a fully-fledged SSIS suite of tasks and components. Cheers!

We have two announcements to make:

  • Support for SQL Server 2005 and 2008 is still included. The support for these older SQL Server versions is planned for removal in the next major version. Please note the 2008 binaries now target .NET Framework 3.5 instead of .NET 2.0.
  • The cost of the SSIS+ 1.9 perpetual license has been increased to $4,999 per license.

The COZYROC Team

Summary of the products available immediately for purchase:

  • SSIS+ Ultimate Subscription at $699/Year.
  • SSIS+ 1.9 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: Support for SQL Server 2019.
  • New: Support for SSDT for Visual Studio 2019.
  • Improved: High-DPI scaling for high-resolution monitors.
Acumatica Connection
  • New: Introduced connection.
Aircall Connection
  • New: Introduced connection.
Alchemer Connection
  • New: Introduced connection.
Amazon Athena Connection
  • New: Introduced connection.
Amazon S3 Connection
  • New: Introduced connection.
AMQP Connection
  • New: Introduced connection.
Azure Table Connection
  • New: Introduced connection.
BigCommerce Connection
  • New: Introduced connection.
Bloomerang Connection
  • New: Introduced connection.
Capsule CRM Connection
  • New: Introduced connection.
Dynamics Business Central Connection
  • New: Introduced connection.
Eventbrite Connection
  • New: Introduced connection.
Exchange Connection
  • New: Implemented to create OAuth2 version 2.0 access tokens for Exchange Online.
File Transfer Task
  • 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.
Formstack Connection
  • New: Introduced connection.
Google BigQuery Connection
  • New: Improved parameter entry.
Google Cloud Storage Connection
  • New: Introduced connection.
Google Drive Connection
  • New: Improved parameter entry.
Google Maps Connection
  • New: Introduced connection.
Google People Connection
  • New: Introduced connection.
Google Sheets Connection
  • New: Improved parameter entry.
GoToWebinar Connection
  • New: Introduced parameters for specifying client id/secret during the authentication token generation.
IMAP Connection
  • New: Support for Google OAuth 2.0 authentication.
  • New: Support for Microsoft OAuth 2.0 authentication.
Infusionsoft Connection
  • New: Introduced connection.
JotForm Connection
  • New: Introduced connection.
Kafka Connection
  • New: Introduced connection.
Kintone Connection
  • New: Introduced connection
KRONOS Connection
  • New: Support for global reports.
LDAP Connection
  • New: Attributes from auxiliary classes (sAMAccountName, etc) are now included.
Linkedin Connection
  • New: Support for 'Page Statistic' resource.
Message Queue Task Plus
  • New: Introduced task.
Microsoft Dataverse Connection
  • 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.
Microsoft Graph Connection
  • New: Introduced connection.
OFTP Connection
  • New: Introduced connection.
Pardot Connection
  • New: Support for OAuth authentication.
Parquet Destination
  • New Introduced component.
Parquet Source
  • New: Introduced component.
PayPal Connection
  • New: Introduced connection.
PDF Source
  • New: Introduced component.
Power BI connection
  • New: Introduced connection.
PowerShell Task
  • New: Introduced task.
QuickBooks Online Connection
  • New: Introduced connection.
RabbitMQ Connection
  • New: Introduced connection.
REST Connection
  • New: WSDL Import.
  • New: A new feature to prepare the JavaScript expression for the Result element in the Read 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.
REST Destination
  • New: Support for multithreaded processing.
Sage 300 Connection
  • New: Introduced connection.
Sage Intacct Connection
  • New: Introduced connection.
Salesforce Connection
  • 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.
Salesforce Source
  • New: Support for SOQL statements returning composite data.
SendGrid Connection
  • New: Updated 'Single Send' resource metadata as required. For further information, check here.
Shopify Connection
  • New: Support for 'Payout', 'Balance', 'Dispute', 'Transaction' resources.
Smartsheet Connection
  • New: Improved parameter entry.
SMTP Connection
  • New: Support for Google OAuth 2.0 authentication.
  • New: Support for Microsoft OAuth 2.0 authentication.
Stripe Connection
  • New: Introduced connection.
SugarCRM Connection
  • New: Introduced connection.
SuiteCRM Connection
  • New: Introduced connection.
SurveyMonkey Connection
  • New: Improved parameter entry.
Twilio Connection
  • New: Support for 'Message' resource.
Typeform Connection
  • New: Introduced connection.
XML Destination
  • New: Introduced component.
Zendesk Connection
  • New: Improved handling of custom fields in 'User' resource.
Zoho Sheet Connection
  • New: Introduced connection.