CloverDX Designer vs SSIS comparison

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

"Overall, it's a good product."

"The performance and stability are good."

"The most valuable features of SSIS are that it works with the query language and it can import data from different sources."

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

"The most valuable thing is that it is easy to connect with Microsoft tools. In Europe, particularly in France, a lot of companies use Excel, SQL Server, and other Microsoft tools, and it is easier to connect SSIS with Microsoft tools than other products."

"The product's deployment phase is easy."

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

"SSIS' best feature is SFTP connectivity."

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

"We'd like them to develop data exploration more."

"There was also not enough instructions from Microsoft in regards to this application or this technology, which can easily be improved upon."

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

"Future releases should improve the data lineage, as it currently is not good."

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

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

"We have a stability problem because when something works, it works one time. The next time, it doesn't work."

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

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

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

"People have to opt for a perpetual-based licensing model."

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

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

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

"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 included with the MSSQL server package."