COZYROC SSIS+ 2.2 now officially released

Wednesday, February 14, 2024 - 06:55

COZYROC has the pleasure to announce the official release of the COZYROC SSIS+ 2.2 library. The new version includes support for 37 additional applications. We have introduced a new Derived Column transformation component, a powerful replacement of the standard Derived Column transformation with support of expressions in JavaScript. The COZYROC REST framework has been further improved with support for GraphQL and OData APIs.

The COZYROC Team

Summary of the products available immediately for purchase:

  • SSIS+ Ultimate Subscription at $1199/Year.
  • SSIS+ 2.2 perpetual license at $7,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 Visual Studio 2022.
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.