COZYROC SSIS+ Library Reviews & Product Details

COZYROC SSIS+ Library Overview

What is COZYROC SSIS+ Library?

COZYROC SSIS+ suite for fast and easy ETL. COZYROC SSIS+ is a comprehensive suite of 240+ advanced components for developing ETL solutions with Microsoft SQL Server Integration Services. Our easy-to-use, coding-free library of tasks, components and reusable scripts can significantly cut your development time and also improve the execution speed of your SSIS packages. Support Support for SQL Server 2012, 2014, 2016, 2017, 2019 * Major highlights of the 2.0 release * Database Destination component for fast loading and updating data. Insert, Update, Delete or Upsert in row-by-row or bulk-load mode for ADO.NET, OLE DB and ODBC. https://www.cozyroc.com/ssis/database-destination * JSON Source component for retrieving data from JSON documents that supports multiple outputs via the composite records pattern. https://www.cozyroc.com/ssis/json-source * JSON Destination component for generating JSON documents that supports multiple inputs via the composite records pattern. https://www.cozyroc.com/ssis/json-destination * Easier connectivity to any REST service. * Support of Dynamic data flows and composite records modelling * Fast Sort Plus component for sorting of LARGE amounts of data. * EDI components * Additional REST services connectivity https://www.cozyroc.com/ssis/rest-connection COZYROC SSIS+ Components Suite has been successfully used by thousands of businesses, in more than 140 countries around the world.

COZYROC SSIS+ Library Details
Languages Supported
English
Product Description

Library of Custom tasks, Components and Scripts for developing affordable,world-class ETL solutions with Microsoft SQL Server Integration Services (SSIS)


Seller Details
Seller
COZYROC
Company Website
Year Founded
2006
HQ Location
Raleigh, NC
Twitter
@CozyRoc
647 Twitter followers
LinkedIn® Page
www.linkedin.com
10 employees on LinkedIn®
Show More

COZYROC SSIS+ Library Screenshots

Answer a few questions to help the COZYROC SSIS+ Library community
Have you used COZYROC SSIS+ Library before?
Yes

COZYROC SSIS+ Library Reviews

Write a Review
Filter reviews
LinkedIn®
Connections
Popular Mentions
Showing 17 COZYROC SSIS+ Library reviews
Popular Mentions
Showing 17 reviews
Filter Reviews
Filter Reviews
Sort by
Ratings
Company Size
User Role
All Industries
Region
Already have COZYROC SSIS+ Library?
Write a Review
Validated Reviewer
Verified Current User
Review source: Organic
What do you like best?

We were looking to upgrade to CozyRoc SSIS where we were evaluating different components offered by CozyRoc like Salesforce Source, SharePoint Source, Open PGP Task, File Transfer Task and Stream Task.

We were having issues with loading bulk data from Salesforce with our existing components but CozyRoc Salesforce Source - Bulk Mode made our life easier, it was able to load millions of data much faster.

File Transfer Task and Stream Task combination is mind-blowing, we can achieve many things out of it, like we can stream the SFTP files directly without the need to store it locally and also the support of FLEE Expressions in it.

Also, the faster resolution of the tickets by the Support team is much appreciated. Review collected by and hosted on G2.com.

What do you dislike?

None, till now. CozyRoc team had happily accepted all the issues which we raised and included those fixes for the upcoming releases. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

Reliable, Faster data Load and Optimized SSIS Packages is what we saw after using the COZYROC SSIS+ Components. Review collected by and hosted on G2.com.

Show More
Show Less
AC
Small-Business(50 or fewer emp.)
Validated Reviewer
Verified Current User
Review source: Invitation from G2
What do you like best?

CozyRoc SSIS+ Library has given our developers quick, easy and documented methods to send, receive and modify data from various 3rd parties in an efficient manner. It can handle all manner of ETL (Extract, Transform, Load) functions to extend what you can do with SQL SSIS jobs, streamlining processes and saving human time and effort.

It has saved us time in building our own API's which need ongoing maintenance and just use a well thought out and built set of API's, which are well tested and documented.

The subscription includes install to 2x servers which is great as we can have one on our development server and the other on production. Review collected by and hosted on G2.com.

What do you dislike?

Not much to dislike as it does what it says on the box, it handles every type of connection we have needed so far too. Review collected by and hosted on G2.com.

Recommendations to others considering the product:

