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."
"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."
"Denodo is lightweight in terms of how it leads you to combine your discrete data systems at one spot."
"The ability to transfer data is very valuable."
"The most valuable features are query optimization and the single language independence from the sources we're using to catch data."
"It is a go-to tool for data virtualization. The virtualization and data catalog are the features of why we chose Denodo."
"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."
"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."
"The initial setup of this solution is very straightforward."
"SSIS is easy to use."
"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."
"I have found its most valuable features to be its package management capabilities and the flexibility it offers in designing workflows."
"The scalability of SSIS is good."
"The solution is stable."
"It is easily scheduled and integrates well with SQL Server and SQL Server Agent jobs."
"The most valuable features for our company are the flexibility and the quick turn around time in producing simple ETL solutions."
"It would be good if the solution provided a much-needed cellular platform."
"Denodo currently integrates with ChatGPT, but the ability to manage and utilize them directly within Denodo would be a significant improvement."
"The solution should have its own acceleration technology."
"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."
"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."
"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."
"Sometimes, Windows-related functions do not work properly in Denodo. The analytic functions in SQL do not work properly."
"We would like this solution to be more universally user-friendly. At present it is really only aimed at IT specialists."
"We've had issues in terms of the amount of data that is transferred when we are scheduling."
"The security could be improved, as it is more important in our context."
"Improving the login procedure would make our reporting easier on monitoring our ETL processes."
"We purchase an add on called task factory primarily to allow bulk delete, update and upsert capability. I'd like to see this be part of the standard package."
"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."
"We're in the process of switching to Informatica, and we need to work out data lineage and data profiling and to improve the quality of our data. SSIS, however, is not that compatible with Informatica. We managed to connect it to Informatica Metadata Manager, but we don't get good lineage, so we have to redo all our ETLs using the Informatica process in order to accept the proper data lineage."
"The solution should work on the GPU, graphical processing unit. There should also be piping integration available."
"This solution needs full support for real-time processing."
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.