CloverDX Designer vs SSIS comparison

"Its simplicity and the way it handles graphs are the most valuable features."

"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."

"I have used most of the standard SQL features, but the ones that stand out are the Data Flows and Bulk Import."

"The data reader is the most valuable feature."

"The solution is stable."

"It is easy to set up the solution."

"We like that this solution includes a developer edition, free of charge, to allow for training."

"With this solution, there is the potential to expand, so that you can immediately write code onto the SQL server."

"The most valuables features are the relatively short learning curve, and the automation capabilities provided through the BIML add-in for SSDT."

"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."

"SSIS is not stable."

"Tuning using this solution requires extensive expertise to improve performance."

"I would like to see better integration with Power BI."

"This solution needs full support for real-time processing."

"Microsoft's technical support has decreased in quality over the last few years, becoming less responsive and tending to pass problems on instead of solving them."

"In terms of its performance, it could be better. That could be something that would be easy and welcomed as an upgrade."

"We'd like them to develop data exploration more."

"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."

"Its price and value for money would be okay for our purpose if there were some additional features."

"It would be beneficial if the solution had a less costly cloud offering."

"All of my clients have this product included as part of their Microsoft license."

"I'm not involved in licensing details, but SSIS provides value to our organization by simplifying data management tasks."

"SSIS is fairly well-priced - I would rate it at four out of five."

"SSIS' licensing is a little high, but it gives good value for money."

"The solution is economical. You don't have to worry about the pricing as long as you're installing both services on the same server."

"The solution comes free of cost."

"The solution is available at a lesser price than that of Informatica."