If you need to send or receive data to many 3rd party services from your SQL servers then give this tool a look to see how it can make it easier to achieve and also faster to implement. Don't waste time creating various connectors one by one, or buying many connectors when this one probably covers everything in one tool.

The documentation is easy to follow, and you will be up and running in now time. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

Our main reason for purchasing CozyRoc SSIS+ was to allow us to connect into, and send/receive data from SalesForce and our existing SQL/SAP system. It was also used for pushing data into the eBay marketplace to further automate our processes.

Although we could have written out our own interface, the time and effort to build that was more than just purchasing this subscription, and then we got the benefit of all the other features within the product allowing us to speed up other projects. The product is updated regularly and is very well documented allowing a quick turn around from planning to implementation. Review collected by and hosted on G2.com.

Show More
Show Less
Small-Business(50 or fewer emp.)
Validated Reviewer
Review source: Organic
What do you like best?

In my specific instance, I needed an SFTP solution. Although it does not directly indicate, the SSH connector works perfectly for this, just skip the SSH file. Using Visual Studio and the drag and drop editor, this Review collected by and hosted on G2.com.

What do you dislike?

There are no downsides to the tool itself, but the documentation on how to use it could be improved. It does more than it shows, and you end up findind out by trial and error. Review collected by and hosted on G2.com.

Recommendations to others considering the product:

PLAY WITH IT. The documentation is SPARSE, it can do a lot when used with Visual Studio. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

Many of our vendors have been forced to upgrade from FTP, which is included by default with Visual Studio, to more secure methods of the file transfer. Most Notably, FTPS and SFTP. This makes it easy to rebuild what we have with upgraded visual tools. Review collected by and hosted on G2.com.

Show More
Show Less
Small-Business(50 or fewer emp.)
Validated Reviewer
Verified Current User
Review source: Organic
What do you like best?

The best part of CozyRoc for me, is how it offers me ways to fill in the gaps that Microsoft leaves in their product. For example with the standard SSIS send email task for Sql Server 2016 you can not make a connection to an office mailbox in the cloud. It sounds so simple, yet without CozyRoc I would have to create a script task and rely on C# code to connect and send an email, because the basic task doesn't allow ssl connections.

CozyRoc also allows me the flexibility to use variables for many of the ssis toolbox items that I would normally have to create expressions, or worse have to manipulate through the api via script tasks.

It really rounds out the SSIS offering from Microsoft with things it should have had to start with. Review collected by and hosted on G2.com.

What do you dislike?

The only real downfall to CozyRoc is that I have to periodically go out to the CozyRoc website tutorials to answer my question about CozyRoc task properties values. I wish they would give some tool tips or a quick reference guide right in the integration in Visual Studio. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

The ability to quickly and easily manage connections to Excel, CRM, and email servers in the cloud that require SSL connections. Review collected by and hosted on G2.com.

Show More
Show Less
CI
Mid-Market(51-1000 emp.)
Validated Reviewer
Review source: Organic
What do you like best?

I like the fact that Cozyroc (+Visual Studio, SSIS) can automatically not just generate SQL scripts to build tables but to integrate them swiftly. Extraction, Transformation, and Loading to and from Salesforce & MS SQL is a breeze. Best part is, the free version is so powerful that you can almost have everything you need with it. The product support team will treat you just like any other customer, free or licensed. Review collected by and hosted on G2.com.

What do you dislike?

So far, nothing. It is a cool tool that compliments SSIS Review collected by and hosted on G2.com.

Recommendations to others considering the product:

N/A Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

swift rebuilding of Salesforce tables in my database, simple tasks like extracting data from SFDC to MSSQL, and writing it back to SFDC. Review collected by and hosted on G2.com.

Show More
Show Less
DB/BI developer
Small-Business(50 or fewer emp.)
Validated Reviewer
Verified Current User
Review source: Organic
What do you like best?

I've used not every component but I can say that I like SSIS + very much.

It have a good UI like embedded SSIS components.

Also it is provide very descriptive error messages. Review collected by and hosted on G2.com.

What do you dislike?

Actually I did not find any disadvantages.

I've faced with only few minor UI bugs like combobox hide half label text. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

Using the components I've done with following tasks:

1) Using dataflow+ and excel connection I've created solution that able to stage any excel file in database( but columns list needs to be specified in additional table)

