COZYROC has the pleasure to announce the official release of the COZYROC SSIS+ 1.8 library. In addition to the availability of many new connectors, we have invested extra effort in the overall polish of the toolkit. A new build and release process was also implemented and you will soon see improvements in both the availability and frequency of development releases and higher quality official releases. We have two announcements to make:

  • Version 1.8 will be the last version with support for SQL Server 2005 and 2008. We hope this will provide enough time to our customers to make the transition to newer and greater SQL Server versions.
  • Starting on June 1st, 2018 the cost of one SSIS+ Ultimate subscription becomes $479/year for new subscriptions. The price for existing subscribers stays the same, as long as their subscriptions are kept current.

Thank you for investing your hard-earned dollars in our products! Your investment is in safe hands and we will not disappoint you!

The COZYROC Team

Summary of the products available immediately for purchase:

  • SSIS+ Ultimate Subscription at $399.95/Year. Starting on June 1st, 2018 the price becomes $479/year.
  • SSIS+ 1.8 perpetual license at $3,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 2017.
  • New: Support for SSDT for Visual Studio 2017.
  • New: Support for Azure ADFv2 deployment.
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.
  • New: Store authentication token in a database.
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.