CloverDX Designer vs SSIS comparison

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

"Like most Microsoft products, SSIS is user-friendly and easy to use."

"It's a competent product."

"The performance is good."

"The solution is stable."

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

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

"The setup is straightforward. It's very easy to install."

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

"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 performance of this solution is not as good as other tools in the market."

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

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

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

"We have issues with SSIS connectors while extracting data from Excel sources."

"The logging capabilities could be improved, particularly for error logging."

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

"I would also like to see full integration with our BI because then our full load of data will be available in our organization. They should incorporate an ATL process."

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

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

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

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

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

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

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

"The solution comes free of cost."

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