CloverDX Designer vs SSIS comparison

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

"It is easy to set up the product."

"Built in reports show package execution and messages. Logging can also be customized so only what is needed is logged. There is also an excellent logging replacement called BiXpress that provides both historical and real-time monitoring which is more efficient and much more robust than the built-in logging capabilities. And none of this requires custom coding to make it useful unlike many other ETL tools."

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

"With this solution, there is the potential to expand, so that you can immediately write code onto the SQL server."

"I like that this solution is very scalable, accommodating large datasets and various types of servers. It integrates with most common database servers and allows for customization through coding, including complex scripts. Compared to Alteryx Designer, SSIS offers more customization. Its data cleaning capabilities are highly accurate because we can run tests as data is loaded, ensuring it meets all requirements before reaching the final destination. The ability to write custom SQL and C# code within SSIS packages is its greatest feature."

"The scalability of SSIS is good."

"The interface is very user-friendly."

"The most valuable feature of the solution is performance."

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

"Involving a data lake or data engineering aspects would be useful. While it is there, we need more features included."

"Microsoft should offer an on-premises support warranty for those using that deployment. They seem to be withdrawing from on-premises options."

"SSIS sometimes hangs, and there are some problems with servers going down after they've been patched."

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

"Video training would be a helpful addition."

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

"SSIS can improve in handling different data sources like Salesforce connectivity, Oracle Cloud's connectivity, etc."

"I would like to see more standard components out of the box, such as SFTP, and Data Compression components."

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

"The solution comes free of cost."

"The solution is economical. You don't have to worry about the pricing as long as you're installing both services on the same server."

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

"t's incredibly cost effective, easy to learn the basics quickly (although like all ETL tools requires the traditional learning curve to get good at) and has an immense user base."

"We have an enterprise license for this solution."

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

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

"Depending on the arrangement that a certain company has with Microsoft, it may supply the permanent license that is included in the SQL server license, or it may be a time-bound license if it is a partner license or other enterprise license."