We performed a comparison between CloverDX Designer and SSIS based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration."Its simplicity and the way it handles graphs are the most valuable features."
"The setup is straightforward. It's very easy to install."
"It has a drag and drop feature that makes it easy to use. It has a good user experience because it takes into account your most-used tools and they're lined up nicely so you can just drag and drop without looking too far. It also integrates nicely with Microsoft."
"In SSIS, the scope is not only to handle ETL challenges, but it will allow us to do so many other tasks, such as DBA activities, scripting, calling any .exe or scripts, etc."
"It has the ability to be deployed into the cloud through Data Factory, and run completely as a software as a service in the cloud."
"The interface is very user-friendly."
"The debugging capabilities are great, particularly during data flow execution. You can look into the data and see what's going on in the pipeline."
"It is easy to set up the product."
"The setup was easy. All Microsoft products are easy to set up."
"If I could give any advice to the guys who are developing it, I would suggest them to really look at the enterprise features, such as being able to log what's going on, being able to capture the current state of processing, and being able to recover from error situations. So, there should be a focus on logging, recoverability, and monitoring. We should be able to monitor what's going on, and in case of any issues, we should be able to recover and restart processing and other things. For scalability and performance, I would probably suggest the Pushdown feature so that you can do the transformation directly on the data source. You do not need to do that calculation within the ETL server. For this, you should be aware of the type of data because each database or kind of storage, such as Hadoop, has its own ANSI standard or language, such as SQL. Microsoft, Oracle, and IBM have their own language. Based on the feedback that I have got, its initial setup takes some time. It could perhaps be simpler."
"We're in the process of switching to Informatica, and we need to work out data lineage and data profiling and to improve the quality of our data. SSIS, however, is not that compatible with Informatica. We managed to connect it to Informatica Metadata Manager, but we don't get good lineage, so we have to redo all our ETLs using the Informatica process in order to accept the proper data lineage."
"Sometimes, there are compatibility issues with some features. From time to time, I also face issues when trying to migrate. If I misconfigure things when I use Snapshot, the migration will fail.It can take a long time to migrate huge amounts of data, so it would be nice if that could be faster."
"You have to write push down join & lookup SQL to the database yourself via stored procedures or use of the SQL Task to get very high performance. That said, this is a common complaint for nearly all ETL tools on the market and those that offer an alternative such as Informatica offer them at a very expensive add-on price."
"Involving a data lake or data engineering aspects would be useful. While it is there, we need more features included."
"The performance of SSIS could improve when comparing it to Oracle Database."
"The solution could improve by having quicker release updates."
"In terms of its performance, it could be better. That could be something that would be easy and welcomed as an upgrade."
"The high prices attached to the product can be an area of concern where improvements are required."
Earn 20 points
CloverDX Designer is ranked 68th in Data Integration while SSIS is ranked 2nd in Data Integration with 69 reviews. CloverDX Designer is rated 7.0, while SSIS is rated 7.6. The top reviewer of CloverDX Designer writes "Simple, stable, and allows us to handle data from various sources, but needs enterprise features for logging, recoverability, and monitoring". On the other hand, the top reviewer of SSIS writes "Maintaining the solution and contacting its support team is easy". CloverDX Designer is most compared with , whereas SSIS is most compared with Informatica PowerCenter, Talend Open Studio, IBM InfoSphere DataStage, Oracle Data Integrator (ODI) and AWS Glue.
See our list of best Data Integration vendors.
We monitor all Data Integration reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.