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."
"It's something I needed for bulk imports. I'm not a big fan of it, but I haven't seen anything better."
"It's already very user-friendly and has a good dashboard."
"The main value of any Microsoft product is the ease of use. You can achieve more with less time. That's what's beneficial for me. With many competitors, you might need to spend more time coming up with a solution because you have to focus on taking care of the product."
"The data reader is the most valuable feature."
"The interface is very user-friendly."
"The scalability of SSIS is good."
"The setup is straightforward. It's very easy to install."
"It is easy to set up the product."
"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."
"Future releases should improve the data lineage, as it currently is not good."
"It would be nice if you could run SSIS on other environments besides Windows."
"There were some issues when we tried to connect it to data storage. It was a connection issue."
"Sometimes we need to connect to AWS to get additional data sources, so we have to install some external LAN and not a regular RDBMS. We need external tools to connect. It would be great if SSIS included these tools. I'd also like some additional features for row indexing and data conversion."
"We have issues with SSIS connectors while extracting data from Excel sources."
"It's a legacy tool, that is nearing the end of its useful life."
"There was also not enough instructions from Microsoft in regards to this application or this technology, which can easily be improved upon."
"The solution could improve by having quicker release updates."
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.