CloverDX Designer vs SSIS comparison

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

"The most valuable feature of the solution is performance."

"The ability of SSIS to transform and transport data is extremely valuable to me. It allows for intelligent extraction and manipulation of data during the process. Improved error handling would enhance ETL processes further. I haven't directly utilized the data flow components but they seem capable of supporting complex data integration needs."

"It is easy to set up. The deployment is also very quick."

"SSIS is easy to use."

"The most valuable features for our company are the flexibility and the quick turn around time in producing simple ETL solutions."

"Built in reports show package execution and messages. Logging can also be customized so only what is needed is logged. There is also an excellent logging replacement called BiXpress that provides both historical and real-time monitoring which is more efficient and much more robust than the built-in logging capabilities. And none of this requires custom coding to make it useful unlike many other ETL tools."

"The product's deployment phase is easy."

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

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

"The security could be improved, as it is more important in our context."

"It's a legacy tool, that is nearing the end of its useful life."

"SSIS has a difficult learning curve when dealing with complex transformations."

"It hangs a lot of the time."

"Involving a data lake or data engineering aspects would be useful. While it is there, we need more features included."

"There's no support for it at all. If you haven't undergone the qualifications, you wouldn't even know you should phone someone."

"SSIS sometimes hangs, and there are some problems with servers going down after they've been patched."

"We have a stability problem because when something works, it works one time. The next time, it doesn't work."

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

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

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

"t's incredibly cost effective, easy to learn the basics quickly (although like all ETL tools requires the traditional learning curve to get good at) and has an immense user base."

"We have an enterprise license for this solution."

"SSIS is a cheaper option compared to the cost of other ETL tools."

"Our license with SSIS is annual."

"This solution is included with the MSSQL server package."

"If you don't want to pay a lot of money, you can go for SSIS, as its open-source version is available. When it comes to licensing, SSIS can be expensive."