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.
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.