CloverDX Designer vs SSIS comparison

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

"It has the ability to be deployed into the cloud through Data Factory, and run completely as a software as a service in the cloud."

"The reporting on the solution is perfect. I didn't expect to see reporting features, but they are great."

"The return on investment has been very high; the tool has made us tremendously more efficient and saved us a significant amount of money, though I cannot put an exact figure on it."

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

"It's saved time using visualization descriptions."

"The most valuable aspect of this solution is that it is simple to use and it offers a flexible custom script task."

"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 UI is very user-friendly."

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

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

"SSIS could be integrated with more services, such as Power BI, to make the reporting structures more user-friendly."

"There's no support for it at all. If you haven't undergone the qualifications, you wouldn't even know you should phone someone."

"The performance of this solution is not as good as other tools in the market."

"In terms of its performance, it could be better. That could be something that would be easy and welcomed as an upgrade."

"There are a lot of things that Microsoft could improve in relation to SSIS. One major problem we faced was when attempting to move some Excel files to our SQL Server. The Excel provider has a limitation that prevents importing more than 255 columns from a particular Excel file to the database. This restriction posed a significant issue for us."

"The interface could use improvement, as well as the administrative tools. Jobs fail from time to time for different reasons. It's not a problem with Microsoft, or SSIS itself. The problems are external, but to find the problems and analyze them it takes too much time."

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

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

"We have an enterprise license for this solution."

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

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

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

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

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

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