COZYROC SSIS+ Library

If you have a previous version of the library installed, please uninstall it before installing the newer version.

Summary

COZYROC is the leading company providing an advanced Microsoft SQL Server 2005-2017 Integration Services (SSIS) library of custom tasks, components and scripts. Our library of components makes you more productive by cutting your development time. COZYROC SSIS+ library has been successfully deployed in more than 140 countries around the world. Check below some of the unique features not found in any other product on the market.

  • Powerful REST adapters for connection to cloud applications
  • Connectivity for Salesforce, SharePoint, Dynamics CRM, AX, NAV, GP, Sage, QuickBooks, NetSuite, OpenAir, SugarCRM, Amazon S3, ArcGIS, Dropbox, Fleet Complete, Hubspot, Marketo, OneDrive, Parature, Pardot, ServiceNow, Shopify, SimplyDigi, Square, Twitter, Xero, Zoho CRM
  • Secure file transfer protocol (SFTP, FTPS)
  • Reusable SSIS scripts
  • Reusable dynamic data flows
  • Concurrent loop execution
  • Zip, GZip, BZip2, Tar compression and decompression
  • Public-Private key encryption
  • Bulk-load support for all major databases
  • EDI format files processing
  • Generation of arbitrary text documents
  • US Postal Address verification and correction
  • Secure advanced email support (SMTP, IMAP, POP3, Exchange)
  • 64bit Microsoft Excel adapters

Do you create custom solutions for clients? If so, do you want to know about COZYROC’s special terms for you? Do you have ideas about SSIS and data warehousing components? We would love to hear from you about your ideas for enhancements and additional components.


Compatibility

SQL ServerVisual StudioCOZYROC SSIS+
201720171.8
20151.8
201620171.8
20151.8, 1.7
201420171.8
20151.8, 1.7, 1.6
20131.8, 1.7, 1.6
20121.8, 1.7, 1.6
201220171.8
20151.8, 1.7, 1.6
20121.8, 1.7, 1.6
20101.8, 1.7, 1.6
200820081.8, 1.7, 1.6, 1.5, 1.4, 1.3
200520051.8, 1.7, 1.6, 1.5, 1.4, 1.3

COZYROC Excel Add-in for SAS®

The COZYROC Excel Add-In for SAS® is designed to allow for the easy movement of SAS® data to and from an Excel worksheet. The Addin allows for the loading and saving of SAS® datasets. Here are the highlights of the product:

  • No SAS® software is required for the product.
  • Loads and saves SAS® datasets.
  • Supports Microsoft Excel 2003, 2007, 2010.
  • Supports Windows XP, Vista, 7, 8.
  • Supports SAS7BDAT files.
  • Designed for smaller datasets (under 100k observations).

