COZYROC SSIS+ Components Suite
COZYROC SSIS+ is a comprehensive suite of 200+ advanced components for developing ETL solutions with Microsoft SQL Server Integration Services. Our easy-to-use, coding-free library of tasks, components and reusable scripts can significantly cut your development time and also improve the execution speed of your SSIS packages. COZYROC SSIS+ Components Suite has been successfully used by thousands of businesses, in more than 140 countries around the world.
Accounting
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Bidirectional integration with Expensify service.
- Introduced September, 2023 in 2.2 version.
- Implemented as configuration for the powerful COZYROC REST framework.
- 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).
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Bidirectional adapters for QuickBooks Desktop integration.
- Introduced July, 2012 in 1.6 version.
- Intuitive support for composite objects.
- Bidirectional integration with QuickBooks Online service.
- Introduced January, 2022 in 2.1 version.
- Implemented as configuration for the powerful COZYROC REST framework.
- Bidirectional integration with Sage Business Cloud Accounting service.
- Introduced September, 2020 in 2.0 version.
- Implemented as configuration for the powerful COZYROC REST framework.
- Bidirectional integration with Sage Intacct service.
- Introduced May, 2021 in 2.1 version.
- Implemented as configuration for the powerful COZYROC REST framework.
- Support for any available standard and custom object.
- 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).
- Bidirectional integration with Zoho Books service.
- Introduced September, 2023 in 2.2 version.
- Implemented as configuration for the powerful COZYROC REST framework.
Administration
- 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).
- 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.
- 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
- Bidirectional integration with Amazon Athena service.
- Introduced January, 2022 in 2.1 version.
- Implemented as configuration for the powerful COZYROC REST framework.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Bidirectional integration with Elasticsearch service.
- Introduced July, 2020 in 2.0 version.
- Implemented as configuration for the powerful COZYROC REST framework.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Introduced December, 2017 in 1.8 version.
- Implemented as configuration for the powerful COZYROC REST framework.
- Support reading of Google Analytics Reporting service report data.
- Support for Google Analytics Management service.
- Support for Google Analytics Admin API service.
- Bidirectional integration with Google BigQuery service.
- Introduced December, 2017 in 1.8 version.
- Implemented as configuration for the powerful COZYROC REST framework.
- Bidirectional integration with Google Cloud Monitoring service.
- Introduced November, 2023 in 2.2 version.
- Implemented as configuration for the powerful COZYROC REST framework.
- Bidirectional integration with Google Dataplex service.
- Introduced October, 2023 in 2.2 version.
- Implemented as configuration for the powerful COZYROC REST framework.
- Bidirectional integration with Google Search Console service.
- Introduced January, 2024 in 2.2 version.
- Implemented as configuration for the powerful COZYROC REST framework.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Bidirectional integration with Power BI service.
- Introduced April, 2022 in 2.1 version.
- Implemented as configuration for the powerful COZYROC REST framework.
- 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.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Support reading of Salesforce Reports service report data.
- Support for Salesforce Dashboards service.
- Introduced November, 2023 in 2.2 version.
- Implemented as configuration for the powerful COZYROC REST framework.
- 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.
- Bidirectional integration with Sisense.
- Introduced March, 2019 in 1.9 version.
- Implemented as configuration for the powerful COZYROC REST framework.
- Support reading and writing of Tableau Data Extract (TDE) files.
- Support for Tableau Server thru the available REST API.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
Automation
- Bidirectional integration with Microsoft Azure Queue Storage service.
- Introduced November, 2023 in 2.2 version.
- Implemented as configuration for the powerful COZYROC REST framework.
- Connections with AMQP 1.0 servers (version 1.0).
- Support SASL SSL and SASL Plaintext security protocol types.
- Streamlined user interface.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Bidirectional integration with Microsoft Azure Queue Storage service.
- Introduced July, 2023 in 2.2 version.
- Implemented as configuration for the powerful COZYROC REST framework.
- Bidirectional integration with Microsoft Azure Table service.
- Introduced January, 2022 in 2.1 version.
- Implemented as configuration for the powerful COZYROC REST framework.
- Exposes data from a data flow for in-memory read in another data flow.
- Introduced January, 2008 in 1.2 version.
- Scalable alternative of the recommended Microsoft solution with raw data file destination.
- User interface is based on the standard data flow destination component dialog.
- Based on Package Connection Manager.
- Introduced January, 2008 in 1.2 version.
- 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.
- Extension of Microsoft SSIS Data Flow Task with support for dynamic data flows at runtime.
- Introduced January, 2008 in 1.2 version.
- 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.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Expands the features, flexibility and functionality of the built-in Microsoft SSIS Derived Column.
- Flexible JavaScript expressions editing experience within an embedded JavaScript editor.
- Convenient real-time expression evaluator.
- Provides a rich set of predefined JavaScript functions.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Makes two or more data flows run with same speed.
- Introduced December, 2009 in 1.4 SR-1 version.
- Intuitive user interface.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Bidirectional integration with Google People service.
- Introduced January, 2022 in 2.1 version.
- Implemented as configuration for the powerful COZYROC REST framework.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Support for using JavaScript for SSIS scripting (via JavaScript Task and JavaScript Component)
- Prepare easily parameterizable, reusable scripts.
- Convenient script editing experience within an embedded JavaScript editor.
- Seamless upgrades to newer versions of SQL Server
- Reusable scripts and samples (see the "Scripts" tab)
- Introduced November, 2018 in 1.9 version.
- Supports SQL Server 2012 or later
- Connections with Kafka servers (version 0.8 or and newer).
- Support Plaintext, SSL, SASL SSL and SASL Plaintext security protocol types.
- Support for GSSAPI, SCRAM-SHA-256, SCRAM-SHA-512 and OAuth bearer token .
- Streamlined user interface.
- 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.
- Support for sending and receiving of queue messages.
- Introduced May, 2021 in 2.1 version.
- Support for:
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Event-based application integration processing.
- Support for webhooks and the ability to use other trigger APIs.
- Reliable events handling with the use of message queuing technology.
- Scalable, distributed package execution for handling a large number of events.
- "Warm-start" package execution for optimal performance.
- Introduced November, 2019.
- 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.
- Enables execution of a user-specified PowerShell command or script.
- Introduced May, 2021 in 2.1 version.
- Convenient script editing within an embedded PowerShell editor.
- Convenient handling of output streams.
- Supports referencing a script defined in another PowerShell task and calling it with custom parameters.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- 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.
- Connections with RabbitMQ servers (version 1.8.0 or and newer).
- Support SASL SSL and SASL Plaintext security protocol types.
- Support AMQP 0-9-1 messaging protocol.
- Streamlined user interface.
- Powerful framework for integration with any REST service (many pre-built integrations available).
- Connectivity and REST resource utilization is implemented thru specially crafted XML-based configuration file with support of JavaScript code.
- Introduced July, 2016 in 1.7 version.
- Major enhancements in 1.9 version.
- Intuitive support for composite objects.
- Optional access to any .NET class for additional functionality.
- 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.
- 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.
- Capable of handling millions of rows with ease.
- Introduced September, 2018 in 1.9 version.
- Intuitive user interface.
- Secure execution of shell commands on a remote SSH server.
- Introduced August, 2007 in 1.1 version.
- Based on SSH Connection Manager.
- Streamlined user interface.
- 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.
- 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.
- Bidirectional integration with UiPath.
- Introduced January, 2020 in 2.0 version.
- Implemented as configuration for the powerful COZYROC REST framework.
CMS
- 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 2019, 2016, 2013, 2010, 2007.
- Bidirectional integration with a WordPress website.
- Introduced February, 2019 in 1.9 version.
- Implemented as configuration for the powerful COZYROC REST framework.
Collaboration
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- 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).
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Bidirectional integration with Eventbrite service.
- Introduced May, 2021 in 2.1 version.
- Implemented as configuration for the powerful COZYROC REST framework.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- 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).
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- 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).
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Bidirectional integration with Microsoft Graph service.
- Introduced May, 2021 in 2.1 version.
- Implemented as configuration for the powerful COZYROC REST framework.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Important: Parature service has been discontinued.
- Bidirectional integration with Parature service.
- Introduced January, 2017 in 1.7 version.
- Implemented as configuration for the powerful COZYROC REST framework.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Bidirectional integration with ServiceTitan service.
- Introduced July, 2023 in 2.2 version.
- Implemented as configuration for the powerful COZYROC REST framework.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
Commerce
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Bidirectional integration with Amazon Selling Partner service.
- Introduced July, 2023 in 2.2 version.
- Implemented as configuration for the powerful COZYROC REST framework.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Bidirectional integration with BigCommerce service.
- Introduced April, 2022 in 2.1 version.
- Implemented as configuration for the powerful COZYROC REST framework.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Introduced October, 2024 in 2.3 version.
- Bidirectional integration with eBay service.
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- 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).
- Bidirectional integration with Microsoft Dataverse service.
- Introduced May, 2019 in 1.9 version. Then it was named "Microsoft Common Data Service".
- Implemented as configuration for the powerful COZYROC REST framework.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Bidirectional integration with PayPal service.
- Introduced January, 2022 in 2.1 version.
- Implemented as configuration for the powerful COZYROC REST framework.
- Intuitive support for composite objects.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Bidirectional integration with PrestaShop service.
- Introduced October, 2023 in 2.2 version.
- Implemented as configuration for the powerful COZYROC REST framework.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- 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).
- 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).
- Bidirectional integration with Stripe service.
- Introduced January, 2022 in 2.1 version.
- Implemented as configuration for the powerful COZYROC REST framework.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- 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).
Communication
- Bidirectional integration with Aircall service.
- Introduced May, 2021 in 2.1 version.
- Implemented as configuration for the powerful COZYROC REST framework.
- Bidirectional integration with ClickSend service.
- Introduced April, 2020 in 2.0 version.
- Implemented as configuration for the powerful COZYROC REST framework.
- 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.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Bidirectional integration with PureCloud service.
- Introduced January, 2019 in 1.9 version.
- Implemented as configuration for the powerful COZYROC REST framework.
- Support receiving and opening of secure S/MIME emails.
- Introduced August, 2010 in 1.5 version.
- Based on IMAP Connection Manager.
- Based on POP3 Connection Manager.
- Based on Exchange Connection Manager 1.6.
- Support filtering with criteria of received emails.
- Streamlined user interface.
- Support sending of secure S/MIME emails.
- Introduced August, 2010 in 1.5 version.
- Based on SMTP Connection Manager.
- Based on Exchange Connection Manager 1.6.
- Support From, To, CC, BCC, Body, Body HTML, Priority, Attachment parameters.
- Streamlined user interface.
- 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).
- Bidirectional integration with Twilio service.
- Introduced December, 2017 in 1.8 version.
- Implemented as configuration for the powerful COZYROC REST framework.
Construction
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Bidirectional integration with Procore service.
- Introduced August, 2023 in 2.2 version.
- Implemented as configuration for the powerful COZYROC REST framework.
CRM
- Bidirectional integration with Agile CRM service.
- Introduced July, 2023 in 2.2 version.
- Implemented as configuration for the powerful COZYROC REST framework.
- Bidirectional integration with Capsule CRM service.
- Introduced February, 2022 in 2.1 version.
- Implemented as configuration for the powerful COZYROC REST framework.
- Bidirectional integration with Close service.
- Introduced April, 2020 in 2.0 version.
- Implemented as configuration for the powerful COZYROC REST framework.
- Bidirectional integration with Copper service.
- Introduced February, 2020 in 2.0 version.
- Implemented as configuration for the powerful COZYROC REST framework.
- 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 Dynamics 365, Premise, Live, Hosted deployments.
- Support 2016, 2015, 2013, 2011, 4.0 and 3.0 systems.
- Bidirectional integration with Freshsales service.
- Introduced July, 2023 in 2.2 version.
- Implemented as configuration for the powerful COZYROC REST framework.
- Bidirectional integration with Infusionsoft service.
- Introduced May, 2021 in 2.1 version.
- Implemented as configuration for the powerful COZYROC REST framework.
- Deprecated in 2.1 version and above.
- Bidirectional adapters for SugarCRM integration.
- Introduced July, 2012 in 1.6 version.
- Uses the standard SugarCRM SOAP web services API.
- Bidirectional integration with Pipedrive service.
- Introduced August, 2020 in 2.0 version.
- Implemented as configuration for the powerful COZYROC REST framework.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- 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.
- 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.
- Bidirectional integration with SugarCRM service.
- Introduced May, 2021 in 2.1 version.
- Implemented as configuration for the powerful COZYROC REST framework.
- Bidirectional integration with SuiteCRM service.
- Introduced May, 2021 in 2.1 version.
- Implemented as configuration for the powerful COZYROC REST framework.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Bidirectional integration with Zoho CRM service.
- Introduced January, 2017 in 1.7 version.
- Implemented as configuration for the powerful COZYROC REST framework.
Data Cleansing
- 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.
Database
- Efficient, high volume create, update, upsert and delete of database records.
- Support regular and bulk operations.
- Introduced June, 2020 in 2.0 version.
- Support SQL Server, Oracle, PostgreSQL, DB2, Informix, MySQL, SAP ASE, Teradata databases.
- Support 32bit and 64bit database drivers (ADO.NET, OLE DB, ODBC).
- Support redirection of incorrect rows to error output (except in bulk mode)
- Saves you time by handling the intricacies of the partitioning and letting you concentrate on your workflow instead.
- Introduced August, 2007 in 1.1 version.
- 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.
- Introduced January, 2024 in 2.2 version.
- Support SQL Server, Oracle, PostgreSQL, DB2, MySQL, Teradata databases.
- Support 32bit and 64bit database drivers (ADO.NET, OLE DB, ODBC).
- 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.
- 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.
- 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.
- 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.
- Support for Snowflake service
- Introduced January, 2024 in 2.2 version.
- Implemented as configuration for the powerful COZYROC REST framework.
- 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.
- Bidirectional adapters for Teradata database integration.
- Introduced July, 2012 in 1.6 version.
- 80x faster bulk loading speed compared to ODBC.
- Support by the unique COZYROC Data Flow Task Plus for amazing dynamic data flows at runtime.
Education
- Bidirectional integration with Canvas LMS service.
- Introduced July, 2023 in 2.2 version.
- Implemented as configuration for the powerful COZYROC REST framework.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Bidirectional integration with SimplyDigi service.
- Introduced January, 2017 in 1.7 version.
- Implemented as configuration for the powerful COZYROC REST framework.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
ERP
- Bidirectional integration with Acumatica service.
- Introduced May, 2021 in 2.1 version.
- Implemented as configuration for the powerful COZYROC REST framework.
- Bidirectional adapters for Dynamics AX integration.
- Introduced October, 2010 in 1.5 SR-1 version.
- Based on Microsoft .NET Business Connector for Dynamics AX.
- Bidirectional integration with Dynamics 365 Business Central service.
- Introduced January, 2022 in 2.1 version.
- Implemented as configuration for the powerful COZYROC REST framework.
- 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.
- Bidirectional adapters for Dynamics NAV integration.
- Introduced July, 2012 in 1.6 version.
- Uses only standard Microsoft Dynamics NAV web services API.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- 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.
- Support for NetSuite REST service.
- Introduced July, 2023 in 2.2 version.
- Implemented as configuration for the powerful COZYROC REST framework.
- Bidirectional integration with Sage 300 ERP service.
- Introduced May, 2021 in 2.1 version.
- Implemented as configuration for the powerful COZYROC REST framework.
File Formats
- Introduced in January, 2024 in 2.2 version.
- Supports BER, CER and DER encoding.
- Supports an error output for redirecting problematic records
- Parsing and generating of EDI files.
- EDI mapping setup is made in XML configuration file.
- EDI Source introduced in July, 2008 in 1.3 version.
- EDI Destination and EDI Connection Manager introduced in November, 2018 in 1.9 version.
- Parsing and generating of JSON files.
- Columns metadata is configured by providing sample JSON data.
- JSON Source introduced in December, 2019 in 2.0 version
- JSON Destination introduced in June, 2020 in 2.0 version
- Introduced in November, 2021 in 2.1 version.
- Parsing and generating of Apache Parquet files.
- Columns metadata is configured by providing a sample Parquet file or specifying the schema in JSON format.
- Introduced January, 2022 in 2.1 version.
- Support reading of tabular data from PDF files
- Intuitive user interface with fine-grained error control.
- 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.
- 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.
- Generates an XML document and stores it in a file.
- Introduced May, 2022 in 2.1 version.
- The shape of the XML document can be quickly inferred from a sample XML file or an XSD.
- Supports complex XML document structures using the composite inputs pattern.
- Designed to efficiently process unlimited amounts of input data with capped active memory consumption.
- 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.
File Transfer
- Support for Amazon S3 service file management thru COZYROC File Transfer Task.
- Introduced January, 2022 in 2.1 version.
- Implemented as configuration for the powerful COZYROC REST framework.
- Support for Azure Blob Storage service file management thru COZYROC File Transfer Task.
- Introduced July, 2023 in 2.2 version.
- Implemented as configuration for the powerful COZYROC REST framework.
- Bidirectional integration with Microsoft Azure Files service.
- Introduced January, 2024 in 2.2 version.
- Implemented as configuration for the powerful COZYROC REST framework.
- Support for Box service file management thru COZYROC File Transfer Task.
- Introduced July, 2022 in 2.2 version.
- Implemented as configuration for the powerful COZYROC REST framework.
- 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.
- Support for send, receive and delete files, create and remove directory, rename file commands.
- Introduced January, 2017 in 1.7 version.
- Replacement for deprecated COZYROC SFTP Task.
- Support for:
- Support for input and output data streaming, without a need for temporary storage.
- Introduced July, 2008 in 1.3 version.
- 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.
- Support for Google Cloud Storage service file management thru COZYROC File Transfer Task.
- Introduced February, 2022 in 2.1 version.
- Implemented as configuration for the powerful COZYROC REST framework.
- 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.
- Deprecated in 2.1 version and above. It is replaced by File Transfer Task.
- Based on Amazon S3 Connection Manager.
- Introduced June, 2008 in 1.3 version.
- 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.
- Connectivity with ODETTE/OFTP2 servers.
- Introduced March, 2022 in 2.1 version.
- Support secure connections.
- Streamlined user interface.
- Deprecated in 2.1 version and above.
- 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.
- Support for Oracle Cloud Object Storage service file management thru COZYROC File Transfer Task.
- Introduced July, 2023 in 2.2 version.
- Implemented as configuration for the powerful COZYROC REST framework.
- Secure copying of files with remote SSH server.
- Introduced November, 2009 in 1.4 version.
- Based on SSH Connection Manager.
- Streamlined user interface.
- Deprecated in 1.7 version and replaced by the new COZYROC File Transfer Task.
- Secure FTP communications and management.
- 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.
- Secure connections with SSH-enabled server.
- Introduced August, 2007 in 1.1 version.
- 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.
Financials
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
GIS
- 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).
- Bidirectional integration with Google Maps service.
- Introduced January, 2022 in 2.1 version.
- Implemented as configuration for the powerful COZYROC REST framework.
Help Desk
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- 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).
- Bidirectional integration with Zoho Desk service.
- Introduced July, 2023 in 2.2 version.
- Implemented as configuration for the powerful COZYROC REST framework.
HR
- Bidirectional integration with ADP service.
- Introduced April, 2020 in 2.0 version.
- Implemented as configuration for the powerful COZYROC REST framework.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- 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).
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Bidirectional integration with a KRONOS.
- Introduced April, 2019 in 1.9 version.
- Implemented as configuration for the powerful COZYROC REST framework.
- Bidirectional adapters for OpenAir integration.
- Introduced July, 2012 in 1.6 version.
- Based on standard OpenAir SOAP web services API.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
Legal
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
Manufacturing
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
Marketing
- Bidirectional integration with Act-On.
- Introduced June, 2019 in 1.9 version.
- Implemented as configuration for the powerful COZYROC REST framework.
- Bidirectional integration with ActiveCampaign service.
- Introduced January, 2020 in 2.0 version.
- Implemented as configuration for the powerful COZYROC REST framework.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- 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).
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Bidirectional integration with Facebook service.
- Introduced August, 2023 in 2.2 version.
- Implemented as configuration for the powerful COZYROC REST framework.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- 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.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Bidirectional integration with Klaviyo service.
- Introduced October, 2023 in 2.2 version.
- Implemented as configuration for the powerful COZYROC REST framework.
- Bidirectional integration with Linkedin service.
- Introduced August, 2020 in 2.0 version.
- Implemented as configuration for the powerful COZYROC REST framework.
- 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).
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- 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.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Bidirectional integration with Oracle Eloqua service.
- Introduced July, 2023 in 2.2 version.
- Implemented as configuration for the powerful COZYROC REST framework.
- 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).
- Bidirectional integration with Sailthru.
- Introduced June, 2019 in 1.9 version.
- Implemented as configuration for the powerful COZYROC REST framework.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Bidirectional integration with SendGrid service.
- Introduced April, 2020 in 2.0 version.
- Implemented as configuration for the powerful COZYROC REST framework.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Bidirectional integration with Twitter service.
- Introduced January, 2017 in 1.7 version.
- Implemented as configuration for the powerful COZYROC REST framework.
- Support User and Application-Only authentication.
- Bidirectional integration with YouTube service.
- Introduced April, 2020 in 2.0 version.
- Implemented as configuration for the powerful COZYROC REST framework.
- Bidirectional integration with Zoho Campaigns service.
- Introduced February, 2024 in 2.2 version.
- Implemented as configuration for the powerful COZYROC REST framework.
Medical
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Support for the FHIR standard for health care data exchange.
- Introduced January, 2024 in 2.2 version.
- Implemented as configuration for the powerful COZYROC REST framework.
No-Code
- Bidirectional integration with Airtable service.
- Introduced July, 2023 in 2.2 version.
- Implemented as configuration for the powerful COZYROC REST framework.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Bidirectional integration with Google AppSheet.
- Introduced July, 2023 in 2.2 version.
- Implemented as configuration for the powerful COZYROC REST framework.
- Bidirectional integration with Kintone.
- Introduced January, 2022 in 2.1 version.
- Implemented as configuration for the powerful COZYROC REST framework.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Bidirectional integration with QuickBase service.
- Introduced July, 2020 in 2.0 version.
- Implemented as configuration for the powerful COZYROC REST framework.
Nonprofit
- Bidirectional integration with Blackbaud service.
- Introduced August, 2020 in 2.0 version.
- Implemented as configuration for the powerful COZYROC REST framework.
- Bidirectional integration with Bloomerang service.
- Introduced May, 2021 in 2.1 version.
- Implemented as configuration for the powerful COZYROC REST framework.
NoSQL
- Support for Amazon DynamoDB service
- Introduced October, 2023 in 2.2 version.
- Implemented as configuration for the powerful COZYROC REST framework.
- Bidirectional adapters for MongoDB integration.
- Introduced April, 2018 in 1.8 version
- Support for all major connectivity methods (including X.509, LDAP, Kerberos)
- Support for nested documents, as array items.
- Support for batching when reading and creating MongoDB documents.
Productivity
- Bidirectional adapters for Microsoft Excel integration.
- Introduced August, 2010 in 1.5 version.
- Support Microsoft Excel 97-2019 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.
- 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.
- Bidirectional integration with Google Tasks service.
- Introduced January, 2017 in 1.7 version.
- Implemented as configuration for the powerful COZYROC REST framework.
- Bidirectional integration with Smartsheet service.
- Introduced December, 2017 in 1.8 version.
- Implemented as configuration for the powerful COZYROC REST framework.
- Important: Wunderlist service has been discontinued.
- Bidirectional integration with Wunderlist service.
- Introduced December, 2017 in 1.8 version.
- Implemented as configuration for the powerful COZYROC REST framework.
- Bidirectional integration with Zoho Sheet service.
- Introduced January, 2022 in 2.1 version.
- Implemented as configuration for the powerful COZYROC REST framework.
- Intuitive support for composite objects.
Project Management
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- 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).
- Bidirectional integration with ClickUp service.
- Introduced July, 2023 in 2.2 version.
- Implemented as configuration for the powerful COZYROC REST framework.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Bidirectional integration with monday service.
- Introduced April, 2020 in 2.0 version.
- Implemented as configuration for the powerful COZYROC REST framework.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Bidirectional integration with Teamwork service.
- Introduced September, 2020 in 2.0 version.
- Implemented as configuration for the powerful COZYROC REST framework.
- 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).
- Bidirectional integration with Wrike service.
- Introduced September, 2023 in 2.2 version.
- Implemented as configuration for the powerful COZYROC REST framework.
Security
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Bidirectional integration with KnowBe4.
- Introduced October, 2023 in 2.2 version.
- Implemented as configuration for the powerful COZYROC REST framework.
- 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.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
Survey
- Bidirectional integration with Alchemer service.
- Introduced May, 2021 in 2.1 version.
- Implemented as configuration for the powerful COZYROC REST framework.
- Intuitive support for composite objects (rows, cols, choices, questions, pages, etc).
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Bidirectional integration with Formstack service.
- Introduced May, 2021 in 2.1 version.
- Implemented as configuration for the powerful COZYROC REST framework.
- Bidirectional integration with Google Forms service.
- Introduced July, 2023 in 2.2 version.
- Implemented as configuration for the powerful COZYROC REST framework.
- Bidirectional integration with Gravity Forms.
- Introduced November, 2023 in 2.2 version.
- Implemented as configuration for the powerful COZYROC REST framework.
- Bidirectional integration with JotForm service.
- Introduced January, 2022 in 2.1 version.
- Implemented as configuration for the powerful COZYROC REST framework.
- Bidirectional integration with Qualtrics service.
- Introduced July, 2023 in 2.2 version.
- Implemented as configuration for the powerful COZYROC REST framework.
- 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).
- Bidirectional integration with TypeForm.
- Introduced January, 2022 in 2.1 version.
- Implemented as configuration for the powerful COZYROC REST framework.
Time Management
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
Transportation
- 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).
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
Video Conference
- 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).
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
- Experimental configuration with missing definitions.
- Copy-and-Paste in REST Connection Manager → { Custom }
- Please contact and provide feedback and tips.
- Implemented as configuration for the powerful COZYROC REST framework.
-
- Bidirectional integration with ActiveCampaign service.
- Introduced January, 2020 in 2.0 version.
- Implemented as configuration for the powerful COZYROC REST framework.
-
- 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.
-
- Bidirectional integration with Amazon Athena service.
- Introduced January, 2022 in 2.1 version.
- Implemented as configuration for the powerful COZYROC REST framework.
-
- Support for Amazon DynamoDB service
- Introduced October, 2023 in 2.2 version.
- Implemented as configuration for the powerful COZYROC REST framework.
-
- Support for Amazon S3 service file management thru COZYROC File Transfer Task.
- Introduced January, 2022 in 2.1 version.
- Implemented as configuration for the powerful COZYROC REST framework.
-
- Bidirectional integration with Amazon Selling Partner service.
- Introduced July, 2023 in 2.2 version.
- Implemented as configuration for the powerful COZYROC REST framework.
-
- Bidirectional integration with Microsoft Azure Queue Storage service.
- Introduced November, 2023 in 2.2 version.
- Implemented as configuration for the powerful COZYROC REST framework.
-
- Connections with AMQP 1.0 servers (version 1.0).
- Support SASL SSL and SASL Plaintext security protocol types.
- Streamlined user interface.
-
- 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).
-
- Introduced in January, 2024 in 2.2 version.
- Supports BER, CER and DER encoding.
- Supports an error output for redirecting problematic records
-
- Support for Azure Blob Storage service file management thru COZYROC File Transfer Task.
- Introduced July, 2023 in 2.2 version.
- Implemented as configuration for the powerful COZYROC REST framework.
-
- Bidirectional integration with Microsoft Azure Files service.
- Introduced January, 2024 in 2.2 version.
- Implemented as configuration for the powerful COZYROC REST framework.
-
- Bidirectional integration with Microsoft Azure Queue Storage service.
- Introduced July, 2023 in 2.2 version.
- Implemented as configuration for the powerful COZYROC REST framework.
-
- Bidirectional integration with Microsoft Azure Table service.
- Introduced January, 2022 in 2.1 version.
- Implemented as configuration for the powerful COZYROC REST framework.
-
- Bidirectional integration with BigCommerce service.
- Introduced April, 2022 in 2.1 version.
- Implemented as configuration for the powerful COZYROC REST framework.
-
- Bidirectional integration with Bloomerang service.
- Introduced May, 2021 in 2.1 version.
- Implemented as configuration for the powerful COZYROC REST framework.
-
- Support for Box service file management thru COZYROC File Transfer Task.
- Introduced July, 2022 in 2.2 version.
- Implemented as configuration for the powerful COZYROC REST framework.
-
- Bidirectional integration with Canvas LMS service.
- Introduced July, 2023 in 2.2 version.
- Implemented as configuration for the powerful COZYROC REST framework.
-
- Bidirectional integration with Capsule CRM service.
- Introduced February, 2022 in 2.1 version.
- Implemented as configuration for the powerful COZYROC REST framework.
-
- 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).
-
- Exposes data from a data flow for in-memory read in another data flow.
- Introduced January, 2008 in 1.2 version.
- Scalable alternative of the recommended Microsoft solution with raw data file destination.
- User interface is based on the standard data flow destination component dialog.
-
- Based on Package Connection Manager.
- Introduced January, 2008 in 1.2 version.
- 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.
-
- Extension of Microsoft SSIS Data Flow Task with support for dynamic data flows at runtime.
- Introduced January, 2008 in 1.2 version.
- 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.
-
- Efficient, high volume create, update, upsert and delete of database records.
- Support regular and bulk operations.
- Introduced June, 2020 in 2.0 version.
- Support SQL Server, Oracle, PostgreSQL, DB2, Informix, MySQL, SAP ASE, Teradata databases.
- Support 32bit and 64bit database drivers (ADO.NET, OLE DB, ODBC).
- Support redirection of incorrect rows to error output (except in bulk mode)
-
- Saves you time by handling the intricacies of the partitioning and letting you concentrate on your workflow instead.
- Introduced August, 2007 in 1.1 version.
- 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.
-
- Introduced January, 2024 in 2.2 version.
- Support SQL Server, Oracle, PostgreSQL, DB2, MySQL, Teradata databases.
- Support 32bit and 64bit database drivers (ADO.NET, OLE DB, ODBC).
-
- 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.
-
- Expands the features, flexibility and functionality of the built-in Microsoft SSIS Derived Column.
- Flexible JavaScript expressions editing experience within an embedded JavaScript editor.
- Convenient real-time expression evaluator.
- Provides a rich set of predefined JavaScript functions.
-
- Connections with Microsoft Windows AppFabric caching service.
- Introduced October, 2010 in 1.5 SR-1 version.
- Streamlined user interface.
-
- 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.
-
- Bidirectional adapters for Dynamics AX integration.
- Introduced October, 2010 in 1.5 SR-1 version.
- Based on Microsoft .NET Business Connector for Dynamics AX.
-
- Connections with Microsoft Dynamics AX server.
- Introduced October, 2010 in 1.5 SR-1 version.
- Support Dynamics AX 2012, 2009, 4.0 systems.
- Streamlined user interface.
-
- Based on Dynamics AX Connection Manager.
- Introduced October, 2010 in 1.5 SR-1 version.
- Store data into Microsoft Dynamics AX server table.
- User interface is based on the standard data flow destination component dialog.
-
- Based on Dynamics AX Connection Manager.
- Support both table and statement as a source.
- User interface is based on the standard data flow source component dialog.
-
- Bidirectional integration with Dynamics 365 Business Central service.
- Introduced January, 2022 in 2.1 version.
- Implemented as configuration for the powerful COZYROC REST framework.
-
- 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 Dynamics 365, Premise, Live, Hosted deployments.
- Support 2016, 2015, 2013, 2011, 4.0 and 3.0 systems.
-
- Connections with Microsoft Dynamics CRM service.
- Introduced August, 2010 in 1.5 version.
- Support Office 365, Premise, Live, Hosted deployments.
- Support Dynamics CRM 3 - 2016 systems.
- Streamlined user interface.
-
- Based on Dynamics CRM Connection Manager.
- Introduced August, 2010 in 1.5 version.
- Store data into Microsoft Dynamics CRM service entity.
- Support CRM 2011 bulk-load 1.6 SR-1.
- User interface is based on the standard data flow destination component dialog.
-
- Based on Dynamics CRM Connection Manager.
- Introduced August, 2010 in 1.5 version.
- Support both entity and FetchXML statement as a source.
- User interface is based on the standard data flow source component dialog.
-
- 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.
-
- Connections with Dynamics GP web service.
- Introduced July, 2012 in 1.6 version.
- Streamlined user interface.
-
- Based on Dynamics GP Connection Manager.
- Introduced July, 2012 in 1.6 version.
- Store data into Dynamics GP object.
- Support write of composite DynamicsGP object property.
- User interface is based on the standard data flow destination component dialog.
-
- Based on Dynamics GP Connection Manager.
- Introduced July, 2012 in 1.6 version.
- Support read of composite Dynamics GP object property.
- User interface is based on the standard data flow source component dialog.
-
- Bidirectional adapters for Dynamics NAV integration.
- Introduced July, 2012 in 1.6 version.
- Uses only standard Microsoft Dynamics NAV web services API.
-
- Connections with Dynamics NAV web service.
- Introduced July, 2012 in 1.6 version.
- Streamlined user interface.
-
- Based on Dynamics NAV Connection Manager.
- Introduced July, 2012 in 1.6 version.
- Store data into Dynamics NAV page.
- User interface is based on the standard data flow destination component dialog.
-
- Based on Dynamics NAV Connection Manager.
- Introduced July, 2012 in 1.6 version.
- User interface is based on the standard data flow source component dialog.
-
- Configure settings for reading or generating EDI files
- Introduced November, 2018 in 1.9 version.
- Streamlined user interface.
-
- Fast and easy generation of EDI format files.
- Introduced November, 2018 in 1.9 version.
- New EDI Connection manager which makes even simpler specifying both EDI Configuration and EDI Output files.
- EDI mapping setup is made in XML configuration file.
-
- 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 an XML configuration file.
- Since 1.9 has a custom editor and uses the newly introduced EDI Connection Manager
-
- Bidirectional integration with Elasticsearch service.
- Introduced July, 2020 in 2.0 version.
- Implemented as configuration for the powerful COZYROC REST framework.
-
- Bidirectional integration with Eventbrite service.
- Introduced May, 2021 in 2.1 version.
- Implemented as configuration for the powerful COZYROC REST framework.
-
- Bidirectional adapters for Microsoft Excel integration.
- Introduced August, 2010 in 1.5 version.
- Support Microsoft Excel 97-2019 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.
-
- Connections to Microsoft Excel workbook files.
- Introduced August, 2010 in 1.5 version.
- Support 64 bit execution.
- Support Microsoft Excel 97-2010 and Pocket Excel workbook files.
- Support password-protected workbooks.
- Streamlined user interface.
-
- Based on Excel Connection Manager.
- Introduced August, 2010 in 1.5 version.
- Support 64 bit execution.
- Intuitive user interface with fine-grained error control.
-
- Based on Excel Connection Manager.
- Introduced August, 2010 in 1.5 version.
- Support 64 bit execution.
- Support reading of raw, formatted and formula cell value.
- Intuitive user interface with fine-grained error control.
-
- Based on Excel Connection Manager.
- Introduced August, 2010 in 1.5 version.
- Support 64 bit execution.
- Support creating, deleting, clearing and renaming of worksheets.
- Support find and replace of cells in Excel worksheets.
- Streamlined user interface.
-
- Connections with Exchange web service.
- Introduced July, 2012 in 1.6 version.
- Support Exchange 2010 and above.
- Support Exchange Online.
- Support for mail send and receive.
- Streamlined user interface.
-
-
- 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).
-
- 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).
-
- Bidirectional integration with Freshsales service.
- Introduced July, 2023 in 2.2 version.
- Implemented as configuration for the powerful COZYROC REST framework.
-
- Introduced July, 2008 in 1.3 version.
- 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.
-
- 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).
-
- Introduced December, 2017 in 1.8 version.
- Implemented as configuration for the powerful COZYROC REST framework.
- Support reading of Google Analytics Reporting service report data.
- Support for Google Analytics Management service.
- Support for Google Analytics Admin API service.
-
- Bidirectional integration with Google AppSheet.
- Introduced July, 2023 in 2.2 version.
- Implemented as configuration for the powerful COZYROC REST framework.
-
- Bidirectional integration with Google BigQuery service.
- Introduced December, 2017 in 1.8 version.
- Implemented as configuration for the powerful COZYROC REST framework.
-
- 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).
-
- Bidirectional integration with Google Cloud Monitoring service.
- Introduced November, 2023 in 2.2 version.
- Implemented as configuration for the powerful COZYROC REST framework.
-
- Support for Google Cloud Storage service file management thru COZYROC File Transfer Task.
- Introduced February, 2022 in 2.1 version.
- Implemented as configuration for the powerful COZYROC REST framework.
-
- Bidirectional integration with Google Dataplex service.
- Introduced October, 2023 in 2.2 version.
- Implemented as configuration for the powerful COZYROC REST framework.
-
- 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.
-
- Bidirectional integration with Google Forms service.
- Introduced July, 2023 in 2.2 version.
- Implemented as configuration for the powerful COZYROC REST framework.
-
- Bidirectional integration with Google Maps service.
- Introduced January, 2022 in 2.1 version.
- Implemented as configuration for the powerful COZYROC REST framework.
-
- Bidirectional integration with Google People service.
- Introduced January, 2022 in 2.1 version.
- Implemented as configuration for the powerful COZYROC REST framework.
-
- Bidirectional integration with Google Search Console service.
- Introduced January, 2024 in 2.2 version.
- Implemented as configuration for the powerful COZYROC REST framework.
-
- 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.
-
- Bidirectional integration with Google Tasks service.
- Introduced January, 2017 in 1.7 version.
- Implemented as configuration for the powerful COZYROC REST framework.
-
- 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).
-
- Bidirectional integration with Gravity Forms.
- Introduced November, 2023 in 2.2 version.
- Implemented as configuration for the powerful COZYROC REST framework.
-
- 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.
-
- Connections with IMAP mail server.
- Introduced August, 2010 in 1.5 version.
- Support secure connections.
- Streamlined user interface.
-
- 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.
-
- Bidirectional integration with Infusionsoft service.
- Introduced May, 2021 in 2.1 version.
- Implemented as configuration for the powerful COZYROC REST framework.
-
- Connections with Jabber servers.
- Introduced July, 2008 in 1.3 version.
- Support socket, HTTP polling and HTTP binding connection types.
- Support for SOCKS4, SOCKS5, HTTP proxy.
- Streamlined user interface.
-
- 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.
-
- Support for using JavaScript for SSIS scripting (via JavaScript Task and JavaScript Component)
- Prepare easily parameterizable, reusable scripts.
- Convenient script editing experience within an embedded JavaScript editor.
- Seamless upgrades to newer versions of SQL Server
- Reusable scripts and samples (see the "Scripts" tab)
- Introduced November, 2018 in 1.9 version.
- Supports SQL Server 2012 or later
-
- A simpler-to-use alternative of Microsoft SSIS Script Component
- Enables authoring of easily parameterizable, reusable scripts.
- Convenient script editing experience within an embedded JavaScript editor.
- Introduced November, 2018 in 1.9 version.
-
- A simpler-to-use, more flexible alternative of Microsoft SSIS Script Task
- Enables authoring of easily parameterizable, reusable scripts.
- Convenient script editing experience within an embedded JavaScript editor.
- Introduced November, 2018 in 1.9 version.
-
- 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).
-
- Parsing and generating of JSON files.
- Columns metadata is configured by providing sample JSON data.
- JSON Source introduced in December, 2019 in 2.0 version
- JSON Destination introduced in June, 2020 in 2.0 version
-
- Generate a JSON array document and store it in a file or a variable
- Support composite outputs for populating nested JSON arrays
- Introduced in June 2020 in 2.0 version.
-
- Support multiple JSON sources - variable, file and text
- Support reading of nested JSON documents in arrays
- Introduced in December 2019 in 2.0 version.
-
- Connections with Kafka servers (version 0.8 or and newer).
- Support Plaintext, SSL, SASL SSL and SASL Plaintext security protocol types.
- Support for GSSAPI, SCRAM-SHA-256, SCRAM-SHA-512 and OAuth bearer token .
- Streamlined user interface.
-
- 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.
-
- Connections with LDAP service.
- Streamlined user interface.
-
- Based on LDAP Connection Manager.
- Insert data into LDAP object.
- User interface is based on the standard data flow destination component dialog.
-
- Based on LDAP Connection Manager.
- Read from LDAP object.
- User interface is based on the standard data flow source component dialog.
-
- Deprecated in 2.1 version and above.
- Connections with Amazon S3 Service.
- Introduced June, 2008 in 1.3 version.
- Optional support for proxy.
- Streamlined user interface.
-
- Deprecated in 2.1 version and above. It is replaced by File Transfer Task.
- Based on Amazon S3 Connection Manager.
- Introduced June, 2008 in 1.3 version.
- 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.
-
- Deprecated in 2.1 version and above.
- Bidirectional adapters for SugarCRM integration.
- Introduced July, 2012 in 1.6 version.
- Uses the standard SugarCRM SOAP web services API.
-
- Connections with SugarCRM web service.
- Introduced July, 2012 in 1.6 version.
- Streamlined user interface.
-
- Based on SugarCRM Connection Manager.
- Introduced July, 2012 in 1.6 version.
- Store data into SugarCRM module.
- User interface is based on the standard data flow destination component dialog.
-
- Based on SugarCRM Connection Manager.
- Introduced July, 2012 in 1.6 version.
- User interface is based on the standard data flow source component dialog.
-
- 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.
-
- 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.
-
- Support for sending and receiving of queue messages.
- Introduced May, 2021 in 2.1 version.
- Support for:
-
- Bidirectional integration with Microsoft Dataverse service.
- Introduced May, 2019 in 1.9 version. Then it was named "Microsoft Common Data Service".
- Implemented as configuration for the powerful COZYROC REST framework.
-
- Bidirectional integration with Microsoft Graph service.
- Introduced May, 2021 in 2.1 version.
- Implemented as configuration for the powerful COZYROC REST framework.
-
- Bidirectional adapters for MongoDB integration.
- Introduced April, 2018 in 1.8 version
- Support for all major connectivity methods (including X.509, LDAP, Kerberos)
- Support for nested documents, as array items.
- Support for batching when reading and creating MongoDB documents.
-
- Connectivity with MongoDB document databases
- Streamlined user interface.
-
- Supports 'Create', 'Replace', 'Update' and 'Delete' actions.
- Supports nested documents in array(s) by offering separate inputs for the array items.
- Supports batch creation of documents.
- Provides information about failures during processing, as well as the ObjectId identifier for added, updated or deleted documents.
-
- Based on MongoDB Connection Manager.
- Support read of nested documents in arrays
- User interface is based on the standard data flow source component dialog.
-
- 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.
-
- Connections with NetSuite web service.
- Introduced July, 2012 in 1.6 version.
- Streamlined user interface.
-
- Based on NetSuite Connection Manager.
- Introduced July, 2012 in 1.6 version.
- Store data into NetSuite record.
- Support write of composite NetSuite record field.
- User interface is based on the standard data flow destination component dialog.
-
- Based on NetSuite Connection Manager.
- Introduced July, 2012 in 1.6 version.
- Support read of composite NetSuite record field.
- User interface is based on the standard data flow source component dialog.
-
- Event-based application integration processing.
- Support for webhooks and the ability to use other trigger APIs.
- Reliable events handling with the use of message queuing technology.
- Scalable, distributed package execution for handling a large number of events.
- "Warm-start" package execution for optimal performance.
- Introduced November, 2019.
-
- 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.
-
- Connectivity with ODETTE/OFTP2 servers.
- Introduced March, 2022 in 2.1 version.
- Support secure connections.
- Streamlined user interface.
-
- Deprecated in 2.1 version and above.
- 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.
-
- Bidirectional adapters for OpenAir integration.
- Introduced July, 2012 in 1.6 version.
- Based on standard OpenAir SOAP web services API.
-
- Connections with OpenAir web service.
- Introduced July, 2012 in 1.6 version.
- Streamlined user interface.
-
- Based on OpenAir Connection Manager.
- Introduced July, 2012 in 1.6 version.
- Store data into OpenAir type.
- User interface is based on the standard data flow destination component dialog.
-
- Based on OpenAir Connection Manager.
- Introduced July, 2012 in 1.6 version.
- User interface is based on the standard data flow source component dialog.
-
- 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.
-
- Support for Oracle Cloud Object Storage service file management thru COZYROC File Transfer Task.
- Introduced July, 2023 in 2.2 version.
- Implemented as configuration for the powerful COZYROC REST framework.
-
- 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.
-
- Bidirectional integration with Oracle Eloqua service.
- Introduced July, 2023 in 2.2 version.
- Implemented as configuration for the powerful COZYROC REST framework.
-
- 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.
-
- Introduced in November, 2021 in 2.1 version.
- Parsing and generating of Apache Parquet files.
- Columns metadata is configured by providing a sample Parquet file or specifying the schema in JSON format.
-
- Support generating files in Apache Parquet format.
- Introduced January, 2022 in 2.1 version.
- Support writing nested objects in arrays.
-
- Support reading Apache Parquet file format.
- Support reading of nested objects in arrays.
- Introduced in January, 2022 in 2.1 version.
-
- Introduced January, 2022 in 2.1 version.
- Support reading of tabular data from PDF files
- Intuitive user interface with fine-grained error control.
-
- Connections with POP3 mail server.
- Introduced August, 2010 in 1.5 version.
- Support secure connections.
- Streamlined user interface.
-
- Enables execution of a user-specified PowerShell command or script.
- Introduced May, 2021 in 2.1 version.
- Convenient script editing within an embedded PowerShell editor.
- Convenient handling of output streams.
- Supports referencing a script defined in another PowerShell task and calling it with custom parameters.
-
- Bidirectional integration with PrestaShop service.
- Introduced October, 2023 in 2.2 version.
- Implemented as configuration for the powerful COZYROC REST framework.
-
- 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.
-
- Creation of QlikView QVX files.
- Introduced January, 2017 in 1.7 version.
- User interface is based on the standard data flow destination component dialog.
-
- Read from QlikView QVX files.
- Introduced January, 2017 in 1.7 version.
- User interface is based on the standard data flow source component dialog.
-
- Bidirectional adapters for QuickBooks Desktop integration.
- Introduced July, 2012 in 1.6 version.
- Intuitive support for composite objects.
-
- Connections with QuickBooks web service.
- Introduced July, 2012 in 1.6 version.
- Support for QuickBooks Desktop.
- Streamlined user interface.
-
- Based on QuickBooks Connection Manager.
- Introduced July, 2012 in 1.6 version.
- Store data into QuickBooks object.
- Support write of composite QuickBooks object field.
- User interface is based on the standard data flow destination component dialog.
-
- Bidirectional integration with QuickBooks Online service.
- Introduced January, 2022 in 2.1 version.
- Implemented as configuration for the powerful COZYROC REST framework.
-
- Based on QuickBooks Connection Manager.
- Introduced July, 2012 in 1.6 version.
- Support read of composite QuickBooks object field.
- User interface is based on the standard data flow source component dialog.
-
- Connections with RabbitMQ servers (version 1.8.0 or and newer).
- Support SASL SSL and SASL Plaintext security protocol types.
- Support AMQP 0-9-1 messaging protocol.
- Streamlined user interface.
-
- Support receiving and opening of secure S/MIME emails.
- Introduced August, 2010 in 1.5 version.
- Based on IMAP Connection Manager.
- Based on POP3 Connection Manager.
- Based on Exchange Connection Manager 1.6.
- Support filtering with criteria of received emails.
- Streamlined user interface.
-
- Powerful framework for integration with any REST service (many pre-built integrations available).
- Connectivity and REST resource utilization is implemented thru specially crafted XML-based configuration file with support of JavaScript code.
- Introduced July, 2016 in 1.7 version.
- Major enhancements in 1.9 version.
- Intuitive support for composite objects.
- Optional access to any .NET class for additional functionality.
-
- Connections with REST web services.
- Introduced January, 2017 in 1.7 version.
- Optional support for proxy.
- Optional retry for particular errors.
- Streamlined user interface.
-
- Based on REST Connection Manager.
- Introduced January, 2017 in 1.7 version.
- Intuitive user interface with fine-grained error control.
-
- Support for NetSuite REST service.
- Introduced July, 2023 in 2.2 version.
- Implemented as configuration for the powerful COZYROC REST framework.
-
- Based on REST Connection Manager.
- Introduced January, 2017 in 1.7 version.
- Intuitive user interface with fine-grained error control.
-
- 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.
-
- Bidirectional integration with Sage 300 ERP service.
- Introduced May, 2021 in 2.1 version.
- Implemented as configuration for the powerful COZYROC REST framework.
-
- Bidirectional integration with Sage Business Cloud Accounting service.
- Introduced September, 2020 in 2.0 version.
- Implemented as configuration for the powerful COZYROC REST framework.
-
- Connections with Sage SData web service.
- Introduced July, 2012 in 1.6 version.
- Streamlined user interface.
-
- Based on Sage Connection Manager.
- Introduced July, 2012 in 1.6 version.
- Store data into Sage entity.
- Support write of composite Sage entity property.
- User interface is based on the standard data flow destination component dialog.
-
- Bidirectional integration with Sage Intacct service.
- Introduced May, 2021 in 2.1 version.
- Implemented as configuration for the powerful COZYROC REST framework.
- Support for any available standard and custom object.
-
- Based on Sage Connection Manager.
- Introduced July, 2012 in 1.6 version.
- Support read of composite Sage entity property.
- User interface is based on the standard data flow source component dialog.
-
- 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.
-
- Connections with Salesforce service.
- Introduced October, 2009 in 1.4 version.
- Streamlined user interface.
-
- Support reading of Salesforce Reports service report data.
- Support for Salesforce Dashboards service.
- Introduced November, 2023 in 2.2 version.
- Implemented as configuration for the powerful COZYROC REST framework.
-
- Based on Salesforce Connection Manager.
- Introduced October, 2009 in 1.4 version.
- Store data into Salesforce service object.
- Support regular and bulk-load 1.6.
- User interface is based on the standard data flow destination component dialog.
-
- Based on Salesforce Connection Manager.
- Introduced October, 2009 in 1.4 version.
- Support both object and SOQL statement as a source.
- User interface is based on the standard data flow source component dialog.
-
- 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.
-
- Premium component licensed separately from SSIS+ library.
- Introduced May, 2011 in 1.5 SR-2 version.
- Installation and licensing of SAS® Analytics not required.
- User interface is based on the standard data flow destination component dialog.
-
- Premium component licensed separately from SSIS+ library.
- Introduced May, 2011 in 1.5 SR-2 version.
- 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.
-
- Secure copying of files with remote SSH server.
- Introduced November, 2009 in 1.4 version.
- Based on SSH Connection Manager.
- Streamlined user interface.
-
Execute SQL command for each row (like the standard OLE DB Command Transformation, but with ADO.NET).
-
Send electronic documents (EDI, XML) using AS2 specification.
-
Calculate CRC32 or SHA256 checksum for one or more input columns.
-
Compress or decompress columns.
-
Encrypt or decrypt one or more input columns.
-
Store the values from the input columns into SSIS variable(s).
-
- 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.
-
Change data type, length, precision, scale of selected input columns.
-
Add a row counter column (e.g. can be used for surrogate keys).
-
Process data flow result into control flow.
-
Retrieve data from variable containing IDataRecord object.
-
Extract field information from IDataRecord object into SSIS variables.
-
Verify the output of an upstream component by comparing it against predefined data.
-
Load data in an in-memory ADO.NET DataSet object (similar to standard Recordset Destination).
-
Reformat dates in text columns.
-
Generate rows for a range of dates (by specifying a start date, an end date and an increment step).
-
Loading input into a dictionary object.
-
Add or remove a user to the auto created access team for the specified record.
-
Assign record to a different owner.
-
Create associations between Dynamics CRM entities.
-
Retrieve Dynamics CRM entity attributes metadata.
-
Retrieve Dynamics CRM audit log records.
-
Perform Dynamics CRM bulk delete.
-
Convert Dynamics CRM entity record from one type to another.
-
Retrieve Dynamics CRM entity changes records
-
Retrieve Dynamics CRM entity metadata.
-
Execute Dynamics CRM workflows.
-
Update incident entity state.
-
Perform lookup against Dynamics CRM.
-
Merge two Dynamics CRM entity records into one
-
Update opportunity entity state.
-
Handle translation and creation of Dynamics CRM OptionSet values.
-
Qualify a lead and create account, contact and opportunity records.
-
Convert Dynamics CRM quote to a sales order.
-
Create Dynamics CRM relationships between entities.
-
Route Dynamics CRM entity record to a queue.
-
Establish team members relationship.
-
Establish user access permissions to Dynamics CRM entities.
-
Extract additional information (column names and error descriptions) for error outputs in a data flow.
-
Copy a worksheet from one Excel file into another.
-
Refresh Excel connections and pivot tables.
-
Executes anonymous Salesforce Apex DML code.
-
Executes anonymous Salesforce Apex DML code.
-
Calculate MD5 or SHA1 checksum for a file.
-
Check if a specified file exists.
-
Manage a list of SSIS+ IFileInfo objects (i.e. remote files on FTP, SFTP, S3, etc.).
-
Generate rows from IFileInfo list (i.e. remote files on FTP, SFTP, S3, etc.).
-
Generate rows from files properties.
-
Detect changes in a monitored folder.
-
"Find" or "Find & Replace" in a text file or a stream.
-
Check if a remote file exists (via SFTP or FTPS).
-
Demonstrate FTP over SSL (FTPS).
-
Retrieve via Google Geocoding and cache coordinates for input addresses.
-
Get Analysis Services object property.
-
Retrieve environment variable.
-
Get files list.
-
Retrieve a list of remote files on an FTP server.
-
Upload or download a file over HTTP.
-
Provide management functions for IMAP email server.
-
Demonstrate SSIS script initialization setup.
-
Combine multiple rows into single data flow row.
-
Bulk extract elements from JSON document into SSIS variables.
-
Retrieve data from a text column, containing an array of objects in JSON, XML or other text format.
-
Calculate difference between two strings using Levenshtein Distance.
-
Manage IMailInfo list.
-
Generate rows for a IMailInfo list.
-
Perform find-and-replace using dictionary object.
-
Measures the processing time of the pipeline it is attached to.
-
Merge temporary stage table using SQL 2008 MERGE (Transact-SQL) statement.
-
Perform lookup against Microsoft Dataverse.
-
Script task to download a file from NetSuite File Cabinet
-
Script task to upload a file to NetSuite File Cabinet
-
Setting and replacement of NULL values in the input columns.
-
Consume data from an OData feed (similar to the standard OData Source).
-
Send and receive EDI documents via ODETTE protocol.
-
Bulk-load data in Oracle table.
-
Customize an SSIS package externally via configuring its properties in an Excel sheet.
-
Retrieve PayPal transactions information.
-
Exports Power BI report.
-
Load profile trace information.
-
Create custom-crafted IDictionary object with representation of "many to one" relationships.
-
Extract matching groups from a given regular expression and output them as column values.
-
Split the input based on matching with provided regular expression.
-
Perform columns reorder.
-
Retrieve data from CSV File.
-
Send a request to a REST API endpoint.
-
Execute REST web service request for each data flow row.
-
Asynchronously output replicated rows based on repeat count, provided in a column.
-
Load information from RSS feed.
-
Return Salesforce bulk-load batch information.
-
Generate rows from the Salesforce object fields metadata.
-
Retrieve Salesforce object deleted record identifiers.
-
Retrieve Salesforce object updated record identifiers.
-
Perform lookup against Salesforce objects.
-
Retrieve Salesforce objects metadata.
-
Establish a secure tunnel using SSH protocol.
-
Send SMTP email (supports HTML messages and attachments).
-
Check if an SFTP connection can be established.
-
Create Soundex representation of input column.
-
Split single rows into multiple data flow rows.
-
Provide basic manipulation operations for SQL Agent Jobs.
-
Easier to use alternative of the standard OLE DB Command transformation for amending table records.
-
- 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.
-
Define tabular input data for testing purposes.
-
Convert date/time columns from one timezone to another.
-
Wait specified amount of seconds before continuing.
-
Transform an XML document using an XSLT file.
-
Easily terminate a data flow path (as a development aid)
-
Trim input columns.
-
Decompress data compressed with the unix "compress" utility (LZC, a LZW variant).
-
Write string Variable contents to a File.
-
Load data from Windows Management Information (WMI).
-
Extract information from a column with XML documents, using provided XPath expressions.
-
- Support sending of secure S/MIME emails.
- Introduced August, 2010 in 1.5 version.
- Based on SMTP Connection Manager.
- Based on Exchange Connection Manager 1.6.
- Support From, To, CC, BCC, Body, Body HTML, Priority, Attachment parameters.
- Streamlined user interface.
-
- 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.
-
- Bidirectional integration with ServiceTitan service.
- Introduced July, 2023 in 2.2 version.
- Implemented as configuration for the powerful COZYROC REST framework.
-
- Deprecated in 1.7 version and replaced by the new COZYROC File Transfer Task.
- Secure FTP communications and management.
- 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.
-
- 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 2019, 2016, 2013, 2010, 2007.
-
- Connections with Microsoft SharePoint service.
- Introduced August, 2010 in 1.5 version.
- Streamlined user interface.
-
- Based on SharePoint Connection Manager.
- Introduced August, 2010 in 1.5 version.
- Store data into Microsoft SharePoint list.
- User interface is based on the standard data flow destination component dialog.
-
- Based on SharePoint Connection Manager.
- Introduced August, 2010 in 1.5 version.
- 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.
-
- Bidirectional integration with SimplyDigi service.
- Introduced January, 2017 in 1.7 version.
- Implemented as configuration for the powerful COZYROC REST framework.
-
- Bidirectional integration with Smartsheet service.
- Introduced December, 2017 in 1.8 version.
- Implemented as configuration for the powerful COZYROC REST framework.
-
- Connections with SMTP mail server.
- Introduced August, 2010 in 1.5 version.
- Support secure connections.
- Streamlined user interface.
-
- Capable of handling millions of rows with ease.
- Introduced September, 2018 in 1.9 version.
- Intuitive user interface.
-
- Secure connections with SSH-enabled server.
- Introduced August, 2007 in 1.1 version.
- 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.
-
- Secure execution of shell commands on a remote SSH server.
- Introduced August, 2007 in 1.1 version.
- Based on SSH Connection Manager.
- Streamlined user interface.
-
- 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.
-
- 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).
-
- 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.
-
- Support reading and writing of Tableau Data Extract (TDE) files.
- Support for Tableau Server thru the available REST API.
-
- Bidirectional integration with Tableau Server.
- Introduced December, 2019 in 1.9 version.
- Implemented as configuration for the powerful COZYROC REST framework.
-
- Creation of Tableau Data Extract (TDE) files.
- Introduced September, 2014 in 1.6 SR-3 version.
- Requires deployment of Hyper API 2.1 version or Data Extract API.
- User interface is based on the standard data flow destination component dialog.
-
- 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.
-
- 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.
-
- Bidirectional adapters for Teradata database integration.
- Introduced July, 2012 in 1.6 version.
- 80x faster bulk loading speed compared to ODBC.
- Support by the unique COZYROC Data Flow Task Plus for amazing dynamic data flows at runtime.
-
- Bulk-load destination Teradata table component.
- Introduced July, 2012 in 1.6 version.
- 80x faster loading speed compared to ODBC.
- User interface is based on the standard data flow destination component dialog.
-
- Fast read from Teradata table.
- Introduced January, 2017 in 1.7 version.
- User interface is based on the standard data flow source component dialog.
-
- Important: Wunderlist service has been discontinued.
- Bidirectional integration with Wunderlist service.
- Introduced December, 2017 in 1.8 version.
- Implemented as configuration for the powerful COZYROC REST framework.
-
- Generates an XML document and stores it in a file.
- Introduced May, 2022 in 2.1 version.
- The shape of the XML document can be quickly inferred from a sample XML file or an XSD.
- Supports complex XML document structures using the composite inputs pattern.
- Designed to efficiently process unlimited amounts of input data with capped active memory consumption.
-
- 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.
-
- Bidirectional integration with Zoho Books service.
- Introduced September, 2023 in 2.2 version.
- Implemented as configuration for the powerful COZYROC REST framework.
-
- Bidirectional integration with Zoho Campaigns service.
- Introduced February, 2024 in 2.2 version.
- Implemented as configuration for the powerful COZYROC REST framework.
-
- Bidirectional integration with Zoho Sheet service.
- Introduced January, 2022 in 2.1 version.
- Implemented as configuration for the powerful COZYROC REST framework.
- Intuitive support for composite objects.
-
ADO.NET Command Transformation
Execute SQL command for each row (like the standard OLE DB Command Transformation, but with ADO.NET).
-
AS2 Send Task
Send electronic documents (EDI, XML) using AS2 specification.
-
Checksum Transformation
Calculate CRC32 or SHA256 checksum for one or more input columns.
-
Column Compression Transformation
Compress or decompress columns.
-
Column Encryption Transformation
Encrypt or decrypt one or more input columns.
-
Column To Variable Destination
Store the values from the input columns into SSIS variable(s).
-
Conversion Transformation
Change data type, length, precision, scale of selected input columns.
-
Counter Transformation
Add a row counter column (e.g. can be used for surrogate keys).
-
Data Flow Enumerator Task
Process data flow result into control flow.
-
Data Record Source
Retrieve data from variable containing IDataRecord object.
-
Data Record To Variable Task
Extract field information from IDataRecord object into SSIS variables.
-
Data Verification Destination
Verify the output of an upstream component by comparing it against predefined data.
-
Dataset Destination
Load data in an in-memory ADO.NET DataSet object (similar to standard Recordset Destination).
-
Date Format Transformation
Reformat dates in text columns.
-
Date Source
Generate rows for a range of dates (by specifying a start date, an end date and an increment step).
-
Dictionary Destination
Loading input into a dictionary object.
-
Dynamics CRM Access Teams Destination
Add or remove a user to the auto created access team for the specified record.
-
Dynamics CRM Assign Destination
Assign record to a different owner.
-
Dynamics CRM Association Destination
Create associations between Dynamics CRM entities.
-
Dynamics CRM Attributes Source
Retrieve Dynamics CRM entity attributes metadata.
-
Dynamics CRM Audit Logs Query Transformation
Retrieve Dynamics CRM audit log records.
-
Dynamics CRM Bulk Delete Task
Perform Dynamics CRM bulk delete.
-
Dynamics CRM Convert Transformation
Convert Dynamics CRM entity record from one type to another.
-
Dynamics CRM Entity Changes Source
Retrieve Dynamics CRM entity changes records
-
Dynamics CRM Entity Source
Retrieve Dynamics CRM entity metadata.
-
Dynamics CRM Execute Workflow Destination
Execute Dynamics CRM workflows.
-
Dynamics CRM Incident State Destination
Update incident entity state.
-
Dynamics CRM Lookup Transformation
Perform lookup against Dynamics CRM.
-
Dynamics CRM Merge Destination
Merge two Dynamics CRM entity records into one
-
Dynamics CRM Opportunity State Destination
Update opportunity entity state.
-
Dynamics CRM OptionSet Transformation
Handle translation and creation of Dynamics CRM OptionSet values.
-
Dynamics CRM Qualify Lead Destination
Qualify a lead and create account, contact and opportunity records.
-
Dynamics CRM Quote To Sales Order Transformation
Convert Dynamics CRM quote to a sales order.
-
Dynamics CRM Relationship Destination
Create Dynamics CRM relationships between entities.
-
Dynamics CRM Route Destination
Route Dynamics CRM entity record to a queue.
-
Dynamics CRM Team Members Destination
Establish team members relationship.
-
Dynamics CRM User Access Destination
Establish user access permissions to Dynamics CRM entities.
-
Error Description Transformation
Extract additional information (column names and error descriptions) for error outputs in a data flow.
-
Excel Copy Worksheet
Copy a worksheet from one Excel file into another.
-
Excel Refresh Task
Refresh Excel connections and pivot tables.
-
Execute Salesforce DML Destination
Executes anonymous Salesforce Apex DML code.
-
Execute Salesforce DML Task
Executes anonymous Salesforce Apex DML code.
-
File Checksum Task
Calculate MD5 or SHA1 checksum for a file.
-
File Exists Task
Check if a specified file exists.
-
File Info List Task
Manage a list of SSIS+ IFileInfo objects (i.e. remote files on FTP, SFTP, S3, etc.).
-
File Info Source
Generate rows from IFileInfo list (i.e. remote files on FTP, SFTP, S3, etc.).
-
File Properties Source
Generate rows from files properties.
-
File Watcher Task
Detect changes in a monitored folder.
-
Find And Replace Task
"Find" or "Find & Replace" in a text file or a stream.
-
FTP File Exists Task
Check if a remote file exists (via SFTP or FTPS).
-
FTPS Task
Demonstrate FTP over SSL (FTPS).
-
Geocode Transformation
Retrieve via Google Geocoding and cache coordinates for input addresses.
-
Get Analysis Services Object Property Task
Get Analysis Services object property.
-
Get Environment Variable Task
Retrieve environment variable.
-
Get File List Task
Get files list.
-
Get FTP File List Task
Retrieve a list of remote files on an FTP server.
-
HTTP Upload Download Task
Upload or download a file over HTTP.
-
IMAP Task
Provide management functions for IMAP email server.
-
Init Task
Demonstrate SSIS script initialization setup.
-
Join Column Transformation
Combine multiple rows into single data flow row.
-
JSON to Variables Task
Bulk extract elements from JSON document into SSIS variables.
-
JSON Transformation
Retrieve data from a text column, containing an array of objects in JSON, XML or other text format.
-
Levenshtein Distance Transformation
Calculate difference between two strings using Levenshtein Distance.
-
Mail Info List Task
Manage IMailInfo list.
-
Mail Info Source
Generate rows for a IMailInfo list.
- Mail Task
-
Map Replace Transformation
Perform find-and-replace using dictionary object.
-
Measure Duration Transformation
Measures the processing time of the pipeline it is attached to.
-
Merge Setup Transformation
Merge temporary stage table using SQL 2008 MERGE (Transact-SQL) statement.
-
Microsoft Dataverse Lookup Transformation
Perform lookup against Microsoft Dataverse.
-
NetSuite File Download
Script task to download a file from NetSuite File Cabinet
-
NetSuite File Upload
Script task to upload a file to NetSuite File Cabinet
-
NULL Transformation
Setting and replacement of NULL values in the input columns.
-
OData Source
Consume data from an OData feed (similar to the standard OData Source).
-
OFTP Task
Send and receive EDI documents via ODETTE protocol.
-
Oracle Destination
Bulk-load data in Oracle table.
-
Package Configuration Task
Customize an SSIS package externally via configuring its properties in an Excel sheet.
-
PayPal Transactions Source
Retrieve PayPal transactions information.
-
Power BI Report Export Task
Exports Power BI report.
-
Profiler Trace Source
Load profile trace information.
-
Range Dictionary Destination
Create custom-crafted IDictionary object with representation of "many to one" relationships.
-
RegEx Extract Transformation
Extract matching groups from a given regular expression and output them as column values.
-
RegEx Match Transformation
Split the input based on matching with provided regular expression.
-
Reorder Columns Transformation
Perform columns reorder.
-
REST CSV Source
Retrieve data from CSV File.
-
REST Web Service Request Task
Send a request to a REST API endpoint.
-
REST Web Service Request Transformation
Execute REST web service request for each data flow row.
-
Row Repeat Transformation
Asynchronously output replicated rows based on repeat count, provided in a column.
-
RSS Source
Load information from RSS feed.
-
Salesforce Bulk Result Transformation
Return Salesforce bulk-load batch information.
-
Salesforce Fields Source
Generate rows from the Salesforce object fields metadata.
-
Salesforce Get Deleted Source
Retrieve Salesforce object deleted record identifiers.
-
Salesforce Get Updated Source
Retrieve Salesforce object updated record identifiers.
-
Salesforce Lookup Transformation
Perform lookup against Salesforce objects.
-
Salesforce Object Source
Retrieve Salesforce objects metadata.
-
Secure Tunnel Task
Establish a secure tunnel using SSH protocol.
-
Send Mail Task
Send SMTP email (supports HTML messages and attachments).
-
SFTP Connection Exists Task
Check if an SFTP connection can be established.
-
Soundex Transformation
Create Soundex representation of input column.
-
Split Column Transformation
Split single rows into multiple data flow rows.
-
SQL Job Agent Task
Provide basic manipulation operations for SQL Agent Jobs.
-
Table Update Destination
Easier to use alternative of the standard OLE DB Command transformation for amending table records.
-
Test Data Source
Define tabular input data for testing purposes.
-
Time Zone Transformation
Convert date/time columns from one timezone to another.
-
Timer Task
Wait specified amount of seconds before continuing.
-
Transform XML Task
Transform an XML document using an XSLT file.
-
Trash Destination
Easily terminate a data flow path (as a development aid)
-
Trim Transformation
Trim input columns.
-
UncompressZ Task
Decompress data compressed with the unix "compress" utility (LZC, a LZW variant).
-
Variable to File Task
Write string Variable contents to a File.
-
WMI Source
Load data from Windows Management Information (WMI).
-
XPath Extract Transformation
Extract information from a column with XML documents, using provided XPath expressions.