#1 most frequent
United States of America
95.8%23 installations of 24
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
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
1 / 2
Screenshot of COZYROC is the leading company providing reliable SSIS components for Data Integration and fast and easy ETL.
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.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
Areas for Improvement
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
Who Buys & Uses COZYROC
#2 most frequent
United Kingdom of Great Britain and Northern Ireland
4.2%1 installation of 24
Cozyroc SSIS+ makes Microsoft SSIS a proper ETL tool
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]
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
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
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
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