COZYROC SSIS+ Library Details

    Data Cleansing

  • Learn More
    • US Postal Address parsing, correction and standardization.
    • Introduced November, 2009 in 1.4 version.
    • Parsed address parts: leading, street, number, suite, city, state, zip code.
    • Optional feature to check address in USPS reference database with more than 120 million addresses.
    • Intuitive user interface with fine-grained error control.


    GIS

  • Learn More
    • Bidirectional integration with ESRI ArcGIS Feature service.
    • Introduced January, 2017 in 1.7 version.
    • Support OAuth2 token and anonymous authentication.
    • Implemented as configuration for the powerful COZYROC REST framework.
    • Intuitive support for composite objects (points, paths, rings, curvePaths, curveRings).

    Collaboration

  • Learn More
    • Bidirectional integration with Asana service.
    • Introduced December, 2017 in 1.8 version.
    • Implemented as configuration for the powerful COZYROC REST framework.
    • Intuitive support for composite objects (tasks, sections, members, etc).
  • Learn More
    • Bidirectional integration with Basecamp service.
    • Introduced December, 2017 in 1.8 version.
    • Implemented as configuration for the powerful COZYROC REST framework.
    • Intuitive support for composite objects (lines, dock, participants).
  • Learn More
    • Bidirectional integration with Google Calendar service.
    • Introduced January, 2017 in 1.7 version.
    • Implemented as configuration for the powerful COZYROC REST framework.
    • Intuitive support for composite objects (attachments, attendees, etc).
  • Learn More
    • Bidirectional integration with GoToWebinar service.
    • Introduced December, 2017 in 1.8 version.
    • Implemented as configuration for the powerful COZYROC REST framework.
    • Intuitive support for composite objects (times, attendance, answers, polls, etc).
  • Learn More
    • Bidirectional integration with JIRA service.
    • Introduced December, 2017 in 1.8 version.
    • Support Basic and OAuth token authentication.
    • Implemented as configuration for the powerful COZYROC REST framework.
    • Intuitive support for composite objects (notifications, associatedItems, transitions, histories, comments, etc).
  • Learn More
    • Bidirectional integration with Parature service.
    • Introduced January, 2017 in 1.7 version.
    • Implemented as configuration for the powerful COZYROC REST framework.
  • Learn More
    • Bidirectional adapters for SharePoint integration.
    • Introduced August, 2010 in 1.5 version.
    • Uses standard SharePoint SOAP web services.
    • Support Office 365, Premise deployments.
    • Support SharePoint 2013, 2010, 2007.
  • Learn More
    • Bidirectional integration with Smartsheet service.
    • Introduced December, 2017 in 1.8 version.
    • Implemented as configuration for the powerful COZYROC REST framework.
  • Learn More
    • Bidirectional integration with SurveyMonkey service.
    • Introduced December, 2017 in 1.8 version.
    • Implemented as configuration for the powerful COZYROC REST framework.
    • Intuitive support for composite objects (rows, cols, choices, questions, pages, etc).
  • Learn More
    • Bidirectional integration with Trello service.
    • Introduced December, 2017 in 1.8 version.
    • Implemented as configuration for the powerful COZYROC REST framework.
    • Intuitive support for composite objects (checkItems, actions, boardStars, cards, members, etc).
  • Learn More
    • Bidirectional integration with Zendesk service.
    • Introduced December, 2017 in 1.8 version.
    • Implemented as configuration for the powerful COZYROC REST framework.
    • Intuitive support for composite objects (thumbnails, attachments, events, variants, etc).

    Marketing

  • Learn More
    • Bidirectional integration with Constant Contact service.
    • Introduced December, 2017 in 1.8 version.
    • Implemented as configuration for the powerful COZYROC REST framework.
    • Intuitive support for composite objects (attributes, addresses, activity, schedules, etc).
  • Learn More
    • Bidirectional integration with HubSpot service.
    • Introduced January, 2017 in 1.7 version.
    • Implemented as configuration for the powerful COZYROC REST framework.
    • Support for file management thru COZYROC File Transfer Task.
  • Learn More
    • Bidirectional integration with Mailchimp service.
    • Introduced December, 2017 in 1.8 version.
    • Implemented as configuration for the powerful COZYROC REST framework.
    • Intuitive support for composite objects (lines, variants, queue, etc).
  • Learn More
    • Bidirectional integration with Marketo service.
    • Introduced January, 2017 in 1.7 version.
    • Implemented as configuration for the powerful COZYROC REST framework.
    • Support for file management thru COZYROC File Transfer Task.
  • Learn More
    • Bidirectional integration with Pardot service.
    • Introduced January, 2017 in 1.7 version.
    • Implemented as configuration for the powerful COZYROC REST framework.
    • Intuitive support for composite objects (visitor, visitor_activity, list_subscription).

    Automation

  • Learn More
    • Extension of Microsoft SSIS Data Flow Task with support for dynamic data flows at runtime.
    • Greater reusability and easier maintenance of data flows.
    • Customizable user interface for data flows setup.
    • SSIS data flows export, import or linking to.
    • Keep your data flows implementation separate from your package and have easier time tracking changes in your source control system.
    • Make Data Flow Task Plus interoperate with other data flows by using Data Flow Source and Data Flow Destination components.
  • Learn More
    • Very fast reader of EDI format files. The component can reportedly process millions of segments in less than 30 minutes.
    • Introduced July, 2008 in 1.3 version.
    • EDI mapping setup is made in XML configuration file.
    • User interface is based on the standard data flow source component dialog.
  • Learn More
    • Makes two or more data flows run with same speed.
    • Introduced December, 2009 in 1.4 SR-1 version.
    • Intuitive user interface.
  • Learn More
    • Support multiple lookup definitions in one place.
    • Introduced November, 2009 in 1.4 version.
    • Support OLEDB, ADO, ADO.NET or package variable as a source.
    • Support Distributed Cache 1.5 SR-1.
    • Support definition for handling NULL and No Match situations.
    • Intuitive user interface.
  • Learn More
    • Improves loop execution time dramatically by executing multiple Foreach loop iterations concurrently.
    • Introduced August, 2010 in 1.5 version.
    • Based on Package Connection Manager.
    • Support both dynamic variables and dynamic connection managers.
    • Streamlined user interface.
  • Learn More
    • Data flow transformation for querying one or more database records based on current input row keys.
    • Introduced January, 2013 in 1.6 SR-1 version.
    • Support OLEDB, ADO, ADO.NET connection types.
    • Support query statement setup from current data flow row.
    • Intuitive user interface.
  • Learn More
    • Powerful framework for integration with any possible REST service.
    • Introduced July, 2016 in 1.7 version.
    • Connectivity and REST resource utilization is implemented thru specially crafted configuration file, a combination of XML schema and JavaScript code.
    • Intuitive support for composite objects.
    • Optional access to any .NET class for additional functionality.
  • Learn More
    • Extension of Microsoft SSIS Script Component, meaning you already have the skills to use it.
    • Introduced November, 2009 in 1.4 version.
    • Greater reusability and easier maintenance of SSIS scripts.
    • Customizable script user interface and setup.
    • SSIS Script export, import or linking to.
    • Keep your script code separate from your package and have easier time tracking changes in your source control system.
    • Requires SQL Server 2005 SP2 or later.
    • Reusable scripts and samples from the public repository.
  • Learn More
    • Extension of Microsoft SSIS Script Task, meaning you already have the skills to use it.
    • Greater reusability and easier maintenance of SSIS scripts.
    • Customizable script user interface and setup.
    • SSIS Script export, import or linking to.
    • Keep your script code separate from your package and have easier time tracking changes in your source control system.
    • Requires SQL Server 2005 SP2 or later.
    • Reusable scripts and samples from the public repository.
  • Learn More
  • Learn More
    • Support creation of stream, opening of file stream, reading from stream and writing to stream.
    • Introduced July, 2008 in 1.3 version.
    • Support in-memory transfer stream, allowing simultaneous writing of data in one process and reading of the same data in another process.
    • Streamlined user interface.
  • Learn More
    • Memory efficient detection of differences between two tables.
    • Introduced December, 2009 in 1.4 SR-1 version.
    • Faster alternative of the standard SCD component.
    • Intuitive user interface.
  • Learn More
    • Generation on arbitrary text columns based on Apache Velocity template.
    • Introduced July, 2012 in 1.6 version.
    • Support multiple template column definitions.
    • Intuitive user interface.
  • Learn More
    • Generation of arbitrary text documents like CSV, HTML, XML, EDI and many more.
    • Introduced November, 2009 in 1.4 version.
    • Streaming document generation, meaning low memory requirements and unlimited document generation.
    • Template engine based on Apache Velocity.
    • User interface includes syntax-highlighting editor and template-testing tools.
  • Learn More
    • Compression and decompression of Zip, GZip, BZip2, Unix, Tar archives.
    • Introduced July, 2007 in 1.1 version.
    • Automatically switches to Zip64 format, if it is required.
    • Support for input and output data streaming, without a need for temporary storage.
    • Support extraction from multi-volume Zip archive (1.3 SR-3).
    • Support AES encryption and decryption (1.5 SR-2).
    • Streamlined user interface.

    Database

  • Learn More
    • Saves you time by handling the intricacies of the partitioning and letting you concentrate on your workflow instead.
    • Create, insert and remove database partitions in Microsoft SQL Server 2005 and up.
    • Combine smaller partitions into a larger one, for easy backup later.
    • Support for ADO.NET, OLEDB, ADO connection managers.
    • Easy to use interface.
  • Learn More
    • Bulk-load destination DB2 table component.
    • Introduced June, 2008 in 1.3 version.
    • 20x faster loading speed compared to OLE DB.
    • IBM UniData® and UniVerse® data servers are not supported.
    • User interface is based on the standard data flow destination component dialog.
  • Learn More
    • Bulk-load destination Informix table component.
    • Introduced June, 2008 in 1.3 version.
    • 6-8x faster loading speed compared to OLE DB.
    • Support for IBM Informix® Dynamic Server, Version 11.10 or later.
    • User interface is based on the standard data flow destination component dialog.
  • Learn More
    • Support regular and bulk ODBC insertion.
    • Introduced November, 2009 in 1.4 version.
    • Based on ODBC Connection Manager.
    • Support 32bit and 64bit ODBC drivers.
    • Support redirection of incorrect rows to error output.
    • User interface is based on the standard data flow destination component dialog.
  • Learn More
    • Bulk-load destination Oracle table component.
    • Introduced June, 2008 in 1.3 version.
    • 10-30x faster loading speed compared to OLE DB.
    • Support for Oracle 9i release 2, 10g release 1, 10g release 2, and 11g release 1 databases.
    • User interface is based on the standard data flow destination component dialog.
  • Learn More
    • Bulk-load destination Sybase table component.
    • Introduced January, 2013 in 1.6 SR-1 version.
    • 20x faster loading speed compared to OLE DB.
    • Requires Adaptive Server Enterprise version 15.7.
    • User interface is based on the standard data flow destination component dialog.
  • Learn More

    ERP

  • Learn More
    • Bidirectional adapters for Dynamics AX integration.
    • Introduced October, 2010 in 1.5 SR-1 version.
    • Based on Microsoft .NET Business Connector for Dynamics AX.
  • Learn More
    • Bidirectional adapters for Dynamics GP integration.
    • Introduced July, 2012 in 1.6 version.
    • Uses the standard Microsoft Dynamics GP web services API.
    • Intuitive support for composite objects.
  • Learn More
    • Bidirectional adapters for NetSuite integration.
    • Introduced July, 2012 in 1.6 version.
    • Support automatic renewal of expired sessions during processing.
    • Intuitive support for composite objects.

    CRM

  • Learn More
    • Bidirectional adapters for Microsoft Dynamics 365/CRM integration.
    • Introduced August, 2010 in 1.5 version.
    • Uses only standard Dynamics CRM SOAP web services API.
    • Unique reusable script technology for complimentary functionality and flexibility.
    • Support Office 365, Premise, Live, Hosted deployments.
    • Support 2016, 2015, 2013, 2011, 4.0 and 3.0 systems.
  • Learn More
    • Bidirectional adapters for Sage / SalesLogix integration.
    • Introduced July, 2012 in 1.6 version.
    • Based on the standard Sage SData SOAP web services API.
    • Intuitive support for composite objects.
  • Learn More
    • Bidirectional adapters for Salesforce integration.
    • Introduced November, 2009 in 1.4 version.
    • Unique reusable script technology for complimentary functionality and flexibility.
    • Support both regular SOAP and bulk REST API.
  • Learn More
    • Bidirectional adapters for SugarCRM integration.
    • Introduced July, 2012 in 1.6 version.
    • Uses the standard SugarCRM SOAP web services API.
  • Learn More
    • Bidirectional integration with Zoho CRM service.
    • Introduced January, 2017 in 1.7 version.
    • Implemented as configuration for the powerful COZYROC REST framework.

    Productivity

  • Learn More
    • Bidirectional adapters for Microsoft Excel integration.
    • Introduced August, 2010 in 1.5 version.
    • Support Microsoft Excel 97-2010 and Pocket Excel workbook files.
    • Support 32 and 64 bit execution.
    • Support password-protected workbooks.
    • No need to install any other component or Microsoft frameworks.
  • Learn More
    • Bidirectional integration with Google Sheets service.
    • Introduced January, 2017 in 1.7 version.
    • Implemented as configuration for the powerful COZYROC REST framework.
    • Intuitive support for composite objects.
  • Learn More
    • Bidirectional integration with Google Tasks service.
    • Introduced January, 2017 in 1.7 version.
    • Implemented as configuration for the powerful COZYROC REST framework.
  • Learn More
    • Bidirectional integration with Wunderlist service.
    • Introduced December, 2017 in 1.8 version.
    • Implemented as configuration for the powerful COZYROC REST framework.

    Transportation

  • Learn More
    • Bidirectional integration with Fleet Complete service.
    • Introduced January, 2017 in 1.7 version.
    • Implemented as configuration for the powerful COZYROC REST framework.
    • Intuitive support for composite objects (Sensors, Rules, Trip, GeoData, Routes, etc).

    Accounting

  • Learn More
    • Bidirectional integration with FreshBooks service.
    • Introduced December, 2017 in 1.8 version.
    • Implemented as configuration for the powerful COZYROC REST framework.
    • Intuitive support for composite objects (professions, addresses, groups, business_memberships, etc).
  • Learn More
    • Bidirectional adapters for QuickBooks integration.
    • Introduced July, 2012 in 1.6 version.
    • Support both QuickBooks Desktop and QuickBooks Online.
    • Intuitive support for composite objects.
  • Learn More
    • Bidirectional integration with Xero service.
    • Introduced January, 2017 in 1.7 version.
    • Implemented as configuration for the powerful COZYROC REST framework.
    • Intuitive support for composite objects (LineItems, ContactPersons, Addresses, Allocations, etc).

    Administration

  • Learn More
    • Bidirectional integration with Google Admin service.
    • Introduced January, 2017 in 1.7 version.
    • Implemented as configuration for the powerful COZYROC REST framework.
    • Intuitive support for composite objects (domainAliases, applications, addresses, ims, etc).
  • Learn More
    • Bidirectional adapters for LDAP / Active Directory integration.
    • Introduced December, 2017 in 1.8 version.
    • Available on the market since December, 2017.
    • Support processing of all available LDAP objects.
  • Learn More
    • Bidirectional integration with ServiceNow service.
    • Introduced January, 2017 in 1.7 version.
    • Implemented as configuration for the powerful COZYROC REST framework.
    • Support reading from both tables and views.

    Analytics

  • Learn More
  • Learn More
    • Bidirectional integration with Google BigQuery service.
    • Introduced December, 2017 in 1.8 version.
    • Implemented as configuration for the powerful COZYROC REST framework.
  • Learn More
    • Support reading and writing of QlikView QVX files.
    • Introduced July, 2016 in 1.7 version.
    • No dependence on any other third-party technology or component.
  • Learn More
    • Support reading and writing of SAS sas7bdat files.
    • Introduced May, 2011 in 1.5 SR-2 version.
    • No dependence on any other third-party technology or component.
  • Learn More
    • Creation of Tableau Data Extract (TDE) files.
    • Introduced September, 2014 in 1.6 SR-3 version.
    • Requires deployment of Data Extract API.
    • User interface is based on the standard data flow destination component dialog.

    HR

  • Learn More
    • Bidirectional integration with Humanity service.
    • Introduced December, 2017 in 1.8 version.
    • Implemented as configuration for the powerful COZYROC REST framework.
    • Intuitive support for composite objects (staff, events, employees, traders, etc).
  • Learn More
    • Bidirectional adapters for OpenAir integration.
    • Introduced July, 2012 in 1.6 version.
    • Based on standard OpenAir SOAP web services API.


    Commerce

  • Learn More
    • Bidirectional integration with Magento service.
    • Introduced December, 2017 in 1.8 version.
    • Implemented as configuration for the powerful COZYROC REST framework.
    • Intuitive support for composite objects (addresses, items, total_segments, etc).
  • Learn More
    • Bidirectional integration with Shopify service.
    • Introduced January, 2017 in 1.7 version.
    • Implemented as configuration for the powerful COZYROC REST framework.
    • Intuitive support for composite objects (line_items, addresses, fulfillments, etc).
  • Learn More
    • Bidirectional integration with Square service.
    • Introduced January, 2017 in 1.7 version.
    • Implemented as configuration for the powerful COZYROC REST framework.
    • Intuitive support for composite objects (tenders, refunds, cards).
  • Learn More
    • Bidirectional integration with Zuora service.
    • Introduced December, 2017 in 1.8 version.
    • Implemented as configuration for the powerful COZYROC REST framework.
    • Intuitive support for composite objects (productRatePlanCharges, subscribeToRatePlans, productRatePlans, taxItems, etc).

    Security

  • Learn More
    • Support for file encryption, decryption, signature creation and verification.
    • Introduced June, 2008 in 1.3 version.
    • Public key cryptography based on OpenPGP standard.
    • Support for input and output data streaming, without a need for temporary storage.
    • Streamlined user interface.

    Education

  • Learn More
    • Bidirectional integration with SimplyDigi service.
    • Introduced January, 2017 in 1.7 version.
    • Implemented as configuration for the powerful COZYROC REST framework.


  • Learn More
    • US Postal Address parsing, correction and standardization.
    • Introduced November, 2009 in 1.4 version.
    • Parsed address parts: leading, street, number, suite, city, state, zip code.
    • Optional feature to check address in USPS reference database with more than 120 million addresses.
    • Intuitive user interface with fine-grained error control.
  • Learn More
  • Learn More
    • Based on Amazon S3 Connection Manager.
    • Support file sending, receiving, removing and retrieval of remote files list.
    • Support for input and output data streaming, without a need for temporary storage.
    • Streamlined user interface.
  • Learn More
    • Bidirectional integration with ESRI ArcGIS Feature service.
    • Introduced January, 2017 in 1.7 version.
    • Support OAuth2 token and anonymous authentication.
    • Implemented as configuration for the powerful COZYROC REST framework.
    • Intuitive support for composite objects (points, paths, rings, curvePaths, curveRings).
  • Learn More
    • Bidirectional integration with Asana service.
    • Introduced December, 2017 in 1.8 version.
    • Implemented as configuration for the powerful COZYROC REST framework.
    • Intuitive support for composite objects (tasks, sections, members, etc).
  • Learn More
    • Bidirectional integration with Basecamp service.
    • Introduced December, 2017 in 1.8 version.
    • Implemented as configuration for the powerful COZYROC REST framework.
    • Intuitive support for composite objects (lines, dock, participants).
  • Learn More
    • Bidirectional integration with Constant Contact service.
    • Introduced December, 2017 in 1.8 version.
    • Implemented as configuration for the powerful COZYROC REST framework.
    • Intuitive support for composite objects (attributes, addresses, activity, schedules, etc).
  • Learn More
    • Exposes data from a data flow for in-memory read in another data flow.
    • Scalable alternative of the recommended Microsoft solution with raw data file destination.
    • User interface is based on the standard data flow destination component dialog.
  • Learn More
    • Based on Package Connection Manager.
    • Very fast, non-blocking, in-memory data read from another data flow.
    • Scalable alternative of the recommended Microsoft solution with raw data file source.
    • User interface is based on the standard data flow source component dialog.
    • Check for yourself the performance by downloading this SSIS package.
  • Learn More
    • Extension of Microsoft SSIS Data Flow Task with support for dynamic data flows at runtime.
    • Greater reusability and easier maintenance of data flows.
    • Customizable user interface for data flows setup.
    • SSIS data flows export, import or linking to.
    • Keep your data flows implementation separate from your package and have easier time tracking changes in your source control system.
    • Make Data Flow Task Plus interoperate with other data flows by using Data Flow Source and Data Flow Destination components.
  • Learn More
    • Saves you time by handling the intricacies of the partitioning and letting you concentrate on your workflow instead.
    • Create, insert and remove database partitions in Microsoft SQL Server 2005 and up.
    • Combine smaller partitions into a larger one, for easy backup later.
    • Support for ADO.NET, OLEDB, ADO connection managers.
    • Easy to use interface.
  • Learn More
    • Bulk-load destination DB2 table component.
    • Introduced June, 2008 in 1.3 version.
    • 20x faster loading speed compared to OLE DB.
    • IBM UniData® and UniVerse® data servers are not supported.
    • User interface is based on the standard data flow destination component dialog.
  • Learn More
  • Learn More
    • Support for Dropbox service file management thru COZYROC File Transfer Task.
    • Introduced January, 2017 in 1.7 version.
    • Implemented as configuration for the powerful COZYROC REST framework.
  • Learn More
    • Bidirectional adapters for Dynamics AX integration.
    • Introduced October, 2010 in 1.5 SR-1 version.
    • Based on Microsoft .NET Business Connector for Dynamics AX.
  • Learn More
    • Connections with Microsoft Dynamics AX server.
    • Support Dynamics AX 2012, 2009, 4.0 systems.
    • Streamlined user interface.
  • Learn More
  • Learn More
  • Learn More
    • Bidirectional adapters for Microsoft Dynamics 365/CRM integration.
    • Introduced August, 2010 in 1.5 version.
    • Uses only standard Dynamics CRM SOAP web services API.
    • Unique reusable script technology for complimentary functionality and flexibility.
    • Support Office 365, Premise, Live, Hosted deployments.
    • Support 2016, 2015, 2013, 2011, 4.0 and 3.0 systems.
  • Learn More
    • Connections with Microsoft Dynamics CRM service.
    • Support Office 365, Premise, Live, Hosted deployments.
    • Support Dynamics CRM 3 - 2016 systems.
    • Streamlined user interface.
  • Learn More
  • Learn More
  • Learn More
    • Bidirectional adapters for Dynamics GP integration.
    • Introduced July, 2012 in 1.6 version.
    • Uses the standard Microsoft Dynamics GP web services API.
    • Intuitive support for composite objects.
  • Learn More
    • Connections with Dynamics GP web service.
    • Streamlined user interface.
  • Learn More
  • Learn More
  • Learn More
    • Very fast reader of EDI format files. The component can reportedly process millions of segments in less than 30 minutes.
    • Introduced July, 2008 in 1.3 version.
    • EDI mapping setup is made in XML configuration file.
    • User interface is based on the standard data flow source component dialog.
  • Learn More
    • Bidirectional adapters for Microsoft Excel integration.
    • Introduced August, 2010 in 1.5 version.
    • Support Microsoft Excel 97-2010 and Pocket Excel workbook files.
    • Support 32 and 64 bit execution.
    • Support password-protected workbooks.
    • No need to install any other component or Microsoft frameworks.
  • Learn More
    • Connections to Microsoft Excel workbook files.
    • Support 64 bit execution.
    • Support Microsoft Excel 97-2010 and Pocket Excel workbook files.
    • Support password-protected workbooks.
    • Streamlined user interface.
  • Learn More
  • Learn More
    • Based on Excel Connection Manager.
    • Support 64 bit execution.
    • Support reading of raw, formatted and formula cell value.
    • Intuitive user interface with fine-grained error control.
  • Learn More
    • Based on Excel Connection Manager.
    • Support 64 bit execution.
    • Support creating, deleting, clearing and renaming of worksheets.
    • Support find and replace of cells in Excel worksheets.
    • Streamlined user interface.
  • Learn More
    • Connections with Exchange web service.
    • Support Exchange 2010 and above.
    • Support for mail send and receive.
    • Streamlined user interface.
  • Learn More
  • Learn More
    • Bidirectional integration with Fleet Complete service.
    • Introduced January, 2017 in 1.7 version.
    • Implemented as configuration for the powerful COZYROC REST framework.
    • Intuitive support for composite objects (Sensors, Rules, Trip, GeoData, Routes, etc).
  • Learn More
    • Makes two or more data flows run with same speed.
    • Introduced December, 2009 in 1.4 SR-1 version.
    • Intuitive user interface.
  • Learn More
    • Bidirectional integration with FreshBooks service.
    • Introduced December, 2017 in 1.8 version.
    • Implemented as configuration for the powerful COZYROC REST framework.
    • Intuitive support for composite objects (professions, addresses, groups, business_memberships, etc).
  • Learn More
    • Secure connections with FTP over SSL server.
    • Secure connections with FTP over TLS server.
    • Connections with straight FTP server.
    • Support for Explicit and Implicit FTPS.
    • Support for OTP S/Key password protection.
    • Support for SOCKS4, SOCKS5, HTTP, FTP proxy.
    • Streamlined user interface.
  • Learn More
    • Bidirectional integration with Google Admin service.
    • Introduced January, 2017 in 1.7 version.
    • Implemented as configuration for the powerful COZYROC REST framework.
    • Intuitive support for composite objects (domainAliases, applications, addresses, ims, etc).
  • Learn More
  • Learn More
    • Bidirectional integration with Google BigQuery service.
    • Introduced December, 2017 in 1.8 version.
    • Implemented as configuration for the powerful COZYROC REST framework.
  • Learn More
    • Bidirectional integration with Google Calendar service.
    • Introduced January, 2017 in 1.7 version.
    • Implemented as configuration for the powerful COZYROC REST framework.
    • Intuitive support for composite objects (attachments, attendees, etc).
  • Learn More
    • Support for Google Drive service file management thru COZYROC File Transfer Task.
    • Introduced January, 2017 in 1.7 version.
    • Implemented as configuration for the powerful COZYROC REST framework.
  • Learn More
    • Bidirectional integration with Google Sheets service.
    • Introduced January, 2017 in 1.7 version.
    • Implemented as configuration for the powerful COZYROC REST framework.
    • Intuitive support for composite objects.
  • Learn More
    • Bidirectional integration with Google Tasks service.
    • Introduced January, 2017 in 1.7 version.
    • Implemented as configuration for the powerful COZYROC REST framework.
  • Learn More
    • Bidirectional integration with GoToWebinar service.
    • Introduced December, 2017 in 1.8 version.
    • Implemented as configuration for the powerful COZYROC REST framework.
    • Intuitive support for composite objects (times, attendance, answers, polls, etc).
  • Learn More
    • Bidirectional integration with HubSpot service.
    • Introduced January, 2017 in 1.7 version.
    • Implemented as configuration for the powerful COZYROC REST framework.
    • Support for file management thru COZYROC File Transfer Task.
  • Learn More
    • Bidirectional integration with Humanity service.
    • Introduced December, 2017 in 1.8 version.
    • Implemented as configuration for the powerful COZYROC REST framework.
    • Intuitive support for composite objects (staff, events, employees, traders, etc).
  • Learn More
    • Connections with IMAP mail server.
    • Support secure connections.
    • Streamlined user interface.
  • Learn More
    • Bulk-load destination Informix table component.
    • Introduced June, 2008 in 1.3 version.
    • 6-8x faster loading speed compared to OLE DB.
    • Support for IBM Informix® Dynamic Server, Version 11.10 or later.
    • User interface is based on the standard data flow destination component dialog.
  • Learn More
    • Connections with Jabber servers.
    • Support socket, HTTP polling and HTTP binding connection types.
    • Support for SOCKS4, SOCKS5, HTTP proxy.
    • Streamlined user interface.
  • Learn More
    • Bidirectional communication with Jabber clients - sending and receiving of messages.
    • Introduced July, 2008 in 1.3 version.
    • Based on Jabber Connection Manager.
    • Support text or HTML message sending.
    • Streamlined user interface.
  • Learn More
    • Bidirectional integration with JIRA service.
    • Introduced December, 2017 in 1.8 version.
    • Support Basic and OAuth token authentication.
    • Implemented as configuration for the powerful COZYROC REST framework.
    • Intuitive support for composite objects (notifications, associatedItems, transitions, histories, comments, etc).
  • Learn More
    • Bidirectional adapters for LDAP / Active Directory integration.
    • Introduced December, 2017 in 1.8 version.
    • Available on the market since December, 2017.
    • Support processing of all available LDAP objects.
  • Learn More
    • Connections with LDAP service.
    • Streamlined user interface.
  • Learn More
  • Learn More
  • Learn More
    • Support multiple lookup definitions in one place.
    • Introduced November, 2009 in 1.4 version.
    • Support OLEDB, ADO, ADO.NET or package variable as a source.
    • Support Distributed Cache 1.5 SR-1.
    • Support definition for handling NULL and No Match situations.
    • Intuitive user interface.
  • Learn More
    • Bidirectional integration with Magento service.
    • Introduced December, 2017 in 1.8 version.
    • Implemented as configuration for the powerful COZYROC REST framework.
    • Intuitive support for composite objects (addresses, items, total_segments, etc).
  • Learn More
    • Bidirectional integration with Mailchimp service.
    • Introduced December, 2017 in 1.8 version.
    • Implemented as configuration for the powerful COZYROC REST framework.
    • Intuitive support for composite objects (lines, variants, queue, etc).
  • Learn More
    • Bidirectional integration with Marketo service.
    • Introduced January, 2017 in 1.7 version.
    • Implemented as configuration for the powerful COZYROC REST framework.
    • Support for file management thru COZYROC File Transfer Task.
  • Learn More
    • Bidirectional adapters for NetSuite integration.
    • Introduced July, 2012 in 1.6 version.
    • Support automatic renewal of expired sessions during processing.
    • Intuitive support for composite objects.
  • Learn More
    • Connections with NetSuite web service.
    • Streamlined user interface.
  • Learn More
  • Learn More
  • Learn More
    • Support regular and bulk ODBC insertion.
    • Introduced November, 2009 in 1.4 version.
    • Based on ODBC Connection Manager.
    • Support 32bit and 64bit ODBC drivers.
    • Support redirection of incorrect rows to error output.
    • User interface is based on the standard data flow destination component dialog.
  • Learn More
    • Support for OneDrive service file management thru COZYROC File Transfer Task.
    • Introduced January, 2017 in 1.7 version.
    • Implemented as configuration for the powerful COZYROC REST framework.
  • Learn More
    • Bidirectional adapters for OpenAir integration.
    • Introduced July, 2012 in 1.6 version.
    • Based on standard OpenAir SOAP web services API.
  • Learn More
    • Connections with OpenAir web service.
    • Streamlined user interface.
  • Learn More
  • Learn More
  • Learn More
    • Support for file encryption, decryption, signature creation and verification.
    • Introduced June, 2008 in 1.3 version.
    • Public key cryptography based on OpenPGP standard.
    • Support for input and output data streaming, without a need for temporary storage.
    • Streamlined user interface.
  • Learn More
    • Bulk-load destination Oracle table component.
    • Introduced June, 2008 in 1.3 version.
    • 10-30x faster loading speed compared to OLE DB.
    • Support for Oracle 9i release 2, 10g release 1, 10g release 2, and 11g release 1 databases.
    • User interface is based on the standard data flow destination component dialog.
  • Learn More
    • Get access to the current or different package at runtime.
    • Support for all current types of package storage: SQL, File, SSIS Package Store.
    • Support for package variables initialization before execution.
    • Easy to use interface.
  • Learn More
    • Improves loop execution time dramatically by executing multiple Foreach loop iterations concurrently.
    • Introduced August, 2010 in 1.5 version.
    • Based on Package Connection Manager.
    • Support both dynamic variables and dynamic connection managers.
    • Streamlined user interface.
  • Learn More
    • Bidirectional integration with Parature service.
    • Introduced January, 2017 in 1.7 version.
    • Implemented as configuration for the powerful COZYROC REST framework.
  • Learn More
    • Bidirectional integration with Pardot service.
    • Introduced January, 2017 in 1.7 version.
    • Implemented as configuration for the powerful COZYROC REST framework.
    • Intuitive support for composite objects (visitor, visitor_activity, list_subscription).
  • Learn More
    • Connections with POP3 mail server.
    • Support secure connections.
    • Streamlined user interface.
  • Learn More
    • Support reading and writing of QlikView QVX files.
    • Introduced July, 2016 in 1.7 version.
    • No dependence on any other third-party technology or component.
  • Learn More
    • Creation of QlikView QVX files.
    • User interface is based on the standard data flow destination component dialog.
  • Learn More
    • Read from QlikView QVX files.
    • User interface is based on the standard data flow source component dialog.
  • Learn More
    • Data flow transformation for querying one or more database records based on current input row keys.
    • Introduced January, 2013 in 1.6 SR-1 version.
    • Support OLEDB, ADO, ADO.NET connection types.
    • Support query statement setup from current data flow row.
    • Intuitive user interface.
  • Learn More
    • Bidirectional adapters for QuickBooks integration.
    • Introduced July, 2012 in 1.6 version.
    • Support both QuickBooks Desktop and QuickBooks Online.
    • Intuitive support for composite objects.
  • Learn More
    • Connections with QuickBooks web service.
    • Support for QuickBooks Online.
    • Support for QuickBooks Desktop.
    • Streamlined user interface.
  • Learn More
  • Learn More
  • Learn More
  • Learn More
    • Powerful framework for integration with any possible REST service.
    • Introduced July, 2016 in 1.7 version.
    • Connectivity and REST resource utilization is implemented thru specially crafted configuration file, a combination of XML schema and JavaScript code.
    • Intuitive support for composite objects.
    • Optional access to any .NET class for additional functionality.
  • Learn More
    • Connections with REST web services.
    • Optional support for proxy.
    • Optional retry for particular errors.
    • Streamlined user interface.
  • Learn More
  • Learn More
  • Learn More
    • Bidirectional adapters for Sage / SalesLogix integration.
    • Introduced July, 2012 in 1.6 version.
    • Based on the standard Sage SData SOAP web services API.
    • Intuitive support for composite objects.
  • Learn More
    • Connections with Sage SData web service.
    • Streamlined user interface.
  • Learn More
    • Based on Sage Connection Manager.
    • Store data into Sage entity.
    • Support write of composite Sage entity property.
    • User interface is based on the standard data flow destination component dialog.
  • Learn More
  • Learn More
    • Bidirectional adapters for Salesforce integration.
    • Introduced November, 2009 in 1.4 version.
    • Unique reusable script technology for complimentary functionality and flexibility.
    • Support both regular SOAP and bulk REST API.
  • Learn More
    • Connections with Salesforce service.
    • Streamlined user interface.
  • Learn More
  • Learn More
  • Learn More
    • Support reading and writing of SAS sas7bdat files.
    • Introduced May, 2011 in 1.5 SR-2 version.
    • No dependence on any other third-party technology or component.
  • Learn More
    • Premium component licensed separately from SSIS+ library.
    • Installation and licensing of SAS® Analytics not required.
    • User interface is based on the standard data flow destination component dialog.
  • Learn More
    • Premium component licensed separately from SSIS+ library.
    • Installation and licensing of SAS® Analytics not required.
    • Streaming data read, allowing processing of unlimited amounts of data.
    • User interface is based on the standard data flow source component dialog.
  • Learn More
  • Learn More
    • Extension of Microsoft SSIS Script Component, meaning you already have the skills to use it.
    • Introduced November, 2009 in 1.4 version.
    • Greater reusability and easier maintenance of SSIS scripts.
    • Customizable script user interface and setup.
    • SSIS Script export, import or linking to.
    • Keep your script code separate from your package and have easier time tracking changes in your source control system.
    • Requires SQL Server 2005 SP2 or later.
    • Reusable scripts and samples from the public repository.
  • Learn More
    • Extension of Microsoft SSIS Script Task, meaning you already have the skills to use it.
    • Greater reusability and easier maintenance of SSIS scripts.
    • Customizable script user interface and setup.
    • SSIS Script export, import or linking to.
    • Keep your script code separate from your package and have easier time tracking changes in your source control system.
    • Requires SQL Server 2005 SP2 or later.
    • Reusable scripts and samples from the public repository.
  • Learn More
  • Learn More
    • Bidirectional integration with ServiceNow service.
    • Introduced January, 2017 in 1.7 version.
    • Implemented as configuration for the powerful COZYROC REST framework.
    • Support reading from both tables and views.
  • Learn More
    • Secure FTP communications and management.
    • Deprecated in 1.7 version and replaced by the new COZYROC File Transfer Task.
    • Based on SSH Connection Manager.
    • Based on FTPS Connection Manager 1.3.
    • Support for send, receive and delete files, create and remove directory, rename file commands.
    • Support for input and output data streaming, without a need for temporary storage.
    • The user interface covers most of the functionality of the standard Microsoft SSIS FTP task and it is very similar.
  • Learn More
    • Bidirectional adapters for SharePoint integration.
    • Introduced August, 2010 in 1.5 version.
    • Uses standard SharePoint SOAP web services.
    • Support Office 365, Premise deployments.
    • Support SharePoint 2013, 2010, 2007.
  • Learn More
    • Connections with Microsoft SharePoint service.
    • Streamlined user interface.
  • Learn More
  • Learn More
    • Based on SharePoint Connection Manager.
    • Support batch reading from Microsoft SharePoint list.
    • Support specifying of Microsoft SharePoint list view.
    • Support CAML queries and includes designer for simplifying query creation.
    • User interface is based on the standard data flow source component dialog.
  • Learn More
    • Bidirectional integration with Shopify service.
    • Introduced January, 2017 in 1.7 version.
    • Implemented as configuration for the powerful COZYROC REST framework.
    • Intuitive support for composite objects (line_items, addresses, fulfillments, etc).
  • Learn More
    • Bidirectional integration with SimplyDigi service.
    • Introduced January, 2017 in 1.7 version.
    • Implemented as configuration for the powerful COZYROC REST framework.
  • Learn More
    • Bidirectional integration with Slack service.
    • Introduced December, 2017 in 1.8 version.
    • Implemented as configuration for the powerful COZYROC REST framework.
    • Intuitive support for composite objects (channels, groups, addresses, etc).
  • Learn More
    • Bidirectional integration with Smartsheet service.
    • Introduced December, 2017 in 1.8 version.
    • Implemented as configuration for the powerful COZYROC REST framework.
  • Learn More
    • Connections with SMTP mail server.
    • Support secure connections.
    • Streamlined user interface.
  • Learn More
    • Bidirectional integration with Square service.
    • Introduced January, 2017 in 1.7 version.
    • Implemented as configuration for the powerful COZYROC REST framework.
    • Intuitive support for composite objects (tenders, refunds, cards).
  • Learn More
    • Secure connections with SSH-enabled server.
    • Authenticate with password or private key file.
    • Support for Tunnel (HTTP), SOCKS4, SOCKS5 proxy.
    • Support SSH2.
    • Support File Transfer Protocol version 0, 1, 2, 3.
    • Support for secure tunnels (port forwarding) 1.5.
    • Streamlined user interface.
  • Learn More
  • Learn More
    • Support creation of stream, opening of file stream, reading from stream and writing to stream.
    • Introduced July, 2008 in 1.3 version.
    • Support in-memory transfer stream, allowing simultaneous writing of data in one process and reading of the same data in another process.
    • Streamlined user interface.
  • Learn More
    • Bidirectional adapters for SugarCRM integration.
    • Introduced July, 2012 in 1.6 version.
    • Uses the standard SugarCRM SOAP web services API.
  • Learn More
    • Connections with SugarCRM web service.
    • Streamlined user interface.
  • Learn More
  • Learn More
  • Learn More
    • Bidirectional integration with SurveyMonkey service.
    • Introduced December, 2017 in 1.8 version.
    • Implemented as configuration for the powerful COZYROC REST framework.
    • Intuitive support for composite objects (rows, cols, choices, questions, pages, etc).
  • Learn More
    • Bulk-load destination Sybase table component.
    • Introduced January, 2013 in 1.6 SR-1 version.
    • 20x faster loading speed compared to OLE DB.
    • Requires Adaptive Server Enterprise version 15.7.
    • User interface is based on the standard data flow destination component dialog.
  • Learn More
    • Memory efficient detection of differences between two tables.
    • Introduced December, 2009 in 1.4 SR-1 version.
    • Faster alternative of the standard SCD component.
    • Intuitive user interface.
  • Learn More
    • Creation of Tableau Data Extract (TDE) files.
    • Introduced September, 2014 in 1.6 SR-3 version.
    • Requires deployment of Data Extract API.
    • User interface is based on the standard data flow destination component dialog.
  • Learn More
    • Generation on arbitrary text columns based on Apache Velocity template.
    • Introduced July, 2012 in 1.6 version.
    • Support multiple template column definitions.
    • Intuitive user interface.
  • Learn More
    • Generation of arbitrary text documents like CSV, HTML, XML, EDI and many more.
    • Introduced November, 2009 in 1.4 version.
    • Streaming document generation, meaning low memory requirements and unlimited document generation.
    • Template engine based on Apache Velocity.
    • User interface includes syntax-highlighting editor and template-testing tools.
  • Learn More
  • Learn More
    • Bulk-load destination Teradata table component.
    • 80x faster loading speed compared to ODBC.
    • User interface is based on the standard data flow destination component dialog.
  • Learn More
    • Fast read from Teradata table.
    • User interface is based on the standard data flow source component dialog.
  • Learn More
    • Bidirectional integration with Trello service.
    • Introduced December, 2017 in 1.8 version.
    • Implemented as configuration for the powerful COZYROC REST framework.
    • Intuitive support for composite objects (checkItems, actions, boardStars, cards, members, etc).
  • Learn More
    • Bidirectional integration with Twilio service.
    • Introduced December, 2017 in 1.8 version.
    • Implemented as configuration for the powerful COZYROC REST framework.
  • Learn More
    • Bidirectional integration with Wunderlist service.
    • Introduced December, 2017 in 1.8 version.
    • Implemented as configuration for the powerful COZYROC REST framework.
  • Learn More
    • Bidirectional integration with Xero service.
    • Introduced January, 2017 in 1.7 version.
    • Implemented as configuration for the powerful COZYROC REST framework.
    • Intuitive support for composite objects (LineItems, ContactPersons, Addresses, Allocations, etc).
  • Learn More
    • Bidirectional integration with Zendesk service.
    • Introduced December, 2017 in 1.8 version.
    • Implemented as configuration for the powerful COZYROC REST framework.
    • Intuitive support for composite objects (thumbnails, attachments, events, variants, etc).
  • Learn More
    • Compression and decompression of Zip, GZip, BZip2, Unix, Tar archives.
    • Introduced July, 2007 in 1.1 version.
    • Automatically switches to Zip64 format, if it is required.
    • Support for input and output data streaming, without a need for temporary storage.
    • Support extraction from multi-volume Zip archive (1.3 SR-3).
    • Support AES encryption and decryption (1.5 SR-2).
    • Streamlined user interface.
  • Learn More
    • Bidirectional integration with Zoho CRM service.
    • Introduced January, 2017 in 1.7 version.
    • Implemented as configuration for the powerful COZYROC REST framework.
  • Learn More
    • Bidirectional integration with Zuora service.
    • Introduced December, 2017 in 1.8 version.
    • Implemented as configuration for the powerful COZYROC REST framework.
    • Intuitive support for composite objects (productRatePlanCharges, subscribeToRatePlans, productRatePlans, taxItems, etc).