Skip to main content
TrustRadius
COZYROC

COZYROC

Overview

What is COZYROC?

COZYROC SSIS+ is a suite of 240+ advanced components for developing ETL solutions with Microsoft SQL Server Integration Services. The vendor states that COZYROC is an easy-to-use, code-free library of tasks, components and reusable scripts that aim to significantly cut…

Read more
Recent Reviews

TrustRadius Insights

COZYROC SSIS+ provides a range of functionalities that make it a valuable tool for data integration projects. Users and reviewers have …
Continue reading
TrustRadius Insights
TrustRadius Insights

COZYROC isn't the answer

1 out of 10
June 20, 2022
I purchased the $1.2k COZYROC subscription and I regret it, I also paid them an extra 2.7K to configure EDI XML files. I think they used …
Continue reading

a Good SSIS toolbox

6 out of 10
May 01, 2021
Incentivized
COZYROC components are being used by our IT department, to build solutions that are used across the whole organization. They resolve the …
Continue reading

Great SSIS Toolbox

9 out of 10
October 07, 2020
Incentivized
We use COZYROC components inside our IT department. We use these SSIS components in a lot of our ETL Projects. The main components we use …
Continue reading
Read all reviews

Popular Features

View all 7 features
  • Simple transformations (8)
    2.2
    22%
  • Connect to traditional data sources (8)
    2.1
    21%
  • Connecto to Big Data and NoSQL (5)
    1.1
    11%
  • Complex transformations (6)
    1.0
    10%
Return to navigation

Pricing

View all pricing

COZYROC Excel Add-in for SAS®

$199.95

On Premise
per year

COZYROC SSIS+ Premium Priority Support

$499.95

On Premise
per year

COZYROC SSIS+ Ultimate Subscription

$1,199

On Premise
per year

Entry-level set up fee?

  • No setup fee
For the latest information on pricing, visithttps://www.cozyroc.com/purchase

Offerings

  • Free Trial
  • Free/Freemium Version
  • Premium Consulting/Integration Services
Return to navigation

Features

Data Source Connection

Ability to connect to multiple data sources

1.6
Avg 8.2

Data Transformations

Data transformations include calculations, search and replace, data normalization and data parsing

1.6
Avg 8.4

Data Modeling

A data model is a diagram or flowchart that illustrates the relationships between data

3.5
Avg 8.1
Return to navigation

Product Details

What is COZYROC?

COZYROC SSIS+ is a suite of 240+ advanced components for developing ETL solutions with Microsoft SQL Server Integration Services. The vendor states that COZYROC is an easy-to-use, code-free library of tasks, components and reusable scripts that aim to significantly cut development time and improve the execution speed of SSIS packages.

They further provide that COZYROC SSIS+ Components Suite has been successfully used by thousands of businesses in more than 140 countries around the world.

⭐ Downloadable COZYROC SSIS+ Components Suite
⭐ Free for test and development within Visual Studio
⭐ Support SQL Server 2005-2019 and ADFv2 IR

COZYROC Features

Data Source Connection Features

  • Supported: Connect to traditional data sources
  • Supported: Connecto to Big Data and NoSQL

Data Transformations Features

  • Supported: Simple transformations
  • Supported: Complex transformations

Data Modeling Features

  • Supported: Metadata management
  • Supported: Business rules and workflow

Additional Features

  • Supported: REST adapters for connection to cloud application
  • Supported: Connectivity for CRM, ERP, Accounting, Marketing, Analytics, e-Commerce, HR and other applications
  • Supported: Data flow task plus - Dynamic data flows
  • Supported: EDI format files processing
  • Supported: Secure file transfer protocol (SFTP, FTPS)
  • Supported: Secure advanced email support (SMTP, IMAP, POP3, Exchange)
  • Supported: 64bit Microsoft Excel adapters
  • Supported: Zip, GZip, BZip2, Tar compression and decompression
  • Supported: Generate any text documents (e.g. XML, HTML, JSON) via Apache Velocity templates

COZYROC Screenshots

Screenshot of COZYROC is the leading company providing reliable SSIS components for Data Integration and fast and easy ETL.Screenshot of COZYROC SSIS+ Components Suite COZYROC SSIS+ is a comprehensive suite of 240+ advanced components for developing ETL solutions with Microsoft SQL Server Integration Services.

COZYROC Video

COZYROC Integrations

COZYROC Competitors

COZYROC Technical Details

Deployment TypesOn-premise
Operating SystemsWindows, Azure
Mobile ApplicationNo

