COZYROC vs SSIS | TrustRadius

What users are saying about

Score 8 out of 10

Based on 7 reviews and ratings

Score 8.3 out of 10

Based on 208 reviews and ratings

Feature Rating Comparison

COZYROC

SSIS

Connect to traditional data sources

Connecto to Big Data and NoSQL

COZYROC

SSIS

Simple transformations

Complex transformations

COZYROC

SSIS

Metadata management

Business rules and workflow

Testing and debugging

Data model creation

Collaboration

feature 1

COZYROC

SSIS

Integration with data quality tools

Integration with MDM tools

Pros

CRM Dynamics connection
Sharepoint list connector
SFTP component

Read full review

Verified User

Manager in Information Technology

Business Supplies & Equipment Company, 1001-5000 employees

View all 4 answers on this topic

SSIS works very well pulling well-defined data into SQL Server from a wide variety of data sources.
It comes free with the SQL Server so it is hard not to consider using it providing you have a team who is trained and experienced using SSIS.
When SSIS doesn't have exactly what you need you can use C# or VBA to extend its functionality.

Read full review

Verified User

Team Lead in Information Technology

Information Technology and Services Company, 10,001+ employees

View all 35 answers on this topic

Cons

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

Read full review

Venkata Ramana Potluri

Database Analyst

Victorian Building AuthorityGovernment Administration, 201-500 employees

View all 4 answers on this topic

SSIS memory usage can be quite high particularly when SSI and SQL server are on the same machine
SSIS is not available on any environment other than Microsoft Windows
SSIS does not function with any database engine back-end other than Microsoft SQL Server

Read full review

Verified User

Engineer in Information Technology

Automotive Company, 10,001+ employees

View all 35 answers on this topic

Likelihood to Renew

No score

No answers yet

No answers on this topic

SSIS 9.9

Based on 3 answers

Some features should be revised or improved, some tools (using it with Visual Studio) of the toolbox should be less schematic and somewhat more flexible. Using for example, the CSV data import is still very old-fashioned and if the data format changes it requires a bit of manual labor to accept the new data structure

Read full review

Luca Campanelli

Database Administrator

Intralot Italia S.p.A.Gambling & Casinos, 51-200 employees

View all 3 answers on this topic

Usability

COZYROC 8.2

Based on 1 answer

Easy to use and easy to implement into ETL solutions with Microsoft SQL Server Integration Services.

Read full review

Verified User

Manager in Information Technology

Business Supplies & Equipment Company, 1001-5000 employees

View all 1 answers on this topic

SSIS 9.1

Based on 8 answers

If you use any of the Microsoft tools, it is easy to get using and understand since it uses Visual Studio and SSMS to work with. There are extensions you can get and some of those can be difficult to work with but usually they slide in nicely. The one thing to understand though is there is some installation and configuration on the SQL Server side that can take some time.

Read full review

Steven Gockley, MBA, MCSA

DBA / Sr. Data Analyst

BoostabilityMarketing and Advertising, 201-500 employees

View all 8 answers on this topic

Performance

No score

No answers yet

No answers on this topic

SSIS 8.7

Based on 6 answers

You can, of course, accidentally make sloppy code or workflows but it’s not a tools issue if you run packages in an inefficient way. With a company of our size, we never had any performance issues but I can imagine for larger companies that this will have a greater focus.

Read full review

Verified User

Technician in Information Technology

Medical Devices Company, 201-500 employees

View all 6 answers on this topic

Support Rating

COZYROC 8.6

Based on 4 answers

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.

Read full review

Verified User

Employee in Information Technology

Computer Software Company, 1001-5000 employees

View all 4 answers on this topic

SSIS 8.5

Based on 7 answers

The support, when necessary, is excellent. But beyond that, it is very rarely necessary because the user community is so large, vibrant and knowledgable, a simple Google query or forum question can answer almost everything you want to know. You can also get prewritten script tasks with a variety of functionality that saves a lot of time.

Read full review

Chemist, LIMS Specialist

USDA-FSISGovernment Administration, 5001-10,000 employees

View all 7 answers on this topic

Implementation Rating

No score

No answers yet

No answers on this topic

SSIS 10.0

Based on 1 answer

The implementation may be different in each case, it is important to properly analyze all the existing infrastructure to understand the kind of work needed, the type of software used and the compatibility between these, the features that you want to exploit, to understand what is possible and which ones require integration with third-party tools

Read full review

Luca Campanelli

Database Administrator

Intralot Italia S.p.A.Gambling & Casinos, 51-200 employees

View all 1 answers on this topic

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.

Read full review

Verified User

Professional in Information Technology

Architecture & Planning Company, 1001-5000 employees

View all 4 answers on this topic

Look for where you are going to load the data and from where are you extracting it. A lot of those who sell you the DB already have tools for ETL. I have heard good things at an enterprise level from great colleagues about Informatica, but honestly, I prefer SSIS.Although I did like TIBCO Jaspersoft and it can be mixed with TIBCO Spotfire for data analysis. If your ERP is SAP, then you must keep in mind using SAP BusinessObjects. As for free tools, and if you have a great and constant team of scripting (Perl, Python) engineers, then you can think about going open source.

Read full review

Systems/Software Engineer V

Hewlett Packard EnterpriseComputer Hardware, 10,001+ employees

View all 35 answers on this topic

Return on Investment

It helped us implement something impossible using original SSIS.
It helped us build the process more quickly.

Read full review

Verified User

Employee in Information Technology

Computer Software Company, 1001-5000 employees

View all 4 answers on this topic

I use SSIS to automate tasks that I'm repeatedly asked to do. "Hey, can you go into the system and close any open orders that we've fully filled?" Sure....then I schedule a package to do that for me every hour so I'm never asked again. It saves me time, which gives value to the company.
It removes the risk of human error. When people build files and send them, there's the risk that it doesn't happen the same way every time or gets forgotten. With SSIS, you spend some up front time building a process, but then you deploy it and forget it (unless it emails you that there was an error. You are putting error handling in your ETL, right?). Very repeatable and consistent business solution.

Read full review

SQL Database and Business Intelligence Manager

Ten CateTextiles, 1001-5000 employees

View all 35 answers on this topic

Screenshots

See Both COZYROC Screenshots

—

Pricing Details

General

Free Trial

Yes

Free/Freemium Version

Yes

Premium Consulting/Integration Services

Yes

Entry-level set up fee?

No

COZYROC Editions & Modules

Edition

COZYROC SSIS+ Ultimate Subscription	$899¹
COZYROC SSIS+ 1.9 Lifetime	$4,999²
COZYROC SSIS+ Premium Priority Support	499.95³
COZYROC SAS® SSIS Adapters	2,499.95³
COZYROC Excel Add-in for SAS®	199.95³

year
one-time payment
year

Additional Pricing Details

COZYROC SSIS+ Ultimate Subscription - $799 /per year 2 license keys (for two servers) * Free upgrades to newer versions * Free to use in Visual Studio * Premium support (Priority over regular free support. Guaranteed one business day response time.)

General

Free Trial

—

Free/Freemium Version

—

Premium Consulting/Integration Services

—

Entry-level set up fee?

No

SSIS Editions & Modules

—

Additional Pricing Details

—

Rating Summary

COZYROC

SSIS

COZYROC

SSIS

COZYROC

SSIS

COZYROC

SSIS

COZYROC

SSIS

COZYROC

SSIS

Add comparison