CloverDX Designer vs SSIS comparison

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

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

"Overall, it's a good product."

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

"The technical support is very good."

"The UI is very user-friendly."

"The script component is very powerful, things that you cannot normally do, is feasible through C#."

"This solution is easy to implement, has a wide variety of connectors, has support for Visual Basic, and supports the C language."

"The debugging capabilities are great, particularly during data flow execution. You can look into the data and see what's going on in the pipeline."

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

"Sometimes we need to connect to AWS to get additional data sources, so we have to install some external LAN and not a regular RDBMS. We need external tools to connect. It would be great if SSIS included these tools. I'd also like some additional features for row indexing and data conversion."

"Microsoft's technical support has decreased in quality over the last few years, becoming less responsive and tending to pass problems on instead of solving them."

"A change in the metadata source cripples the whole ETL process, requiring each module to be manually reopened."

"Improving the login procedure would make our reporting easier on monitoring our ETL processes."

"We've had issues in terms of the amount of data that is transferred when we are scheduling."

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

"Performance could be better."

"The performance of SSIS could improve when comparing it to Oracle Database."

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

"The solution comes free of cost."

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

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

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

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

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

"Our license with SSIS is annual."