TrustRadius: an HG Insights company

COZYROC

Score2.1 out of 10

13 Reviews and Ratings

Get a Demo

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

COZYROC is the leading company providing reliable SSIS components for Data Integration and fast and easy ETL.
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

Key Features

Learn about the best (and worst!) features COZYROC has to offer, as determined by TrustRadius' reviewers.
Based on 13 ratings of COZYROC's features
View all features

Top Performing Features

  • Testing and debugging

    Tool to debug and tune for optimal performance

    Category average: 7.1

  • Simple transformations

    Simple data transformations are calculations, data type conversions, aggregations and search and replace operations

    Category average: 8.8

  • 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

Areas for Improvement

  • Business rules and workflow

    Ability to define and manage business rules and workflows

    Category average: 8.1

  • 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.6

  • Complex transformations

    Complex data transformations are data normalization, advanced data parsing, etc.

    Category average: 7.3

Reviews

What users are saying about COZYROC.
View all reviews

Cozyroc SSIS+ makes Microsoft SSIS a proper ETL tool

Incentivized
Mika ItkonenView 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.

[COZYROC]

Incentivized
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

Good product and fantastic support

Incentivized
Venkata Ramana PotluriView 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

COZYROC isn't the answer

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

A must-have tool box for your ETL projects

Incentivized
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

Related Products

Products similar to COZYROC that may also meet your needs.
All comparisons
Boomi
CompareLearn more
Redgate SQL Toolbelt Essentials
CompareLearn more
/n software IPWorks
CompareLearn more