Frequently Asked Questions

Boomi, Redgate SQL Toolbelt Essentials, and /n software IPWorks are common alternatives for COZYROC.

Reviewers rate Simple transformations highest, with a score of 2.2.

The most common users of COZYROC are from Enterprises (1,001+ employees).
Return to navigation

Comparisons

View all alternatives
Return to navigation

Reviews and Ratings

(13)

Community Insights

TrustRadius Insights are summaries of user sentiment data from TrustRadius reviews and, when necessary, 3rd-party data sources. Have feedback on this content? Let us know!

COZYROC SSIS+ provides a range of functionalities that make it a valuable tool for data integration projects. Users and reviewers have praised its ability to address specific needs and enhance ETL processes. One key use case is enabling Microsoft SSIS to work seamlessly as an ETL tool, even when connecting to a DB2 database. This allows users to consolidate their data from different sources efficiently. Additionally, the plugin offers extensive functionalities for various data-related projects, including file transfer, OpenPGP encryption, EDI source/destination, and REST source/destination. It has been particularly useful in connecting with Salesforce, SharePoint, and other platforms, providing smooth data integration and transfer.

The dynamic query capability of COZYROC SSIS+ with the Salesforce source task has been highly regarded by users. This feature allows for flexible querying and retrieving the required data directly from Salesforce, streamlining the ETL process. Another use case lies in resolving complex tasks in SQL Server Integration Services ETL that standard SSIS falls short on. With COZYROC SSIS+, users can overcome these limitations and accomplish more comprehensive data integration tasks.

Furthermore, COZYROC SSIS+ has found applications across different departments within organizations. For instance, the Data Engineering and Data Analytics department utilizes the tool to connect to customized Dynamics 365 instances for differential ELT processing. The IT department relies on COZYROC SSIS+ components to build solutions that benefit the entire organization. Moreover, this product has proven helpful for addressing various data connection needs related to CRM systems, LDAP servers, and SFTP servers.

Users have also appreciated the responsive support provided by COZYROC. The helpdesk support team is known for delivering lightning-fast responses and promptly resolving issues. Overall, COZYROC SSIS+ offers a robust solution for data integration projects, empowering users to overcome challenges and achieve efficient data workflows.

Users recommend considering this tool if you need to send or receive data from many 3rd party services from your SQL servers. They have found that it makes the process easier and faster. Additionally, they suggest taking a look at the integration capabilities and trying it out based on your requirements.

According to users, the documentation is easy to follow and helps you get up and running quickly. However, they mention that the documentation is sparse and that the tool can do a lot when used with Visual Studio.

One of the common recommendations is to try this product for dynamic mapping, especially if it aligns with your requirements.

Attribute Ratings

Reviews

(1-5 of 5)
Companies can't remove reviews or game the system. Here's why
December 07, 2021

Cozyroc SSIS+ makes Microsoft SSIS a proper ETL tool

Mika Itkonen | TrustRadius Reviewer
Mika Itkonen
Data Warehouse Analyst
TS-Yhtymä Oy (Newspapers, 501-1000 employees)
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Use Cases and Deployment Scope
About a year ago we were faced with a need to change ETL tools. We had been using IBM tools for a few decades and our plan was now to move to Microsoft SSIS. The first looks of SSIS made us feel that the product was lacking basic ETL functionality that we were used to. A lot of this was due to us having most of our source/destination databases outside of SQL Server, mainly DB2. I felt that SSIS is not really a good choice when having a DB2 destination database but there were other factors supporting the selection of SSIS so we went on to look for solutions that would enable SSIS to work in our case. This is where we found COZYROC SSIS+ to be a big asset that effectively allowed us to use SSIS as a proper ETL tool even though our main target is DB2.
Pros and Cons
  • Database Destination Component.
  • Support.
  • Rest components.
  • Documentation.
Likelihood to Recommend
The single most important use case for us is the Database Destination component. Nearly all ETL data flows usually have some sort of insert / update / delete database operation at the end and with all the new functionality added to Database Destination during the past year we can now use this single component to do 99,5% of all our inserts / updates / deletes and most importantly merge operations. The same functionality can be achieved using only standard Microsoft SSIS components, but it can be complicated or very slow (one row at a time). If I want to insert new rows and update existing rows to the DB2 table and to do it fast. Microsoft SSIS does not really offer me any components for that. I can of course use SQL to create a temp table, move data there, create indexes, use SQL again to run the actual insert / update, clear the temp tables and finally run statistics but it requires a lot of SQL knowledge and will end up needing 6-8 steps. With COZYROC's Database Destination component it is just 1 step and it is easy and fast.
Most Important Features
  • Database Destination component.
  • Support.
