Try our new research platform with insights from 80,000+ expert users

Denodo vs SSIS comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Dec 19, 2024

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

ROI

Sentiment score
6.8
Denodo improved efficiency, ROI, decision-making, reduced churn, and increased loyalty, significantly enhancing data processing and systems replacement.
Sentiment score
7.3
SSIS offers cost-effective data management with no extra fees, but some users prefer alternatives with a larger budget.
Using SSIS has proven cost-effective as there are no additional fees outside the SQL Server license, and it significantly enhances data management efficiency.
 

Customer Service

Sentiment score
7.2
Denodo's support is praised for responsiveness and expertise but criticized for slow bug fixes and lack of proactive engagement.
Sentiment score
6.0
Users find SSIS support mixed; many prefer online solutions and community forums over Microsoft’s challenging and costly support.
If we raise a ticket, it can be resolved or addressed within a reasonable time frame, so support is good.
They have a good methodology for learning how to use the tool.
Denodo's customer support team is very competent and responsive.
 

Scalability Issues

Sentiment score
7.5
Denodo is scalable and integrates widely but may require additional management for performance and cost efficiency.
Sentiment score
6.8
SSIS is scalable for various enterprises, requiring proper configuration for optimal performance, but may lack compared to alternatives.
For huge data requests, it cannot scale automatically; admin action is required.
While the solution scales well on a single machine, I have doubts about its scalability when deployed as part of a Java component cluster.
Its complexity in configuring and the requirement to install different connectors for different sources affects its scalability.
 

Stability Issues

Sentiment score
6.9
Denodo offers robust stability with minor bugs; high reliability improves in the latest version despite complex scenario challenges.
Sentiment score
7.5
SSIS is stable and reliable, though occasional performance issues are noted; proper infrastructure enhances its effectiveness.
If JVM does not function properly, it may cause Denodo to fail to connect to different sources.
I would rate it nine out of ten because it is very reliable, always performing as expected.
It processes large volumes of data quickly.
 

Room For Improvement

The system needs comprehensive improvements in functionality, integration, support, UI, scalability, security, documentation, and external tool compatibility.
SSIS needs user interface, performance, compatibility, integration, error logging, scalability improvements, and better real-time, security, and API support.
The system has dependencies on other environments, like JVM, which can affect its performance.
Ensuring data caching is up to date is critical.
Denodo needs better communication on how the product can be deployed for specific solutions.
Within the South African context, if you are getting your enterprise agreement from First Technology, they don't provide support.
SSIS has a difficult learning curve when dealing with complex transformations.
 

Setup Cost

Denodo pricing is costly, designed for large enterprises, with complex licensing and costs varying by customer needs.
SSIS is economical for SQL Server users, offering value without extra setup costs compared to pricier ETL tools.
Denodo is considered pricey, limiting its use to large enterprises or government organizations that can afford its comprehensive setup.
Denodo's pricing is not affordable for small companies and is more suitable for medium to large enterprises.
Utilizing SSIS involves no extra charges beyond the SQL Server license.
 

Valuable Features

Denodo is praised for data virtualization, efficiently integrating and managing diverse sources with strong security, introspection, and visualization.
SSIS is popular for its ease of use, scalability, integration, cost-effectiveness, and powerful ETL capabilities with Microsoft products.
Denodo's ability to connect to multiple data sources and perform extract-transform-load (ETL) operations on the fly is noteworthy.
The most valuable feature of Denodo is its uniformity of self-site data access types, which allows it to connect to almost any storage technology and feed it transparently.
Denodo supports SQL base, so if you want to join two tables or two views, you can use SQL, which is an advantage as most developers or business people know SQL.
The challenge lies in Microsoft withdrawing a lot of the qualifications and watering down its emphasis, leading to a perception that this is supposed to be an elite product.
One of the best aspects of SSIS is that it is built into Microsoft SQL Server, so there are no additional costs involved.
 

Categories and Ranking

Denodo
Ranking in Data Integration
9th
Average Rating
8.0
Reviews Sentiment
6.8
Number of Reviews
37
Ranking in other categories
Data Virtualization (1st), Cloud Data Integration (5th)
SSIS
Ranking in Data Integration
2nd
Average Rating
7.6
Reviews Sentiment
6.8
Number of Reviews
74
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of July 2025, in the Data Integration category, the mindshare of Denodo is 1.9%, down from 2.0% compared to the previous year. The mindshare of SSIS is 7.4%, down from 7.7% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Data Integration
 

Featured Reviews

