COZYROC

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.

[COZYROC is well suited for] ETL / ELT processing and migration projects[.]

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

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

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.

We are getting Salesforce data seamlessly with no troubles.

Support responds at lightning speed!

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.

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.