COZYROC Feature Ratings
Data Source Connection (2)
45%
4.5
Connect to traditional data sources
90%
9.0
Connecto to Big Data and NoSQL
N/A
N/A
Data Transformations (2)
50%
5.0
Simple transformations
100%
10.0
Complex transformations
N/A
N/A
Data Modeling (2)
N/A
N/A
Metadata management
N/A
N/A
Business rules and workflow
N/A
N/A
Data Governance
N/A
N/A
Return on Investment
  • Simplified data flows.
  • Faster data operations.
Alternatives Considered
We tested several other SSIS add-on packages as well. Only a few had DB2 support. And from those few COZYROC's support was the most responsive and helpful. They practically added the functionality we needed if it was not already there.
Support Rating
9
Support is fast and after they understand our needs they are willing to implement new features.
Premium Support
No. We have only normal support.
Bug Resolution
Yes
All bugs reported have been fixed.
Exceptional Examples of COZYROC Support
A few times I have suggested improvements to components and after support has understood my use cases they have been very helpfull and went on to develop their product ahead in order for it to work even better for our needs.
October 07, 2020

Great SSIS Toolbox

Verified User
Manager in Information Technology
Business Supplies & Equipment Company, 1001-5000 employees
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Use Cases and Deployment Scope
We use COZYROC components inside our IT department. We use these SSIS components in a lot of our ETL Projects. The main components we use are the CRM Dynamics connector, SharePoint lists connector, sftp connector, and so on. With this set of SSIS components, we are able to download all incidents in our CRM cloud database and store them into our enterprise databases.
Pros and Cons
  • CRM Dynamics connection
  • Sharepoint list connector
  • SFTP component
  • Download performance for CRM connectory
  • Easier configuration of the components
  • Getting information about component version (I have to see the folder installation to check it)
Likelihood to Recommend
COZYROC is well suited for Microsoft CRM Dynamics connections and information download. It is also good for Microsoft SharePoint lists downloads and sftp component usage. It's easy to install and to use in our SQL server integration services project and ETL. It's easy to develop and easy to maintain.
COZYROC Feature Ratings
Data Source Connection (2)
95%
9.5
Connect to traditional data sources
100%
10.0
Connecto to Big Data and NoSQL
90%
9.0
Data Transformations (2)
80%
8.0
Simple transformations
80%
8.0
Complex transformations
80%
8.0
Data Modeling (2)
80%
8.0
Metadata management
80%
8.0
Business rules and workflow
80%
8.0
Data Governance
N/A
N/A
Alternatives Considered
Good product, affordable and efficient customer service for a good price.
Support Rating
10
Fast and efficient customer service.
Usability
9
Easy to use and easy to implement into ETL solutions with Microsoft SQL Server Integration Services.
Other Software Used
April 08, 2020

Good product and fantastic support

Venkata Ramana Potluri | TrustRadius Reviewer
Venkata Ramana Potluri
Database Analyst
Victorian Building Authority (Government Administration, 201-500 employees)
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Use Cases and Deployment Scope
We use COZYROC with Salesforce source task and connection, Sharepoint file transfer and connection tasks. They work fantastic. Above all, their helpdesk support responds at lightning speed. The dynamic query capability with the Salesforce source task is very helpful.
Pros and Cons
  • Dynamic SOQL is very advantageous with Salesforce source task.
  • Connecting to SharePoint is simple and seamless.
  • Script Component Plus is also a very good task that we can do a lot through, that what we can't do with Script Task.
  • Looking for Office 365 API connector and source task.
  • Looking for Share Connection with multifactor login.
Likelihood to Recommend
We are getting Salesforce data seamlessly with no troubles.
COZYROC Feature Ratings
Data Source Connection (2)
45%
4.5
Connect to traditional data sources
90%
9.0
Connecto to Big Data and NoSQL
N/A
N/A
Data Transformations (2)
90%
9.0
Simple transformations
90%
9.0
Complex transformations
90%
9.0
Data Modeling (5)
18%
1.8
Data model creation
N/A
N/A
Metadata management
N/A
N/A
Business rules and workflow
N/A
N/A
Collaboration
N/A
N/A
Testing and debugging
90%
9.0
Data Governance (2)
N/A
N/A
Integration with data quality tools
N/A
N/A
Integration with MDM tools
N/A
N/A
Return on Investment
  • Good ROI
