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.
-
Learn More
- Bidirectional integration with ActiveCampaign service.
- Introduced January, 2020 in 2.0 version.
- Implemented as configuration for the powerful COZYROC REST framework.
-
Learn More
- US Postal Address parsing, correction and standardization.
- Introduced November, 2009 in 1.4 version.
- Parsed address parts: leading, street, number, suite, city, state, zip code.
- Optional feature to check address in USPS reference database with more than 120 million addresses.
- Intuitive user interface with fine-grained error control.
-
Learn More
- Bidirectional integration with Amazon Athena service.
- Introduced January, 2022 in 2.1 version.
- Implemented as configuration for the powerful COZYROC REST framework.
-
Learn More
- Support for Amazon DynamoDB service
- Introduced October, 2023 in 2.2 version.
- Implemented as configuration for the powerful COZYROC REST framework.
-
Learn More
- 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.
-
Learn More
- Bidirectional integration with Amazon Selling Partner service.
- Introduced July, 2023 in 2.2 version.
- Implemented as configuration for the powerful COZYROC REST framework.
-
Learn More
- Bidirectional integration with Microsoft Azure Queue Storage service.
- Introduced November, 2023 in 2.2 version.
- Implemented as configuration for the powerful COZYROC REST framework.
-
Learn More
- Connections with AMQP 1.0 servers (version 1.0).
- Support SASL SSL and SASL Plaintext security protocol types.
- Streamlined user interface.
-
Learn More
- Bidirectional integration with ESRI ArcGIS Feature service.
- Introduced January, 2017 in 1.7 version.
- Support OAuth2 token and anonymous authentication.
- Implemented as configuration for the powerful COZYROC REST framework.
- Intuitive support for composite objects (points, paths, rings, curvePaths, curveRings).
-
Learn More
- Introduced in January, 2024 in 2.2 version.
- Supports BER, CER and DER encoding.
- Supports an error output for redirecting problematic records
-
Learn More
- 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.
-
Learn More
- Bidirectional integration with Microsoft Azure Files service.
- Introduced January, 2024 in 2.2 version.
- Implemented as configuration for the powerful COZYROC REST framework.
-
Learn More
- Bidirectional integration with Microsoft Azure Queue Storage service.
- Introduced July, 2023 in 2.2 version.
- Implemented as configuration for the powerful COZYROC REST framework.
-
Learn More
- Bidirectional integration with Microsoft Azure Table service.
- Introduced January, 2022 in 2.1 version.
- Implemented as configuration for the powerful COZYROC REST framework.
-
Learn More
- Bidirectional integration with BigCommerce service.
- Introduced April, 2022 in 2.1 version.
- Implemented as configuration for the powerful COZYROC REST framework.
-
Learn More
- Bidirectional integration with Bloomerang service.
- Introduced May, 2021 in 2.1 version.
- Implemented as configuration for the powerful COZYROC REST framework.
-
Learn More
- 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.
-
Learn More
- Bidirectional integration with Canvas LMS service.
- Introduced July, 2023 in 2.2 version.
- Implemented as configuration for the powerful COZYROC REST framework.
-
Learn More
- Bidirectional integration with Capsule CRM service.
- Introduced February, 2022 in 2.1 version.
- Implemented as configuration for the powerful COZYROC REST framework.
-
Learn More
- Bidirectional integration with Constant Contact service.
- Introduced December, 2017 in 1.8 version.
- Implemented as configuration for the powerful COZYROC REST framework.
- Intuitive support for composite objects (attributes, addresses, activity, schedules, etc).
-
Learn More
- Exposes data from a data flow for in-memory read in another data flow.
- 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.
-
Learn More
- 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.
-
Learn More
- 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.
-
Learn More
- 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)
-
Learn More
- 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.
-
Learn More
- 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).
-
Learn More
- Bulk-load destination DB2 table component.
- Introduced June, 2008 in 1.3 version.
- 20x faster loading speed compared to OLE DB.
- IBM UniData® and UniVerse® data servers are not supported.
- User interface is based on the standard data flow destination component dialog.
-
Learn More
- 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.
-
Learn More
- Connections with Microsoft Windows AppFabric caching service.
- Introduced October, 2010 in 1.5 SR-1 version.
- Streamlined user interface.
-
Learn More
- Support for Dropbox service file management thru COZYROC File Transfer Task.
- Introduced January, 2017 in 1.7 version.
- Implemented as configuration for the powerful COZYROC REST framework.
-
Learn More
- Bidirectional adapters for Dynamics AX integration.
- Introduced October, 2010 in 1.5 SR-1 version.
- Based on Microsoft .NET Business Connector for Dynamics AX.
-
Learn More
- Connections with Microsoft Dynamics AX server.
- Introduced October, 2010 in 1.5 SR-1 version.
- Support Dynamics AX 2012, 2009, 4.0 systems.
- Streamlined user interface.
-
Learn More
- 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.
-
Learn More
- 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.
-
Learn More
- Bidirectional integration with Dynamics 365 Business Central service.
- Introduced January, 2022 in 2.1 version.
- Implemented as configuration for the powerful COZYROC REST framework.
-
Learn More
- Bidirectional adapters for Microsoft Dynamics 365/CRM integration.
- Introduced August, 2010 in 1.5 version.
- Uses only standard Dynamics CRM SOAP web services API.
- Unique reusable script technology for complimentary functionality and flexibility.
- Support Dynamics 365, Premise, Live, Hosted deployments.
- Support 2016, 2015, 2013, 2011, 4.0 and 3.0 systems.
-
Learn More
- 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.
-
Learn More
- 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.
-
Learn More
- 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.
-
Learn More
- Bidirectional adapters for Dynamics GP integration.
- Introduced July, 2012 in 1.6 version.
- Uses the standard Microsoft Dynamics GP web services API.
- Intuitive support for composite objects.
-
Learn More
- Connections with Dynamics GP web service.
- Introduced July, 2012 in 1.6 version.
- Streamlined user interface.
-
Learn More
- 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.
-
Learn More
- 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.
-
Learn More
- Bidirectional adapters for Dynamics NAV integration.
- Introduced July, 2012 in 1.6 version.
- Uses only standard Microsoft Dynamics NAV web services API.
-
Learn More
- Connections with Dynamics NAV web service.
- Introduced July, 2012 in 1.6 version.
- Streamlined user interface.
-
Learn More
- 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.
-
Learn More
- 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.
-
Learn More
- Configure settings for reading or generating EDI files
- Introduced November, 2018 in 1.9 version.
- Streamlined user interface.
-
Learn More
- 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.
-
Learn More
- Very fast reader of EDI format files. The component can reportedly process millions of segments in less than 30 minutes.
- Introduced July, 2008 in 1.3 version.
- EDI mapping setup is made in an XML configuration file.
- Since 1.9 has a custom editor and uses the newly introduced EDI Connection Manager
-
Learn More
- Bidirectional integration with Elasticsearch service.
- Introduced July, 2020 in 2.0 version.
- Implemented as configuration for the powerful COZYROC REST framework.
-
Learn More
- Bidirectional integration with Eventbrite service.
- Introduced May, 2021 in 2.1 version.
- Implemented as configuration for the powerful COZYROC REST framework.
-
Learn More
- 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.
-
Learn More
- 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.
-
Learn More
- Based on Excel Connection Manager.
- Introduced August, 2010 in 1.5 version.
- Support 64 bit execution.
- Intuitive user interface with fine-grained error control.
-
Learn More
- 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.
-
Learn More
- 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.
-
Learn More
- 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.
-
Learn More
-
Learn More
- Bidirectional integration with Fleet Complete service.
- Introduced January, 2017 in 1.7 version.
- Implemented as configuration for the powerful COZYROC REST framework.
- Intuitive support for composite objects (Sensors, Rules, Trip, GeoData, Routes, etc).
-
Learn More
- Bidirectional integration with FreshBooks service.
- Introduced December, 2017 in 1.8 version.
- Implemented as configuration for the powerful COZYROC REST framework.
- Intuitive support for composite objects (professions, addresses, groups, business_memberships, etc).
-
Learn More
- Bidirectional integration with Freshsales service.
- Introduced July, 2023 in 2.2 version.
- Implemented as configuration for the powerful COZYROC REST framework.
-
Learn More
- 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.
-
Learn More
- Bidirectional integration with Google Admin service.
- Introduced January, 2017 in 1.7 version.
- Implemented as configuration for the powerful COZYROC REST framework.
- Intuitive support for composite objects (domainAliases, applications, addresses, ims, etc).
-
Learn More
- 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.
-
Learn More
- Bidirectional integration with Google AppSheet.
- Introduced July, 2023 in 2.2 version.
- Implemented as configuration for the powerful COZYROC REST framework.
-
Learn More
- Bidirectional integration with Google BigQuery service.
- Introduced December, 2017 in 1.8 version.
- Implemented as configuration for the powerful COZYROC REST framework.
-
Learn More
- Bidirectional integration with Google Calendar service.
- Introduced January, 2017 in 1.7 version.
- Implemented as configuration for the powerful COZYROC REST framework.
- Intuitive support for composite objects (attachments, attendees, etc).
-
Learn More
- Bidirectional integration with Google Cloud Monitoring service.
- Introduced November, 2023 in 2.2 version.
- Implemented as configuration for the powerful COZYROC REST framework.
-
Learn More
- 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.
-
Learn More
- Bidirectional integration with Google Dataplex service.
- Introduced October, 2023 in 2.2 version.
- Implemented as configuration for the powerful COZYROC REST framework.
-
Learn More
- Support for Google Drive service file management thru COZYROC File Transfer Task.
- Introduced January, 2017 in 1.7 version.
- Implemented as configuration for the powerful COZYROC REST framework.
-
Learn More
- Bidirectional integration with Google Forms service.
- Introduced July, 2023 in 2.2 version.
- Implemented as configuration for the powerful COZYROC REST framework.
-
Learn More
- Bidirectional integration with Google Maps service.
- Introduced January, 2022 in 2.1 version.
- Implemented as configuration for the powerful COZYROC REST framework.
-
Learn More
- Bidirectional integration with Google People service.
- Introduced January, 2022 in 2.1 version.
- Implemented as configuration for the powerful COZYROC REST framework.
-
Learn More
- Bidirectional integration with Google Search Console service.
- Introduced January, 2024 in 2.2 version.
- Implemented as configuration for the powerful COZYROC REST framework.
-
Learn More
- Bidirectional integration with Google Sheets service.
- Introduced January, 2017 in 1.7 version.
- Implemented as configuration for the powerful COZYROC REST framework.
- Intuitive support for composite objects.
-
Learn More
- Bidirectional integration with Google Tasks service.
- Introduced January, 2017 in 1.7 version.
- Implemented as configuration for the powerful COZYROC REST framework.
-
Learn More
- Bidirectional integration with GoToWebinar service.
- Introduced December, 2017 in 1.8 version.
- Implemented as configuration for the powerful COZYROC REST framework.
- Intuitive support for composite objects (times, attendance, answers, polls, etc).
-
Learn More
- Bidirectional integration with Gravity Forms.
- Introduced November, 2023 in 2.2 version.
- Implemented as configuration for the powerful COZYROC REST framework.
-
Learn More
- Bidirectional integration with HubSpot service.
- Introduced January, 2017 in 1.7 version.
- Implemented as configuration for the powerful COZYROC REST framework.
- Support for file management thru COZYROC File Transfer Task.
-
Learn More
- Connections with IMAP mail server.
- Introduced August, 2010 in 1.5 version.
- Support secure connections.
- Streamlined user interface.
-
Learn More
- Bulk-load destination Informix table component.
- Introduced June, 2008 in 1.3 version.
- 6-8x faster loading speed compared to OLE DB.
- Support for IBM Informix® Dynamic Server, Version 11.10 or later.
- User interface is based on the standard data flow destination component dialog.
-
Learn More
- Bidirectional integration with Infusionsoft service.
- Introduced May, 2021 in 2.1 version.
- Implemented as configuration for the powerful COZYROC REST framework.
-
Learn More
- 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.
-
Learn More
- Bidirectional communication with Jabber clients - sending and receiving of messages.
- Introduced July, 2008 in 1.3 version.
- Based on Jabber Connection Manager.
- Support text or HTML message sending.
- Streamlined user interface.
-
Learn More
- 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
-
Learn More
- 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.
-
Learn More
- 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.
-
Learn More
- Bidirectional integration with JIRA service.
- Introduced December, 2017 in 1.8 version.
- Support Basic and OAuth token authentication.
- Implemented as configuration for the powerful COZYROC REST framework.
- Intuitive support for composite objects (notifications, associatedItems, transitions, histories, comments, etc).
-
Learn More
- 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
-
Learn More
- 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.
-
Learn More
- Support multiple JSON sources - variable, file and text
- Support reading of nested JSON documents in arrays
- Introduced in December 2019 in 2.0 version.
-
Learn More
- 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.
-
Learn More
- Bidirectional adapters for LDAP / Active Directory integration.
- Introduced December, 2017 in 1.8 version.
- Available on the market since December, 2017.
- Support processing of all available LDAP objects.
-
Learn More
- Connections with LDAP service.
- Streamlined user interface.
-
Learn More
- Based on LDAP Connection Manager.
- Insert data into LDAP object.
- User interface is based on the standard data flow destination component dialog.
-
Learn More
- Based on LDAP Connection Manager.
- Read from LDAP object.
- User interface is based on the standard data flow source component dialog.
-
Learn More
- 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.
-
Learn More
- 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.
-
Learn More
- 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.
-
Learn More
- Connections with SugarCRM web service.
- Introduced July, 2012 in 1.6 version.
- Streamlined user interface.
-
Learn More
- 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.
-
Learn More
- Based on SugarCRM Connection Manager.
- Introduced July, 2012 in 1.6 version.
- User interface is based on the standard data flow source component dialog.
-
Learn More
- Support multiple lookup definitions in one place.
- Introduced November, 2009 in 1.4 version.
- Support OLEDB, ADO, ADO.NET or package variable as a source.
- Support Distributed Cache 1.5 SR-1.
- Support definition for handling NULL and No Match situations.
- Intuitive user interface.
-
Learn More
- Bidirectional integration with Marketo service.
- Introduced January, 2017 in 1.7 version.
- Implemented as configuration for the powerful COZYROC REST framework.
- Support for file management thru COZYROC File Transfer Task.
-
Learn More
- Support for sending and receiving of queue messages.
- Introduced May, 2021 in 2.1 version.
- Support for:
-
Learn More
- 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.
-
Learn More
- Bidirectional integration with Microsoft Graph service.
- Introduced May, 2021 in 2.1 version.
- Implemented as configuration for the powerful COZYROC REST framework.
-
Learn More
- 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.
-
Learn More
- Connectivity with MongoDB document databases
- Streamlined user interface.
-
Learn More
- 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.
-
Learn More
- Based on MongoDB Connection Manager.
- Support read of nested documents in arrays
- User interface is based on the standard data flow source component dialog.
-
Learn More
- Bidirectional adapters for NetSuite integration.
- Introduced July, 2012 in 1.6 version.
- Support automatic renewal of expired sessions during processing.
- Intuitive support for composite objects.
-
Learn More
- Connections with NetSuite web service.
- Introduced July, 2012 in 1.6 version.
- Streamlined user interface.
-
Learn More
- 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.
-
Learn More
- 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.
-
Learn More
- 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.
-
Learn More
- Support regular and bulk ODBC insertion.
- Introduced November, 2009 in 1.4 version.
- Based on ODBC Connection Manager.
- Support 32bit and 64bit ODBC drivers.
- Support redirection of incorrect rows to error output.
- User interface is based on the standard data flow destination component dialog.
-
Learn More
- Connectivity with ODETTE/OFTP2 servers.
- Introduced March, 2022 in 2.1 version.
- Support secure connections.
- Streamlined user interface.
-
Learn More
- 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.
-
Learn More
- Bidirectional adapters for OpenAir integration.
- Introduced July, 2012 in 1.6 version.
- Based on standard OpenAir SOAP web services API.
-
Learn More
- Connections with OpenAir web service.
- Introduced July, 2012 in 1.6 version.
- Streamlined user interface.
-
Learn More
- 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.
-
Learn More
- Based on OpenAir Connection Manager.
- Introduced July, 2012 in 1.6 version.
- User interface is based on the standard data flow source component dialog.
-
Learn More
- Support for file encryption, decryption, signature creation and verification.
- Introduced June, 2008 in 1.3 version.
- Public key cryptography based on OpenPGP standard.
- Support for input and output data streaming, without a need for temporary storage.
- Streamlined user interface.
-
Learn More
- 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.
-
Learn More
- Bulk-load destination Oracle table component.
- Introduced June, 2008 in 1.3 version.
- 10-30x faster loading speed compared to OLE DB.
- Support for Oracle 9i release 2, 10g release 1, 10g release 2, and 11g release 1 databases.
- User interface is based on the standard data flow destination component dialog.
-
Learn More
- Bidirectional integration with Oracle Eloqua service.
- Introduced July, 2023 in 2.2 version.
- Implemented as configuration for the powerful COZYROC REST framework.
-
Learn More
- Improves loop execution time dramatically by executing multiple Foreach loop iterations concurrently.
- Introduced August, 2010 in 1.5 version.
- Based on Package Connection Manager.
- Support both dynamic variables and dynamic connection managers.
- Streamlined user interface.
-
Learn More
- 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.
-
Learn More
- Support generating files in Apache Parquet format.
- Introduced January, 2022 in 2.1 version.
- Support writing nested objects in arrays.
-
Learn More
- Support reading Apache Parquet file format.
- Support reading of nested objects in arrays.
- Introduced in January, 2022 in 2.1 version.
-
Learn More
- Introduced January, 2022 in 2.1 version.
- Support reading of tabular data from PDF files
- Intuitive user interface with fine-grained error control.
-
Learn More
- Connections with POP3 mail server.
- Introduced August, 2010 in 1.5 version.
- Support secure connections.
- Streamlined user interface.
-
Learn More
- 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.
-
Learn More
- Bidirectional integration with PrestaShop service.
- Introduced October, 2023 in 2.2 version.
- Implemented as configuration for the powerful COZYROC REST framework.
-
Learn More
- Support reading and writing of QlikView QVX files.
- Introduced July, 2016 in 1.7 version.
- No dependence on any other third-party technology or component.
-
Learn More
- Creation of QlikView QVX files.
- Introduced January, 2017 in 1.7 version.
- User interface is based on the standard data flow destination component dialog.
-
Learn More
- Read from QlikView QVX files.
- Introduced January, 2017 in 1.7 version.
- User interface is based on the standard data flow source component dialog.
-
Learn More
- Bidirectional adapters for QuickBooks Desktop integration.
- Introduced July, 2012 in 1.6 version.
- Intuitive support for composite objects.
-
Learn More
- Connections with QuickBooks web service.
- Introduced July, 2012 in 1.6 version.
- Support for QuickBooks Desktop.
- Streamlined user interface.
-
Learn More
- 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.
-
Learn More
- Bidirectional integration with QuickBooks Online service.
- Introduced January, 2022 in 2.1 version.
- Implemented as configuration for the powerful COZYROC REST framework.
-
Learn More
- 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.
-
Learn More
- 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.
-
Learn More
- 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.
-
Learn More
- 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.
-
Learn More
- Connections with REST web services.
- Introduced January, 2017 in 1.7 version.
- Optional support for proxy.
- Optional retry for particular errors.
- Streamlined user interface.
-
Learn More
- Based on REST Connection Manager.
- Introduced January, 2017 in 1.7 version.
- Intuitive user interface with fine-grained error control.
-
Learn More
- Support for NetSuite REST service.
- Introduced July, 2023 in 2.2 version.
- Implemented as configuration for the powerful COZYROC REST framework.
-
Learn More
- Based on REST Connection Manager.
- Introduced January, 2017 in 1.7 version.
- Intuitive user interface with fine-grained error control.
-
Learn More
- Bidirectional adapters for Sage / SalesLogix integration.
- Introduced July, 2012 in 1.6 version.
- Based on the standard Sage SData SOAP web services API.
- Intuitive support for composite objects.
-
Learn More
- Bidirectional integration with Sage 300 ERP service.
- Introduced May, 2021 in 2.1 version.
- Implemented as configuration for the powerful COZYROC REST framework.
-
Learn More
- Bidirectional integration with Sage Business Cloud Accounting service.
- Introduced September, 2020 in 2.0 version.
- Implemented as configuration for the powerful COZYROC REST framework.
-
Learn More
- Connections with Sage SData web service.
- Introduced July, 2012 in 1.6 version.
- Streamlined user interface.
-
Learn More
- 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.
-
Learn More
- 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.
-
Learn More
- 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.
-
Learn More
- Bidirectional adapters for Salesforce integration.
- Introduced November, 2009 in 1.4 version.
- Unique reusable script technology for complimentary functionality and flexibility.
- Support both regular SOAP and bulk REST API.
-
Learn More
- Connections with Salesforce service.
- Introduced October, 2009 in 1.4 version.
- Streamlined user interface.
-
Learn More
- 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.
-
Learn More
- 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.
-
Learn More
- 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.
-
Learn More
- Support reading and writing of SAS sas7bdat files.
- Introduced May, 2011 in 1.5 SR-2 version.
- No dependence on any other third-party technology or component.
-
Learn More
- Premium component licensed separately from SSIS+ library.
- 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.
-
Learn More
- 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.
-
Learn More
- Secure copying of files with remote SSH server.
- Introduced November, 2009 in 1.4 version.
- Based on SSH Connection Manager.
- Streamlined user interface.
-
Learn More
Execute SQL command for each row (like the standard OLE DB Command Transformation, but with ADO.NET).
-
Learn More
Send electronic documents (EDI, XML) using AS2 specification.
-
Learn More
Calculate CRC32 or SHA256 checksum for one or more input columns.
-
Learn More
Compress or decompress columns.
-
Learn More
Encrypt or decrypt one or more input columns.
-
Learn More
Store the values from the input columns into SSIS variable(s).
-
Learn More
- Extension of Microsoft SSIS Script Component, meaning you already have the skills to use it.
- Introduced November, 2009 in 1.4 version.
- Greater reusability and easier maintenance of SSIS scripts.
- Customizable script user interface and setup.
- SSIS Script export, import or linking to.
- Keep your script code separate from your package and have easier time tracking changes in your source control system.
- Requires SQL Server 2005 SP2 or later.
- Reusable scripts and samples from the public repository.
-
Learn More
Change data type, length, precision, scale of selected input columns.
-
Learn More
Add a row counter column (e.g. can be used for surrogate keys).
-
Learn More
Process data flow result into control flow.
-
Learn More
Retrieve data from variable containing IDataRecord object.
-
Learn More
Extract field information from IDataRecord object into SSIS variables.
-
Learn More
Verify the output of an upstream component by comparing it against predefined data.
-
Learn More
Load data in an in-memory ADO.NET DataSet object (similar to standard Recordset Destination).
-
Learn More
Reformat dates in text columns.
-
Learn More
Generate rows for a range of dates (by specifying a start date, an end date and an increment step).
-
Learn More
Loading input into a dictionary object.
-
Learn More
Add or remove a user to the auto created access team for the specified record.
-
Learn More
Assign record to a different owner.
-
Learn More
Create associations between Dynamics CRM entities.
-
Learn More
Retrieve Dynamics CRM entity attributes metadata.
-
Learn More
Retrieve Dynamics CRM audit log records.
-
Learn More
Perform Dynamics CRM bulk delete.
-
Learn More
Convert Dynamics CRM entity record from one type to another.
-
Learn More
Retrieve Dynamics CRM entity changes records
-
Learn More
Retrieve Dynamics CRM entity metadata.
-
Learn More
Execute Dynamics CRM workflows.
-
Learn More
Update incident entity state.
-
Learn More
Perform lookup against Dynamics CRM.
-
Learn More
Merge two Dynamics CRM entity records into one
-
Learn More
Update opportunity entity state.
-
Learn More
Handle translation and creation of Dynamics CRM OptionSet values.
-
Learn More
Qualify a lead and create account, contact and opportunity records.
-
Learn More
Convert Dynamics CRM quote to a sales order.
-
Learn More
Create Dynamics CRM relationships between entities.
-
Learn More
Route Dynamics CRM entity record to a queue.
-
Learn More
Establish team members relationship.
-
Learn More
Establish user access permissions to Dynamics CRM entities.
-
Learn More
Extract additional information (column names and error descriptions) for error outputs in a data flow.
-
Learn More
Copy a worksheet from one Excel file into another.
-
Learn More
Refresh Excel connections and pivot tables.
-
Learn More
Executes anonymous Salesforce Apex DML code.
-
Learn More
Executes anonymous Salesforce Apex DML code.
-
Learn More
Calculate MD5 or SHA1 checksum for a file.
-
Learn More
Check if a specified file exists.
-
Learn More
Manage a list of SSIS+ IFileInfo objects (i.e. remote files on FTP, SFTP, S3, etc.).
-
Learn More
Generate rows from IFileInfo list (i.e. remote files on FTP, SFTP, S3, etc.).
-
Learn More
Generate rows from files properties.
-
Learn More
Detect changes in a monitored folder.
-
Learn More
"Find" or "Find & Replace" in a text file or a stream.
-
Learn More
Check if a remote file exists (via SFTP or FTPS).
-
Learn More
Demonstrate FTP over SSL (FTPS).
-
Learn More
Retrieve via Google Geocoding and cache coordinates for input addresses.
-
Learn More
Get Analysis Services object property.
-
Learn More
Retrieve environment variable.
-
Learn More
Get files list.
-
Learn More
Retrieve a list of remote files on an FTP server.
-
Learn More
Upload or download a file over HTTP.
-
Learn More
Provide management functions for IMAP email server.
-
Learn More
Demonstrate SSIS script initialization setup.
-
Learn More
Combine multiple rows into single data flow row.
-
Learn More
Bulk extract elements from JSON document into SSIS variables.
-
Learn More
Retrieve data from a text column, containing an array of objects in JSON, XML or other text format.
-
Learn More
Calculate difference between two strings using Levenshtein Distance.
-
Learn More
Manage IMailInfo list.
-
Learn More
Generate rows for a IMailInfo list.
-
Learn More
Perform find-and-replace using dictionary object.
-
Learn More
Measures the processing time of the pipeline it is attached to.
-
Learn More
Merge temporary stage table using SQL 2008 MERGE (Transact-SQL) statement.
-
Learn More
Perform lookup against Microsoft Dataverse.
-
Learn More
Script task to download a file from NetSuite File Cabinet
-
Learn More
Script task to upload a file to NetSuite File Cabinet
-
Learn More
Setting and replacement of NULL values in the input columns.
-
Learn More
Consume data from an OData feed (similar to the standard OData Source).
-
Learn More
Send and receive EDI documents via ODETTE protocol.
-
Learn More
Bulk-load data in Oracle table.
-
Learn More
Customize an SSIS package externally via configuring its properties in an Excel sheet.
-
Learn More
Retrieve PayPal transactions information.
-
Learn More
Exports Power BI report.
-
Learn More
Load profile trace information.
-
Learn More
Create custom-crafted IDictionary object with representation of "many to one" relationships.
-
Learn More
Extract matching groups from a given regular expression and output them as column values.
-
Learn More
Split the input based on matching with provided regular expression.
-
Learn More
Perform columns reorder.
-
Learn More
Retrieve data from CSV File.
-
Learn More
Send a request to a REST API endpoint.
-
Learn More
Execute REST web service request for each data flow row.
-
Learn More
Asynchronously output replicated rows based on repeat count, provided in a column.
-
Learn More
Load information from RSS feed.
-
Learn More
Return Salesforce bulk-load batch information.
-
Learn More
Generate rows from the Salesforce object fields metadata.
-
Learn More
Retrieve Salesforce object deleted record identifiers.
-
Learn More
Retrieve Salesforce object updated record identifiers.
-
Learn More
Perform lookup against Salesforce objects.
-
Learn More
Retrieve Salesforce objects metadata.
-
Learn More
Establish a secure tunnel using SSH protocol.
-
Learn More
Send SMTP email (supports HTML messages and attachments).
-
Learn More
Check if an SFTP connection can be established.
-
Learn More
Create Soundex representation of input column.
-
Learn More
Split single rows into multiple data flow rows.
-
Learn More
Provide basic manipulation operations for SQL Agent Jobs.
-
Learn More
Easier to use alternative of the standard OLE DB Command transformation for amending table records.
-
Learn More
- Extension of Microsoft SSIS Script Task, meaning you already have the skills to use it.
- Greater reusability and easier maintenance of SSIS scripts.
- Customizable script user interface and setup.
- SSIS Script export, import or linking to.
- Keep your script code separate from your package and have easier time tracking changes in your source control system.
- Requires SQL Server 2005 SP2 or later.
- Reusable scripts and samples from the public repository.
-
Learn More
Define tabular input data for testing purposes.
-
Learn More
Convert date/time columns from one timezone to another.
-
Learn More
Wait specified amount of seconds before continuing.
-
Learn More
Transform an XML document using an XSLT file.
-
Learn More
Easily terminate a data flow path (as a development aid)
-
Learn More
Trim input columns.
-
Learn More
Decompress data compressed with the unix "compress" utility (LZC, a LZW variant).
-
Learn More
Write string Variable contents to a File.
-
Learn More
Load data from Windows Management Information (WMI).
-
Learn More
Extract information from a column with XML documents, using provided XPath expressions.
-
Learn More
- 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.
-
Learn More
- Bidirectional integration with ServiceNow service.
- Introduced January, 2017 in 1.7 version.
- Implemented as configuration for the powerful COZYROC REST framework.
- Support reading from both tables and views.
-
Learn More
- Bidirectional integration with ServiceTitan service.
- Introduced July, 2023 in 2.2 version.
- Implemented as configuration for the powerful COZYROC REST framework.
-
Learn More
- 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.
-
Learn More
- Bidirectional adapters for SharePoint integration.
- Introduced August, 2010 in 1.5 version.
- Uses standard SharePoint SOAP web services.
- Support Office 365, Premise deployments.
- Support SharePoint 2019, 2016, 2013, 2010, 2007.
-
Learn More
- Connections with Microsoft SharePoint service.
- Introduced August, 2010 in 1.5 version.
- Streamlined user interface.
-
Learn More
- 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.
-
Learn More
- 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.
-
Learn More
- Bidirectional integration with SimplyDigi service.
- Introduced January, 2017 in 1.7 version.
- Implemented as configuration for the powerful COZYROC REST framework.
-
Learn More
- Bidirectional integration with Smartsheet service.
- Introduced December, 2017 in 1.8 version.
- Implemented as configuration for the powerful COZYROC REST framework.
-
Learn More
- Connections with SMTP mail server.
- Introduced August, 2010 in 1.5 version.
- Support secure connections.
- Streamlined user interface.
-
Learn More
- Capable of handling millions of rows with ease.
- Introduced September, 2018 in 1.9 version.
- Intuitive user interface.
-
Learn More
- 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.
-
Learn More
- 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.
-
Learn More
- Support creation of stream, opening of file stream, reading from stream and writing to stream.
- Introduced July, 2008 in 1.3 version.
- Support in-memory transfer stream, allowing simultaneous writing of data in one process and reading of the same data in another process.
- Streamlined user interface.
-
Learn More
- Bidirectional integration with SurveyMonkey service.
- Introduced December, 2017 in 1.8 version.
- Implemented as configuration for the powerful COZYROC REST framework.
- Intuitive support for composite objects (rows, cols, choices, questions, pages, etc).
-
Learn More
- Bulk-load destination Sybase table component.
- Introduced January, 2013 in 1.6 SR-1 version.
- 20x faster loading speed compared to OLE DB.
- Requires Adaptive Server Enterprise version 15.7.
- User interface is based on the standard data flow destination component dialog.
-
Learn More
- Support reading and writing of Tableau Data Extract (TDE) files.
- Support for Tableau Server thru the available REST API.
-
Learn More
- Bidirectional integration with Tableau Server.
- Introduced December, 2019 in 1.9 version.
- Implemented as configuration for the powerful COZYROC REST framework.
-
Learn More
- 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.
-
Learn More
- Generation on arbitrary text columns based on Apache Velocity template.
- Introduced July, 2012 in 1.6 version.
- Support multiple template column definitions.
- Intuitive user interface.
-
Learn More
- Generation of arbitrary text documents like CSV, HTML, XML, EDI and many more.
- Introduced November, 2009 in 1.4 version.
- Streaming document generation, meaning low memory requirements and unlimited document generation.
- Template engine based on Apache Velocity.
- User interface includes syntax-highlighting editor and template-testing tools.
-
Learn More
- 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.
-
Learn More
- 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.
-
Learn More
- Fast read from Teradata table.
- Introduced January, 2017 in 1.7 version.
- User interface is based on the standard data flow source component dialog.
-
Learn More
- 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.
-
Learn More
- 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.
-
Learn More
- Compression and decompression of Zip, GZip, BZip2, Unix, Tar archives.
- Introduced July, 2007 in 1.1 version.
- Automatically switches to Zip64 format, if it is required.
- Support for input and output data streaming, without a need for temporary storage.
- Support extraction from multi-volume Zip archive (1.3 SR-3).
- Support AES encryption and decryption (1.5 SR-2).
- Streamlined user interface.
-
Learn More
- Bidirectional integration with Zoho Books service.
- Introduced September, 2023 in 2.2 version.
- Implemented as configuration for the powerful COZYROC REST framework.
-
Learn More
- Bidirectional integration with Zoho Campaigns service.
- Introduced February, 2024 in 2.2 version.
- Implemented as configuration for the powerful COZYROC REST framework.
-
Learn More
- 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.
These are legacy scripts which are no longer enhanced or maintained. Starting from 1.9 version, you should only use the scripts found in the Script tab.