COZYROC

COZYROC

About TrustRadius Scoring
Score 8.1 out of 100
COZYROC

Overview

Recent Reviews

[COZYROC]

10
August 25, 2021
[COZYROC is] used by the Data Engineering and Data Analytics department to connect to a customized Dynamics 365 instance for a …

a Good SSIS toolbox

6
May 01, 2021
COZYROC components are being used by our IT department, to build solutions that are used across the whole organization. They resolve the …
Read full review

A must-have tool box for your ETL projects

9
March 27, 2021
[COZYROC] is a helpful plugin and extension to our data integration projects across the entire data team. We count on its extensive …
Read full review

Great SSIS Toolbox

9
October 07, 2020
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 …
Read full review

Experience with COZYROC and their support

9
February 04, 2020
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 …
Read full review

COZYROC Relieves Some SSIS Pain

7
February 04, 2020
COZYROC is being used primarily for its data connections. We have needs around CRM, LDAP, and SFTP, which COZYROC helps to address.
Read full review

Popular Features

View all 7 features

Simple transformations (7)

7.7
77%

Connect to traditional data sources (7)

7.7
77%

Complex transformations (5)

6.8
68%

Reviewer Pros & Cons

View all pros & cons

Video Reviews

Leaving a video review helps other professionals like you evaluate products. Be the first one in your network to record a review of COZYROC, and make your voice heard!

Pricing

View all pricing

COZYROC Excel Add-in for SAS®

$199.95

On Premise
year

COZYROC SSIS+ Premium Priority Support

$499.95

On Premise
year

COZYROC SSIS+ Ultimate Subscription

$1,199

On Premise
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

Features Scorecard

Data Source Connection

7.6
76%

Data Transformations

7.3
73%

Data Modeling

7.5
75%

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 can 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.

⭐ Download COZYROC SSIS+ Components Suite from: https://cozyroc.com/download
⭐ 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: Powerful 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

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.

COZYROC Videos

COZYROC Integrations

COZYROC Competitors

COZYROC Technical Details

Deployment TypesOn-premise
Operating SystemsWindows, Azure
Mobile ApplicationNo

Comparisons

View all alternatives

Frequently Asked Questions

What is COZYROC's best feature?

Reviewers rate Connect to traditional data sources and Simple transformations highest, with a score of 7.7.

Who uses COZYROC?

The most common users of COZYROC are from Enterprises (1,001+ employees) and the Architecture & Planning industry.

Reviews and Ratings

 (12)

Ratings

Reviews

(1-8 of 8)
Companies can't remove reviews or game the system. Here's why
Mika Itkonen | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
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.
  • Database Destination Component.
  • Support.
  • Rest components.
  • Documentation.
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.
Support is fast and after they understand our needs they are willing to implement new features.
August 25, 2021

[COZYROC]

Score 10 out of 10
Vetted Review
Verified User
Review Source
[COZYROC is] used by the Data Engineering and Data Analytics department to connect to a customized Dynamics 365 instance for a differential ELT processing.
  • Integrates with Microsoft SSIS plug and play approach
  • 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.
[COZYROC is well suited for] ETL / ELT processing and migration projects[.]
Score 6 out of 10
Vetted Review
Verified User
Review Source
COZYROC components are being used by our IT department, to build solutions that are used across the whole organization. They resolve the needs to do some tricky jobs on our SQLserver integration services ETL tasks, like ftp and sftp component, Microsoft sharepoint list connection and download; generally speaking we use these components where standard SSIS can't help.
  • sftp connection
  • Microsoft sharepoint list connection
  • Microsoft dynamic 365 connection
  • can speedup Microsoft dynamic crm connection
  • need to improve their support and customer care
  • would like to have some good and fast scd component
it's ok to connect with other data source (like microsoft dynamics cloud or microsoft sharepoint lists) and good to use for ftp or sftp connection. it's great because there are really a lot of connectors (mongo db, google cloud, json, rest, salesforce and many many others) but i dont' reccomend it for using with lookup or sort operations
Score 9 out of 10
Vetted Review
Verified User
Review Source
[COZYROC] is a helpful plugin and extension to our data integration projects across the entire data team. We count on its extensive functionalities to accomplish various data related projects. Heavily used components include but not [limited] to File Transfer task, OpenPGP task, EDI Source/Destination, REST Source/Destination, etc. The recent practice is to use REST Destination to post our structured data to vendor's API and get response back.
  • REST Components which allow users to communicate between SQL server and REST APIs
  • EDI Components
  • SFTP Components
  • 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.
[COZYROC] is a powerful tool and [extends] what you are able to do when it comes to ETL. It allows you to accomplish a lot of things that are very common now, but very difficult to implement with the out of the box functionality of SSIS.
October 07, 2020

Great SSIS Toolbox

Score 9 out of 10
Vetted Review
Verified User
Review Source
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.
  • 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)
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.
Fast and efficient customer service.
Venkata Ramana Potluri | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
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.
  • 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.
We are getting Salesforce data seamlessly with no troubles.
Support responds at lightning speed!
Score 9 out of 10
Vetted Review
Verified User
Review Source
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.
  • 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
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.
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.
Score 7 out of 10
Vetted Review
Verified User
Review Source
COZYROC is being used primarily for its data connections. We have needs around CRM, LDAP, and SFTP, which COZYROC helps to address.
  • 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)
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 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.