CloverDX Designer vs SSIS comparison

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

"I have found its most valuable features to be its package management capabilities and the flexibility it offers in designing workflows."

"The initial setup of this solution is very straightforward."

"The performance and stability are good."

"It's a competent product."

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

"The product's deployment phase is easy."

"The setup was easy. All Microsoft products are easy to set up."

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

"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 performance of SSIS could improve when comparing it to Oracle Database."

"SSIS has room for improvement, mainly because the overall package can be buggy. It often locks up, requiring a restart, which is annoying. However, since it's free, we tolerate these performance issues. I'd like to see better debugging tools in future releases and improvements in API calls; It would be helpful if SSIS had a built-in API engine so we wouldn't have to rely solely on database connections."

"I would like to see better technical documentation because many times information is missing."

"It's difficult to refactor SSIS. It gets cumbersome to reuse the solution."

"At one point, we did have to purchase an add-on."

"Need to improve error logging although it does provide error logs but there is still more room for improvement in this area."

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

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

"This solution has provided an inexpensive tool, and it is easy to find experienced developers."

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

"It comes bundled with other solutions, which makes it difficult to get the price on the specific product."

"This solution is a free of charge addition to our SQL licence. However, the only way this tool can be utilized is as a feature of the SQL licence, which may make it unattractive to organizations who don't wish to purchase the wider-ranging licence."

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

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

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

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