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 feature is the performance. Denodo is very useful, especially in this huge pharma environment. I've found that older SAP solutions were very tightly coupled to each other, which resulted in data restrictions. Getting data from different sources was tough and tedious. Compared to these old solutions, Denodo is very easy to work with for the analytical team. Now that we've implemented this virtualization layer, we are capable of getting the data very smoothly. We implemented a very small unit, but the performance and integration have been very good."
"Overall, the product works quite well and has a good set of features."
"In PL/SQL, first you need to gather all the data and then start writing the file, but in Denodo you fetch the data and write the data simultaneously. So, for example, if you have 1 million or 2 million records, you don't have to wait to fetch all of the 2 million; you can keep on fetching and writing in the file simultaneously."
"It is easy to virtualize data using the solution."
"This solution provides us with the ability to sync data, and make it available for anyone to use across the business."
"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 most valuable features of Denodo are the extraction option for adapters, and there are many things for the views, that are cached. Denodo is not storing the data, it looks first to tune the query, and these things are for the agents."
"Data mining is one of the valuable features. We're able to connect all of the data sources with the installed driver, so that is a good advantage in Denodo. Being able to join the tables and view them is also valuable."
"The product's deployment phase is easy."
"The performance is good."
"SSIS' most valuable feature is its reporting services."
"The workflow features have been very valuable. You can have automated workflows and all the steps are controlled. The workflow functionality of integration services is excellent."
"There are many good features in this solution including the data fields, database integration, support for SQL views, and the lookups for matching information."
"It is easy to set up. The deployment is also very quick."
"It is also easy to learn and user-friendly. Microsoft is also good in terms of technical support. They have built a large community all over the world."
"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."
"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 dropdown menus feel antiquated to me, and the administrative portals need improvement."
"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."
"Denodo currently integrates with ChatGPT, but the ability to manage and utilize them directly within Denodo would be a significant improvement."
"Documentation needs to be improved"
"The support is not the best and should be improved."
"We can't scale it to meet digital requirements."
"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."
"We In upgrading SSIS, we encountered challenges fixing SQL Server and performance issues, including problems during a failover in our data warehouse."
"We would like the solution to be expanded so that it is available for other platforms than just Microsoft."
"There were some issues when we tried to connect it to data storage. It was a connection issue."
"SSIS sometimes hangs, and there are some problems with servers going down after they've been patched."
"We have a stability problem because when something works, it works one time. The next time, it doesn't work."
"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."
"We'd like them to develop data exploration more."
"In terms of its performance, it could be better. That could be something that would be easy and welcomed as an upgrade."
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 Alteryx Designer, 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.