Atanu Chatterjee - PeerSpot reviewer
Data virtualization and integration enabled while caching and scalability room for improvement
In terms of improvements for Denodo, regarding performance, in cases where there are multiple virtualizations—such as reading from one Denodo view that is virtualized, and from that view there's also virtualization, and another team is reading from that view—if multiple virtualizations happen with no caching in between, it becomes slow. This occurs because it is cascading; whenever at the top level someone is reading data, that request is getting cascaded to the nth level, causing issues, especially in cases such as Power BI reports. We need to consider implementing some persistent layer in between. The scaling process should improve because many things are getting automated. The scale-out part needs to be automated, though I am uncertain whether Denodo has already implemented that feature.
Sean Achim - PeerSpot reviewer
Building impactful organizational KPIs with ease and precision
Stability is rated at 10. One other important aspect I appreciate is that SSAS is included in the base installation of SQL Server. Obviously, it requires installation, but it is readily available, which is a major strength. It's all about setting it up, configuring it, and then using it. If there are additional costs associated with it or separating it as a second product, that would be a disadvantage. The area of improvement is really in education. Microsoft is trying to push everything as a Power BI solution or trying to get people to solve the problems which are solved with SSAS in another space in Power BI, or in Power Pivot, is not enough. There's not enough marketing, conversation, and support around that space. As a result, we end up with people not understanding that you need to build your models correctly, and then they try to model everything inside of Power BI, or another visualization tool, without first building the data model. That leads people to consider alternate solutions because SAP and others argue that their whole thing is in memory, and they disseminate misleading information. Additionally, what would be very helpful is local user group developments, so getting people around the table and teaching them how to use it. That is the biggest problem; it's not the technology itself. The challenge lies in Microsoft withdrawing a lot of the qualifications and watering down its emphasis, leading to a perception that this is supposed to be an elite product.
report
Use our free recommendation engine to learn which Data Integration solutions are best for your needs.
860,592 professionals have used our research since 2012.
 

Comparison Review

it_user90069 - PeerSpot reviewer
Feb 20, 2014
Informatica PowerCenter vs. Microsoft SSIS - each technology has its advantages but also have similarities
Technology has made it easier for businesses to organize and manipulate data to get a clearer picture of what’s going on with their business. Notably, ETL tools have made managing huge amounts of data significantly easier and faster, boosting many organizations’ business intelligence operations…
 

Top Industries

By visitors reading reviews
Financial Services Firm
22%
Manufacturing Company
10%
Computer Software Company
9%
Government
7%
Financial Services Firm
19%
Computer Software Company
11%
Government
8%
Manufacturing Company
6%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

Does Denodo provide useful data virtualization education? Is it useful to attend their training?
If you are a Denodo user, it makes sense to undergo their training. Different types of professionals can benefit from it, including administrators, developers, and architects. If you are keen on i...
In experience, what might Denodo be lacking or need improvement on?
I like Denodo a lot. It offers quick and easy web service deployment within minutes. There are not any flaws that I think make the product less good or effective. The only thing I can point out is...
Which industries can benefit from Denodo the most?
Denodo is suitable for pretty much all sectors that deal with: Big data Cloud solutions Data governance Logical data fabric Master data management In my opinion, organizations in different fields...
Which is better - SSIS or Informatica PowerCenter?
SSIS PowerPack is a group of drag and drop connectors for Microsoft SQL Server Integration Services, commonly called SSIS. The collection helps organizations boost productivity with code-free compo...
What do you like most about SSIS?
The product's deployment phase is easy.
What is your experience regarding pricing and costs for SSIS?
Utilizing SSIS involves no extra charges beyond the SQL Server license. It's an economical choice for my clients.
 

Comparisons

 

Also Known As

No data available
SQL Server Integration Services
 

Overview

 

Sample Customers

Autodesk, VHA, AAA, Sumitomo Mitsui Trust Bank, Caterpillar, European Chemical Agency, Seagate, Nationwide, Time Warner Cable, Pantex, Inditex, BNSF Railways, Vodafone, CIT Group, Jazztel, Wolters Kluwer, Telefonica, TransAlta
1. Amazon.com 2. Bank of America 3. Capital One 4. Coca-Cola 5. Dell 6. E*TRADE 7. FedEx 8. Ford Motor Company 9. Google 10. Home Depot 11. IBM 12. Intel 13. JPMorgan Chase 14. Kraft Foods 15. Lockheed Martin 16. McDonald's 17. Microsoft 18. Morgan Stanley 19. Nike 20. Oracle 21. PepsiCo 22. Procter & Gamble 23. Prudential Financial 24. RBC Capital Markets 25. SAP 26. Siemens 27. Sony 28. Toyota 29. UnitedHealth Group 30. Visa 31. Walmart 32. Wells Fargo
Find out what your peers are saying about Denodo vs. SSIS and other solutions. Updated: May 2025.
860,592 professionals have used our research since 2012.