2) Using CRM source and destination components I've easily got and load data from CRM2011 to CRM365

3) Using source and destination REST component saved me a lot of time when I need to integrate data with client API Review collected by and hosted on G2.com.

Show More
Show Less
AI
Mid-Market(51-1000 emp.)
Validated Reviewer
Review source: Organic
What do you like best?

Looking at few specific areas to improve Business Intelligence solution without dependency of IT, COZYROC provides:

1. outstanding libraries of component to take SSIS integration to next level. It can be a bit challenging as you begins to learn the components functionality, but once yo are there, amazing way to take processing at next level.

2.customer service and patient to respond are extraordinary. Ticket time for response are so quick, it seems support is real time.

3. take and fix all things Microsoft cannot do. Review collected by and hosted on G2.com.

What do you dislike?

Nothing as of now!! We are still testing for implementation. Review collected by and hosted on G2.com.

Recommendations to others considering the product:

Take a look to their integration capabilities and give a try Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

New Integration solution to merge application data to a single source through API into local database. Leverage Integration solution for the organization Review collected by and hosted on G2.com.

Show More
Show Less
Small-Business(50 or fewer emp.)
Validated Reviewer
Review source: Organic
What do you like best?

Working between Linux and Windows system becomes very smooth. Review collected by and hosted on G2.com.

What do you dislike?

The SSH task should fail incase there is a command failure at the linux.

Instead we have to process the error variable and control the flow. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

few of problems which cozyroc has helped to resolve are :

1: Working with linux system.

2: Uploading multiple file using DataFlow plus task. Review collected by and hosted on G2.com.

Show More
Show Less
Senior Software Engineer
Enterprise(> 1000 emp.)
Validated Reviewer
Verified Current User
Review source: Organic
What do you like best?

Dynamic feature support of mapping columns Review collected by and hosted on G2.com.

What do you dislike?

I dont find any issues on plugin till now Review collected by and hosted on G2.com.

Recommendations to others considering the product:

Good to try as based on your requirement. For dynamic mapping stuff i will suggest this product. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

Dynamic mapping source and target especially in the data flow components. Support a large range of customization. The product support was too quick and clear. Review collected by and hosted on G2.com.

Show More
Show Less
Response from Alex Biks of COZYROC SSIS+ Library

Senthil, thank you for the great review! We’re happy you loved COZYROC Data Flow Task Plus component. We really appreciate you being a customer. Thank you for taking the time to share your experience with us. We look forward to working with you again in the future!

Kind regards,

The COZYROC team.

SQL Developer
Mid-Market(51-1000 emp.)
Validated Reviewer
Verified Current User
Review source: Organic
What do you like best?

I had a few questions about a few tasks in the CozyRoc SSIS+ library. Not only was the response rapid, but was very well formulated. It helped me get over a design issue I was having.. Tech support even created a small package for me to illustrate a different aspect of a task not normally used. Review collected by and hosted on G2.com.

What do you dislike?

Obviously, CozyRoc tasks are a little different than the way similar standard SSIS tasks work, but that's understandable because of the added functionality. There is a little bit of a learning curve to some of the CozyRoc tasks. Review collected by and hosted on G2.com.

Recommendations to others considering the product:

CozyRoc offers a free license on development machines. That is awesome. Put the software through it's paces and get used to the way it works. There is a boatload of functionality there. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

We are moving data back and forth to an Azure environment, sometimes using zip files. All the CozyRoc tasks we have used work seamlessly for us. And have certainly saved time over the standard tasks in SSIS. Review collected by and hosted on G2.com.

Show More
Show Less
CI
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: Organic
What do you like best?

We are using CozyRoc in our project for 5+ years. Its amazing and fulfills our various requirement.

DFT+ is unique in CozyRoc which helps to reduce multiple package creation.

CozyRoc team also very supportive and help us immediately over the emails.

Excellent Product and Great team. Review collected by and hosted on G2.com.

What do you dislike?

Nothing specifically. If we get on call support on critical issues would be helpful. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

DFT+ for data transfer reduced huge number of package creation

SharePoint tasks helps much in connecting O365 sites

File System task for upload/download files to various locations Review collected by and hosted on G2.com.

Show More
Show Less
Response from Alex Biks of COZYROC SSIS+ Library

Thank you for being our valued customer ! We truly appreciate your business, and we’re so grateful for the trust you’ve placed in us. Thank you for choosing us !

