CloverDX Designer vs SSIS comparison

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

"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 valuable aspect of this solution is that it is simple to use and it offers a flexible custom script task."

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

"Despite the complexity when dealing with advanced transformations, it is straightforward for simple data movements, and the performance is excellent."

"The reporting on the solution is perfect. I didn't expect to see reporting features, but they are great."

"The return on investment has been very high; the tool has made us tremendously more efficient and saved us a significant amount of money, though I cannot put an exact figure on it."

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

"SSIS' best feature is SFTP connectivity."

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

"We In upgrading SSIS, we encountered challenges fixing SQL Server and performance issues, including problems during a failover in our data warehouse."

"I would like to see more features in terms of the integration with Azure Data Factory."

"There is connectivity with other databases, however, this is the most significant issue that has to be addressed."

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

"The logging capabilities could be improved, particularly for error logging."

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

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

"SSIS can improve by the minimum code requirements in stored procedures and exporting data is difficult. They could make it easier, it should be as easy as it is to import data."

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

"We purchased the standard edition of SQL Server and SSIS came with it free of charge."

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

"People have to opt for a perpetual-based licensing model."

"My advice is to look at what your configuration will be because most companies have their own deals with Microsoft."

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

"We have an enterprise license for this solution."

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

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