CloverDX Designer vs SSIS comparison

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

"I have used most of the standard SQL features, but the ones that stand out are the Data Flows and Bulk Import."

"It is easy to set up the product."

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

"In SSIS, the scope is not only to handle ETL challenges, but it will allow us to do so many other tasks, such as DBA activities, scripting, calling any .exe or scripts, etc."

"The solution is easy to use and developer friendly."

"The most valuable feature of SSIS is that it can handle real complex transformations."

"SSIS' best feature is SFTP connectivity."

"Data Flows are the main component we use. These can range from a simple source to sink ETL, to many source to many sink dataflows."

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

"SSIS doesn't have a very good user interface, but if you can work with it, it'll provide you with almost all of the functionality."

"It hangs a lot of the time."

"The security could be improved, as it is more important in our context."

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

"When I compare Talend and SSIS, Talend provides more features. With Talend, we can handle a large volume of data. Talend is usually used to treat a large volume of data, which makes it better than SSIS on the data side. Talend also has a very good Talend Management Console to schedule the jobs and do other things. It can also be easily connected to version control tools such as GitHub or SVN. The last time I used SSIS, it was connected through TSS for the Windows Console version. I am not sure it has been improved or not. If it is not improved, Microsoft should improve it. They should change the product to provide another console."

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

"Integration and the user interface are areas with certain shortcomings that require some improvements."

"The solution should work on the GPU, graphical processing unit. There should also be piping integration available."

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

"SSIS is fairly well-priced - I would rate it at four out of five."

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

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

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

"This solution is included with the MSSQL server package."

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

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

"It comes bundled with other solutions, which makes it difficult to get the price on the specific product."