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 performance is good."

"It is also easy to learn and user-friendly. Microsoft is also good in terms of technical support. They have built a large community all over the world."

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

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

"The most valuable thing is that it is easy to connect with Microsoft tools. In Europe, particularly in France, a lot of companies use Excel, SQL Server, and other Microsoft tools, and it is easier to connect SSIS with Microsoft tools than other products."

"The most valuable feature of SSIS is its ease of use. It is easier to use than other applications."

"The interface is very user-friendly."

"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 solution could improve by having quicker release updates."

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

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

"Future releases should improve the data lineage, as it currently is not good."

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

"SSIS is cumbersome despite its drag-and-drop functionality. For example, let's say I have 50 tables with 30 columns. You need to set a data type for each column and table. That's around 1,500 objects. It gets unwieldy adding validation for every column. Previously, SSIS automatically detected the data type, but I think they removed this feature. It would automatically detect if it's an integer, primary key, or foreign key column. You had fewer problems building the model."

"SSIS should be made a little bit more intuitive and user-friendly because it needs an expert-level person to work on it."

"Options for scaling could be improved."

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

"We have an enterprise license for this solution."

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

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

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

"Our license with SSIS is annual."

"The solution comes free of cost."

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

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