We performed a comparison between Denodo and SSIS based on real PeerSpot user reviews.
Find out in this report how the two Data Integration solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."The most valuable aspects of this solution are the short time frame in which you can deliver and connect."
"It allows a lot of traceability and you can decide what data you want to collect"
"Access to numerous forums and internet information."
"Denodo is very stable."
"The best thing about Denodo is that creating and deploying a web service can be done in about 10 minutes, compared to a whole day when it comes to other solutions (such as when deploying with Java and AWS)."
"The performance and the speed to market are the most valuable features of this solution."
"The most valuable feature is Data Catalogs."
"The ability to connect to a lot of different sources."
"The most valuables features are the relatively short learning curve, and the automation capabilities provided through the BIML add-in for SSDT."
"The most valuable feature of SSIS is that it can handle real complex transformations."
"The most valuable aspect of this solution is that it is simple to use and it offers a flexible custom script task."
"The reporting on the solution is perfect. I didn't expect to see reporting features, but they are great."
"The interface is very user-friendly."
"The debugging capabilities are great, particularly during data flow execution. You can look into the data and see what's going on in the pipeline."
"This solution is easy to implement, has a wide variety of connectors, has support for Visual Basic, and supports the C language."
"With this solution, there is the potential to expand, so that you can immediately write code onto the SQL server."
"The solution should have its own acceleration technology."
"Denodo can improve usage management-related aspects. If you deal with the mini views, it gets stuck. The performance is very slow when we go with a large number of views and high volume."
"User-specific security at the column and row levels needs to be improved. Instead of applying security at every individual level, it would be better if it were at the group or tier level. It will save a lot of time."
"It would be good if the solution provided a much-needed cellular platform."
"It would be beneficial to make sure that the team that will be using Denodo has some kind of training on how to use the product at least a month beforehand, and there could even be some kind of feedback or Q&A sessions to go along with the training. If Denodo were able to provide this kind of training, it would be very helpful to users in insurance and banking companies because the staff are typically older and not always technically-minded."
"Denodo has some difficulty supporting large numbers of records."
"The integration could use improvement, it's a lot of non-speed line processes that we have discovered, in the country. The configurations could use a lot more improvement."
"I would like to see a connectivity option with third-party apps, for example, JDBC, and ODBC drivers. Currently, we need to install it separately from the Denodo side and then connect it."
"The high prices attached to the product can be an area of concern where improvements are required."
"Involving a data lake or data engineering aspects would be useful. While it is there, we need more features included."
"We'd like more integration capabilities."
"I have a tool called ZappySys. I need that tool to cut down on the complexity of SSIS. That tool really helps with a quick turnaround. I can do things quickly, and I can do things accurately. I can get better reporting on errors."
"There is connectivity with other databases, however, this is the most significant issue that has to be addressed."
"Microsoft's technical support has decreased in quality over the last few years, becoming less responsive and tending to pass problems on instead of solving them."
"In terms of its performance, it could be better. That could be something that would be easy and welcomed as an upgrade."
"The performance of this solution is not as good as other tools in the market."
Denodo is ranked 12th in Data Integration with 29 reviews while SSIS is ranked 2nd in Data Integration with 69 reviews. Denodo is rated 7.8, while SSIS is rated 7.6. The top reviewer of Denodo writes "Saves our underwriters' time with data virtualization, but could provide more learning resources". On the other hand, the top reviewer of SSIS writes "Maintaining the solution and contacting its support team is easy". Denodo is most compared with Azure Data Factory, AWS Glue, Delphix, Mule Anypoint Platform and AtScale Adaptive Analytics (A3), whereas SSIS is most compared with Informatica PowerCenter, Talend Open Studio, IBM InfoSphere DataStage, Oracle Data Integrator (ODI) and AWS Glue. See our Denodo vs. SSIS report.
See our list of best Data Integration vendors and best Cloud Data Integration vendors.
We monitor all Data Integration reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.