CloverDX Designer vs SSIS comparison

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

"The solution is stable."

"The product's deployment phase is easy."

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

"There are many good features in this solution including the data fields, database integration, support for SQL views, and the lookups for matching information."

"It has the ability to be deployed into the cloud through Data Factory, and run completely as a software as a service in the cloud."

"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 most valuable feature of SSIS is that it can handle real complex transformations."

"The simplicity of the solution is great. The solution also offers excellent integration."

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

"Options for scaling could be improved."

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

"There were some issues when we tried to connect it to data storage. It was a connection issue."

"SSIS is not stable."

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

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

"Generic processes should be used instead of custom code for each table."

"The solution could improve on integrating with other types of data sources."

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

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

"We have an enterprise license for this solution."

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

"Based on my experience and understanding, Talend comes out to be a little bit expensive as compared to SSIS. The average cost of having Talend with Talend Management Console is around 72K per region, which is much higher than SSIS. SSIS works very well with Microsoft technologies, and if you have Microsoft technologies, it is not really expensive to have SSIS. If you have SQL Server, SSIS is free."

"The solution comes free of cost."

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

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