COZYROC

Score2.1 out of 10

13 Reviews and Ratings

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

Categories & Use Cases

Media

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.

1 / 2

Screenshot of COZYROC is the leading company providing reliable SSIS components for Data Integration and fast and easy ETL.

Testing and debugging
Tool to debug and tune for optimal performance
Category average: 7
Simple transformations
Simple data transformations are calculations, data type conversions, aggregations and search and replace operations
Category average: 8.1
Connect to traditional data sources
Ability to connect to traditional data sources like relational databases, flat files, XML files and packaged applications
Category average: 8.8

Business rules and workflow
Ability to define and manage business rules and workflows
Category average: 8.3
Connecto to Big Data and NoSQL
Ability to connect to non-traditional data sources like Hadoop and other big data technologies, and NoSQL databases
Category average: 7.8
Complex transformations
Complex data transformations are data normalization, advanced data parsing, etc.
Category average: 7.2

#1 most frequent

Professional, Scientific, and Technical Services

32.0%

8 installations of 25

#2 most frequent

Health Care and Social Assistance

20.0%

5 installations of 25

#3 most frequent

Manufacturing

16.0%

4 installations of 25

Mika Itkonen View profile

Data Warehouse Analyst in Information Technology at TS-Yhtymä Oy (501-1000 employees employees)

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

Database Destination Component.
Support.
Rest components.

Cons

Documentation.

Most Important Features

Database Destination component.
Support.

Return on Investment

Simplified data flows.
Faster data operations.

Russel Philpott

Data Engineering Consultant in Information Technology at Pobl Group (1001-5000 employees employees)

Pros

Integrates with Microsoft SSIS plug and play approach

Cons

Filtering / Parameter setting are not well explained i.e. needs to be documented.
Using Rest Source, it creates a new table for you with @Odata column. I would like an option to turn off.

Most Important Features

SQL Server Engineers to connect to Dynamics 365 / other cloud data repositories without having to create inhouse Rest Connections.

Alternatives Considered

Skyvia

Venkata Ramana Potluri View profile

Database Analyst in Information Technology at Victorian Building Authority (201-500 employees employees)

Pros

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.

Cons

Looking for Office 365 API connector and source task.
Looking for Share Connection with multifactor login.

Return on Investment

Good ROI

Verified User

C-Level Executive in Professional Services (51-200 employees employees)

Use Cases and Deployment Scope

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 to be a great company and have a great product, but the people who cared and knew what they were doing have long since departed. I believe my money was taken and in my experience, I was treated horribly at every step of the process and was given XML files that don't work or product valid EDI files. There aren't many games in town when it comes to SSIS extensions like this, but COZYROC isn't the answer, look elsewhere.

Cons

Customer Service

Most Important Features

Data manipulation

Return on Investment

It is my belie that I have thrown away $3.7k

Verified User

Employee in Information Technology (10,001+ employees employees)

Pros

REST Components which allow users to communicate between SQL server and REST APIs
EDI Components
SFTP Components

Cons

More detailed documents/instructions/case studies/tutorial videos will be highly appreciated. It's very difficult to understand how some new components work without those helps.

Return on Investment

Less coding time
Easier to configure

Other Software Used

Redgate SQL Monitor, SQL Sentry, Microsoft Visual Studio Code

Boomi

Redgate SQL Toolbelt Essentials

/n software IPWorks

COZYROC

What is COZYROC?

Categories & Use Cases

Media

Key Features

Top Performing Features

Testing and debugging

Simple transformations

Connect to traditional data sources

Areas for Improvement

Business rules and workflow

Connecto to Big Data and NoSQL

Complex transformations

Most Frequent Users

Professional, Scientific, and Technical Services

Health Care and Social Assistance

Manufacturing

Reviews

Use Cases and Deployment Scope

Pros

Cons

Most Important Features

Return on Investment

Pros

Cons

Most Important Features

Alternatives Considered

Pros

Cons

Return on Investment

Use Cases and Deployment Scope

Cons

Most Important Features

Return on Investment

Pros

Cons

Return on Investment

Other Software Used

Related Products