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."
"Like most Microsoft products, SSIS is user-friendly and easy to use."
"It is easy to set up the solution."
"This solution is easy to implement, has a wide variety of connectors, has support for Visual Basic, and supports the C language."
"The setup was easy. All Microsoft products are easy to set up."
"SSIS is an easy way to do data integration from various data sources. It doesn't matter whether it's a database, flat files, XML, or Web API. It can talk to the and join them all together."
"The most important features are it works well and provides self-service BI."
"The most valuable feature of SSIS is that it can handle real complex transformations."
"The scalability of SSIS is good."
"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."
"I would also like to see full integration with our BI because then our full load of data will be available in our organization. They should incorporate an ATL process."
"SSIS sometimes hangs, and there are some problems with servers going down after they've been patched."
"In terms of its performance, it could be better. That could be something that would be easy and welcomed as an upgrade."
"I have a tool called ZappySys. I need that tool to cut down on the complexity of SSIS. That tool really helps with a quick turnaround. I can do things quickly, and I can do things accurately. I can get better reporting on errors."
"It needs more integration tools, so you can connect to different sources."
"It hangs a lot of the time."
"We purchase an add on called task factory primarily to allow bulk delete, update and upsert capability. I'd like to see this be part of the standard package."
"Options for scaling could be improved."
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.