Support Rating
10
Support responds at lightning speed!
February 04, 2020

Experience with COZYROC and their support

Verified User
Employee in Information Technology
Computer Software Company, 1001-5000 employees
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Use Cases and Deployment Scope
COZYROC is being used as an addon of our ETL processes across our backend database platforms in one of our products. It helps us go beyond the limitations of original Microsoft SSIS tools so we are able to build a lot more dynamic processes and data with greater usability. They definitely enhance the SSIS a lot and have all the features we need at a relatively small cost.

They also provide good adaptability so we can easily add and remove their addons without going through a lengthy migration process as long as you have been using SSIS. They have good support that is responsive and fixes our issues quickly.
Pros and Cons
  • A large selections of destinations like Amazon S3 or Processed Excel output that help us better fulfill the need of our clients
  • Dynamic columns queries and customizable parallel processing for data flow tasks
  • S3 widget's wording is somehow confusing. I wish they would be more consistent with Amazon wording
  • More examples of complicated and combined usage on website
Likelihood to Recommend
When you are working in an SSIS environment and you are thinking of doing something the original tools from toolbox can't implement, definitely try out CozyRoc. It should be able to allow you to a lot of things that are pretty common but very difficult or impossible to implement with only original SSIS. They also keep up with the new tech stack like Amazon S3. Their widgets would also allow you to implement a more sophisticated process with greater performance.
COZYROC Feature Ratings
Data Source Connection (2)
95%
9.5
Connect to traditional data sources
100%
10.0
Connecto to Big Data and NoSQL
90%
9.0
Data Transformations (2)
100%
10.0
Simple transformations
100%
10.0
Complex transformations
100%
10.0
Data Modeling (5)
N/A
N/A
Data model creation
N/A
N/A
Metadata management
N/A
N/A
Business rules and workflow
N/A
N/A
Collaboration
N/A
N/A
Testing and debugging
N/A
N/A
Data Governance (2)
N/A
N/A
Integration with data quality tools
N/A
N/A
Integration with MDM tools
N/A
N/A
Return on Investment
  • It helped us implement something impossible using original SSIS.
  • It helped us build the process more quickly.
Support Rating
10
Their support is fast and responsive. Their devs work on resolving the issues quickly. We usually will have a release of a fix within a few days.
February 04, 2020

COZYROC Relieves Some SSIS Pain

Verified User
Professional in Information Technology
Architecture & Planning Company, 1001-5000 employees
Score 7 out of 10
Vetted Review
Verified User
Incentivized
Use Cases and Deployment Scope
COZYROC is being used primarily for its data connections. We have needs around CRM, LDAP, and SFTP, which COZYROC helps to address.
Pros and Cons
  • Large number of data connectors
  • Some nice helper components
  • Smaller set of useful transform tasks than some competitors
  • Upgrade process could be smoother (though similar to others in this space)
Likelihood to Recommend
COZYROC is great if you have a number of sources or destinations where vanilla SSIS either does not provide connectors, they are difficult to work with, or they are not fully featured. SFTP is a prime example. Almost any web service is another.

It also includes some nice helper components, such as script task plus. This speeds up the development of script tasks by making the configuration easier.

That said, it is not a silver bullet for all your SSIS woes. I've found that none of the SSIS 3rd party components spans all my needs and generally end up running a couple of different ones to cover all the functionality required.
COZYROC Feature Ratings
Data Source Connection (2)
80%
8.0
Connect to traditional data sources
80%
8.0
Connecto to Big Data and NoSQL
80%
8.0
Data Transformations (2)
60%
6.0
Simple transformations
60%
6.0
Complex transformations
60%
6.0
Data Modeling
N/A
N/A
Data Governance
N/A
N/A
Return on Investment
  • Faster time to market for SSIS package development.
  • Less coding required.
Alternatives Considered
We run both Task Factory and COZYROC. The two sets certainly have crossover but are also complementary. Neither solution provides coverage for every use case. We have also reviewed ZappySys, which again has significant crossover between the two, but some useful outlier functionality as well, such as a robust SOAP component if you have the misfortune of still dealing with that protocol.
Support Rating
8
COZYROC is quick to respond to issues, both on the sales/billing and technical side. Their turnaround time on both is fast, which has helped us resolve licensing issues as well as get hotfixes when needed. Their support is better than average, particularly for a smaller software vendor. Overall very pleased with their responsiveness.
Other Software Used
Return to navigation