TrustRadius Insights
COZYROC SSIS+ provides a range of functionalities that make it a valuable tool for data integration projects. Users and reviewers have …
Starting at $199.95 per year
View PricingOverview
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…
Recent Reviews
Popular Features
- Simple transformations (8)2.222%
- Connect to traditional data sources (8)2.121%
- Connecto to Big Data and NoSQL (5)1.111%
- Complex transformations (6)1.010%
Pricing
COZYROC Excel Add-in for SAS®
$199.95
On Premise
per year
COZYROC SSIS+ Premium Priority Support
$499.95
On Premise
per year
COZYROC SSIS+ Ultimate Subscription
$1,199
On Premise
per 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
Return to navigation
Product Details
- About
- Integrations
- Competitors
- Tech Details
- FAQs
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
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: 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 Video
COZYROC Integrations
- Amazon Drive (discontinued)
- QuickBooks Online
- UKG Workforce Central (discontinued)
- Xero
- FreshBooks
- ServiceNow IT Service Management
- Google Analytics
- Google BigQuery
- Google Backup and Sync (discontinued)
- Microsoft Power BI
- QlikView
- Sisense
- Tableau Cloud
- Tableau Desktop
- Microsoft SharePoint
- ClickSend
- Slack
- Stripe Payments
- Zuora
- Dropbox
- Dropbox Business
- OneDrive
- Google Drive
- ArcGIS
- isolved
- ActiveCampaign
- Constant Contact
- HubSpot Marketing Hub
- Mailchimp
- Adobe Marketo Engage
- Salesforce Marketing Cloud
- Marigold Engage by Sailthru
- Fleet Complete
- WooCommerce
- Microsoft Dynamics 365
- UiPath Process Mining
- Genesys Cloud CX
- Humanity
- REST API
- SAS
- JSON Source
- Microsoft Common Data Service Connection
- Magento
- BridalLive
- Square
- Close CRM
- Sage
- Salesforce
- Epicor
- IRESS XPLAN
- ADP
- Act-On
- SendGrid
- YouTube
- UPS Connection
- Amazon S3
- Sage
- SugarCRM
- PayTrace
COZYROC Competitors
COZYROC Technical Details
| Deployment Types | On-premise |
|---|---|
| Operating Systems | Windows, Azure |
| Mobile Application | No |
Frequently Asked Questions
Boomi, Redgate SQL Toolbelt Essentials, and /n software IPWorks are common alternatives for COZYROC.
Reviewers rate Simple transformations highest, with a score of 2.2.
The most common users of COZYROC are from Enterprises (1,001+ employees).
Comparisons
Compare with
Reviews and Ratings
(13)
Community Insights
TrustRadius Insights are summaries of user sentiment data from TrustRadius reviews and, when necessary, 3rd-party data sources. Have feedback on this content? Let us know!
- Business Problems Solved
- Recommendations
COZYROC SSIS+ provides a range of functionalities that make it a valuable tool for data integration projects. Users and reviewers have praised its ability to address specific needs and enhance ETL processes. One key use case is enabling Microsoft SSIS to work seamlessly as an ETL tool, even when connecting to a DB2 database. This allows users to consolidate their data from different sources efficiently. Additionally, the plugin offers extensive functionalities for various data-related projects, including file transfer, OpenPGP encryption, EDI source/destination, and REST source/destination. It has been particularly useful in connecting with Salesforce, SharePoint, and other platforms, providing smooth data integration and transfer.
The dynamic query capability of COZYROC SSIS+ with the Salesforce source task has been highly regarded by users. This feature allows for flexible querying and retrieving the required data directly from Salesforce, streamlining the ETL process. Another use case lies in resolving complex tasks in SQL Server Integration Services ETL that standard SSIS falls short on. With COZYROC SSIS+, users can overcome these limitations and accomplish more comprehensive data integration tasks.
Furthermore, COZYROC SSIS+ has found applications across different departments within organizations. For instance, the Data Engineering and Data Analytics department utilizes the tool to connect to customized Dynamics 365 instances for differential ELT processing. The IT department relies on COZYROC SSIS+ components to build solutions that benefit the entire organization. Moreover, this product has proven helpful for addressing various data connection needs related to CRM systems, LDAP servers, and SFTP servers.
Users have also appreciated the responsive support provided by COZYROC. The helpdesk support team is known for delivering lightning-fast responses and promptly resolving issues. Overall, COZYROC SSIS+ offers a robust solution for data integration projects, empowering users to overcome challenges and achieve efficient data workflows.
Users recommend considering this tool if you need to send or receive data from many 3rd party services from your SQL servers. They have found that it makes the process easier and faster. Additionally, they suggest taking a look at the integration capabilities and trying it out based on your requirements.
According to users, the documentation is easy to follow and helps you get up and running quickly. However, they mention that the documentation is sparse and that the tool can do a lot when used with Visual Studio.
One of the common recommendations is to try this product for dynamic mapping, especially if it aligns with your requirements.
Attribute Ratings
Reviews
(1-9 of 9)Companies can't remove reviews or game the system. Here's why
June 20, 2022
COZYROC isn't the answer
Score 1 out of 10
Vetted Review
Verified User
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.
December 07, 2021
Cozyroc SSIS+ makes Microsoft SSIS a proper ETL tool
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.
August 25, 2021
[COZYROC]
[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.
May 01, 2021
a Good SSIS toolbox
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
March 27, 2021
A must-have tool box for your ETL projects
[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.
October 07, 2020
Great SSIS Toolbox
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)
April 08, 2020
Good product and fantastic support
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.
February 04, 2020
Experience with COZYROC and their support
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.
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
February 04, 2020
COZYROC Relieves Some SSIS Pain
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)