Kind regards

COZYROC team

IF
Mid-Market(51-1000 emp.)
Validated Reviewer
Verified Current User
Review source: Organic
What do you like best?

There are a lot of components and task that can make the job easier. We've been using COZYROC SSIS+ to build out our SSIS packages and Projects. Reliable and easy to use. Add the componento to your pkg instead of building C# scripts. We used for Amazon S3 Tasks to get and put files into different buckets. I had to contact the support team with an issue I had and they committed to provide a solution in a matter of hours. Great Customer support and incredible product Review collected by and hosted on G2.com.

What do you dislike?

Add more actions on the Amazon S3 Task like file exists status, files count, set permissions etc.. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

S3 bucket connection to receive and put files using variables for big loads. Review collected by and hosted on G2.com.

Show More
Show Less
CB
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: Invitation from G2
What do you like best?

It's inbuilt components, script task, make things very simple for one who is not used to script/code the process, more over it allows us ro import data, make connections to n number of data sources very easily, and interaction with the API like Microsoft SharePoint, Salesforce,analytics solution and many more made possible. Review collected by and hosted on G2.com.

What do you dislike?

It should have better error handling and debugging process for API's Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

Moving data, importing data task from Microsoft sharee to to SSIS enviornment and transforming data and then moving to the SQL server in predefined tables. Review collected by and hosted on G2.com.

Show More
Show Less
Validated Reviewer
Verified Current User
Review source: Organic
What do you like best?

mail functionality and the numerous connections Review collected by and hosted on G2.com.

What do you dislike?

downside of third party product is always dependencies when the primary product upgrades. I think CozyRoc does a good job staying inSync Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

The most important problem CoryRoc is solving for us is getting data in and out out databases Review collected by and hosted on G2.com.

Show More
Show Less
CI
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: Invitation from the seller
Business partner of the seller or seller's competitor, not included in G2 scores.
What do you like best?

It provides rapid development with ETL having around more than 200 tasks and scripts which makes job easier for developers while loading any flat files, pdf files in SQL server database. It can supports SQLServer 2005-2017 which makes it more best in terms of using it.. It's easy to make connection and main beneficial with CRM(Customer Relationship Management) applications.. easy to install along with SSIS and easy to make connections.. best part is it's kind of password protected which helps to make a secure connection while connecting CRM front end application or back end application Review collected by and hosted on G2.com.

What do you dislike?

so far i feel that a person not having basic knowledge of SSIS might having difficulties in installation of cozyroc and making connections but Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

1. it's quick

2. Numerous script task and components makes development easy which means a requirement can fulfill in short period of time

3. Free download of Cozyroc along with guide on installation which saves cost versus. license version software

Review collected by and hosted on G2.com.

Show More
Show Less
UI
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: Invitation from the seller
What do you like best?

The single drag and drop component makes life easier for ETL developers. Of course those all are doable in native SSIS with few workarounds but when you are running after deadlines , COZYROC is a blessing in disguise. Review collected by and hosted on G2.com.

What do you dislike?

I haven't had a chance to explore all the tools of COZYROC but nothing solid to complain about so far. Review collected by and hosted on G2.com.

Recommendations to others considering the product:

Good support for legacy systems. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

My team were looking for a solution to load data from legacy system and for certain reasons we need to pull data in business hours. COZYROC outperformed native SSIS by long shot. Review collected by and hosted on G2.com.

Show More
Show Less
UG
Enterprise(> 1000 emp.)
Validated Reviewer
Verified Current User
Review source: Invitation from G2
What do you like best?

I like that there is a single components for something that would've taken me hours to create. You could create a script component and figure out a few workarounds, but when you have deadlines nothing beats being able to drag and drop one of these components and just getting the job done. Review collected by and hosted on G2.com.

What do you dislike?

Nothing to dislike at this time. The components are pretty solid. I haven't had the chance to use 100% of them, but due to the satisfaction of the ones I did use, I'm sure the others would also be satisfactory. Review collected by and hosted on G2.com.

Recommendations to others considering the product:

Ask questions when you have them. They have great support. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

One thing we were trying to solve was fast loading data into a DB2 database. SSIS out of the box does not provide fast loading for DB2 so that is how I ran into COZYROC. After using their tool for fast loading, I was able to transfer data at much greater speeds. Review collected by and hosted on G2.com.

Show More
Show Less