COZYROC SSIS+ 2.0 now officially released

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

Click here to download the COZYROC SSIS+ 2.0 Suite

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.
Agile CRM Connection
  • New: Introduced connection.
Airtable Connection
  • New: Introduced connection.
Amazon DynamoDB Connection
  • New: Introduced connection.
Amazon Selling Partner Connection
  • New: Introduced connection.
Amazon Simple Queue Service Connection
  • New: Introduced connection.
ASN.1 Source
  • New: Introduced component.
Azure Blob Storage Connection
  • New: Introduced connection.
Azure Files Connection
  • New: Introduced connection.
Azure Queue Storage Connection
  • New: Introduced connection.
Blackbaud Connection
  • New: Defined 'School | Student Schedule' resource.
Box Connection
  • New: Introduced connection.
Canvas LMS Connection
  • New: Introduced connection.
ClickUp Connection
  • New: Introduced connection.
Database Source
  • New: Introduced component.
Derived Column
  • New: Introduced component.
Distributed Cache Connection
  • Removed: Retire the connection manager as Windows AppFabric is no longer supported.
EDI Destination
  • New: Support for data streaming.
EDI Source
  • New: Support for stream input.
Expensify Connection
  • New: Introduced connection.
Facebook Business Connection
  • New: Introduced connection.
FHIR Connection
  • New: Introduced connection.
Freshsales Connection
  • New: Introduced connection.
Google Analytics Connection
  • New: Support for Google Analytics Data API (GA4).
  • New: Support for Google Analytics Admin API.
Google AppSheet Connection
  • New: Introduced connection.
Google Cloud Monitoring Connection
  • New: Introduced connection.
Google Dataplex Connection
  • New: Introduced connection.
Google Forms Connection
  • New: Introduced connection.
Google Search Console Connection
  • New: Introduced connection.
Gravity Forms Connection
  • New: Introduced connection.
Jira Connection
  • New: Support for OAuth2 authentication.
JSON Source
  • New: Support for stream input.
Klaviyo Connection
  • New: Introduced connection.
KnowBe4 Connection
  • New: Introduced connection.
Message Queue Task Plus
  • New: Support for Kafka's headers.
monday connection
  • Breaking Change: Configuration is now based on new GraphQL protocol support.
MongoDB Source
  • New: Support reading from views.
NetSuite Connection
  • New: Updated web service proxy to version v2023.1.
  • Deprecated: Session authentication no longer supported.
NetSuite Destination
  • New: A new parameter AsyncProcess for asynchronous processing.
OpenPGP Task
  • New: Support for additional encryption algorithms.
Oracle Cloud Object Storage Connection
  • New: Introduced connection.
Oracle Eloqua Connection
  • New: Introduced connection.
Parature Connection
  • Removed: Service no longer exists.
PrestaShop Connection
  • New: Introduced connection.
Procore Connection
  • New: Introduced connection.
PureCloud Connection
  • New: Support for OAuth authentication.
Qualtrics Connection
  • New: Introduced connection.
REST Connection
  • New: Connection template for GraphQL APIs.
  • New: Connection template for OData APIs.
REST Destination
  • New: Successfully processed rows are now reported in Result output. Only error rows are reported in the Error output.
REST NetSuite Connection
  • New: Introduced connection.
Salesforce CRM Analytics Connection
  • New: Introduced connection.
ServiceTitan Connection
  • New: Introduced connection.
Snowflake Connection
  • New: Introduced connection.
Tableau Destination
  • New: Support for the latest Hyper API package at https://tableau.github.io/hyper-db/docs/releases/# .
  • New: Support for the updating/deleting rows in a .hyper file (using the latest Hyper API)
Tableau Source
  • New: Introduced component.
Wrike Connection
  • New: Introduced connection.
Wunderlist Connection
  • Removed: Service no longer exists.
Zoho Books Connection
  • New: Introduced connection.
Zoho Campaigns Connection
  • New: Introduced connection.
Zoho Desk Connection
  • New: Introduced connection.