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.5
Denodo boosts ROI by enabling rapid reporting, improving decision-making, and streamlining data integration for enhanced efficiency and customer satisfaction.
Sentiment score
6.5
SSIS is cost-effective, enhancing data management efficiency and integration with SQL Server, providing significant operational and financial benefits.
It provides a positive return on investment for those who can connect multiple data sources and make data-driven decisions easily.
Information Technology Manager at Lockheed Martin
If you don't need to write a whole ETL to make the data virtualization, you need way fewer people to write a query instead of writing an ETL pipeline.
Senior Backend Engineer at a pharma/biotech company with 51-200 employees
I have seen a return on investment, which showed up in improved customer satisfaction scores.
Vice President at a financial services firm with 10,001+ employees
The tool has made us tremendously more efficient and saved us a significant amount of money.
Manager, Data Operations at a manufacturing company with 5,001-10,000 employees
Using SSIS has proven cost-effective as there are no additional fees outside the SQL Server license, and it significantly enhances data management efficiency.
Managing Partner at Dynamis Informatica
 

Customer Service

Sentiment score
6.9
Denodo support is responsive and helpful, but some users face delays in bug resolution and unfriendliness in the portal.
Sentiment score
6.0
Users find Microsoft support adequate for critical issues but often use online resources and community support for minor ones.
They have a good methodology for learning how to use the tool.
Data Architecture and Engineering Specialist at coprocenva
Denodo's customer support team is very competent and responsive.
Datawarehouse & BI consultant, Owner, Mananging partner at NesCon B.V.
If we raise a ticket, it can be resolved or addressed within a reasonable time frame, so support is good.
Principal Architect at a manufacturing company with 10,001+ employees
The first line of support needs to be more knowledgeable.
Manager, Data Operations at a manufacturing company with 5,001-10,000 employees
 

Scalability Issues

Sentiment score
7.1
Denodo effectively scales across organizations, managing many users and data sources, but performance may vary with automation and configuration.
Sentiment score
6.7
SSIS is effective for small to medium enterprises but may face challenges with scalability and performance for large datasets.
For huge data requests, it cannot scale automatically; admin action is required.
Principal Architect at a manufacturing company with 10,001+ employees
Denodo's scalability comes into play specifically when there is data transfer.
Vice President at a financial services firm with 10,001+ employees
My client has almost 100 million records, and the performance was impacted in a way that required optimization.
Data Consultant at IT-Bots
I would rate the scalability of SSIS at a 7 because we are able to use various third-party items with it, allowing for functionality with a number of different things.
Tech Lead at a consultancy with 11-50 employees
 

Stability Issues

Sentiment score
7.0
Denodo is stable and reliable in production, with minor issues, praised for robustness but needs technical expertise for optimization.
Sentiment score
7.4
SSIS is highly rated for stability and performance, though minor issues and cloud discrepancies are occasionally noted by users.
I would rate it nine out of ten because it is very reliable, always performing as expected.
Datawarehouse & BI consultant, Owner, Mananging partner at NesCon B.V.
If JVM does not function properly, it may cause Denodo to fail to connect to different sources.
Technology Leader at eTCaaS
Denodo is stable and good.
Data Engineer at a consultancy with 11-50 employees
It processes large volumes of data quickly.
Managing Partner at Dynamis Informatica
 

Room For Improvement

Denodo should expand markets, improve UI and integration, address performance issues, and enhance support and documentation.
SSIS needs enhanced error logging, diverse data integration, user management, ease of use, scalability, and better documentation support.
Ensuring data caching is up to date is critical.
Director Software Engineer at a computer software company with 10,001+ employees
Denodo needs better communication on how the product can be deployed for specific solutions.
Datawarehouse & BI consultant, Owner, Mananging partner at NesCon B.V.
The system has dependencies on other environments, like JVM, which can affect its performance.
Technology Leader at eTCaaS
Within the South African context, if you are getting your enterprise agreement from First Technology, they don't provide support.
Managing Director at Knights Innovation Support Centre
SSIS has a difficult learning curve when dealing with complex transformations.
Managing Partner at Dynamis Informatica
The logging capabilities could be improved, particularly for error logging.
Manager, Data Operations at a manufacturing company with 5,001-10,000 employees
 

Setup Cost

Denodo pricing is high, suitable for larger enterprises, with variable costs and value-enhancing features, seen as fair by many.
SSIS is economical with SQL Server licenses, offering favorable pricing and integration, though add-ons may increase costs.
For small companies, it's not a solution that most small companies can afford.
Senior Backend Engineer at a pharma/biotech company with 51-200 employees
Denodo is considered pricey, limiting its use to large enterprises or government organizations that can afford its comprehensive setup.
Datawarehouse & BI consultant, Owner, Mananging partner at NesCon B.V.
Denodo's pricing is not affordable for small companies and is more suitable for medium to large enterprises.
Technology Leader at eTCaaS
Utilizing SSIS involves no extra charges beyond the SQL Server license.
Managing Partner at Dynamis Informatica
It was included in our licensing for SQL server, and our licensing for SQL server was extremely cheap, making it a very good price point for us.
Manager, Data Operations at a manufacturing company with 5,001-10,000 employees
However, it could be a bit cheaper.
Tech Lead at a consultancy with 11-50 employees
 

Valuable Features

Denodo excels in data integration, virtualization, governance, and scalability, enhancing user experience with API and query optimizations.
SSIS offers efficient, scalable ETL with seamless Microsoft integration, user-friendly interface, flexibility, and cost-effectiveness, enhancing data processes.
Denodo's ability to connect to multiple data sources and perform extract-transform-load (ETL) operations on the fly is noteworthy.
Director Software Engineer at a computer software company with 10,001+ employees
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.
Datawarehouse & BI consultant, Owner, Mananging partner at NesCon B.V.
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.
Principal Architect at a manufacturing company with 10,001+ employees
I would rate it at a 10 as it is highly reliable; we have never had any problems with it.
Manager, Data Operations at a manufacturing company with 5,001-10,000 employees
One of the best aspects of SSIS is that it is built into Microsoft SQL Server, so there are no additional costs involved.
Managing Partner at Dynamis Informatica
SSAS is included in the base installation of SQL Server.
Managing Director at Knights Innovation Support Centre
 

Categories and Ranking

Denodo
Ranking in Data Integration
6th
Average Rating
8.0
Reviews Sentiment
6.7
Number of Reviews
42
Ranking in other categories
Data Virtualization (1st), Cloud Data Integration (5th), Data Management Platforms (DMP) (3rd), AI Data Analysis (3rd)
SSIS
Ranking in Data Integration
1st
Average Rating
7.6
Reviews Sentiment
6.7
Number of Reviews
76
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of March 2026, in the Data Integration category, the mindshare of Denodo is 1.3%, down from 1.7% compared to the previous year. The mindshare of SSIS is 3.6%, down from 7.9% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Data Integration Mindshare Distribution
ProductMindshare (%)
SSIS3.6%
Denodo1.3%
Other95.1%
Data Integration
 

Featured Reviews

Patel-Dhulva - PeerSpot reviewer
Information Technology Manager at Lockheed Martin
Data virtualization has unified siloed sources and now supports real-time decisions
The best features Denodo offers stand out to me as the ability to develop REST web services fast and easily, create and combine new views, integrate different sources of data, and connect with other tools seamlessly. When I mention fast and easy creation of views and integration, I love the agile data provisioning and integration, where Denodo provides a comprehensive set of capabilities for implementing logical data integration, management, and delivery, which in turn enables agile data analytics and an informed decision-making process to be smooth. I also appreciate the performance optimization with AI, which improves performance optimization through the integration of artificial intelligence capabilities. Furthermore, I appreciate the unified security and governance, where it addresses the need for an organization to effectively manage security, data privacy, and data protection easily, offering a centralized platform that allows the application of governance policies and fine-grained security controls. Another feature I would add about Denodo is that it also provides a single point of control where we can establish security controls over the entire infrastructure and gain visibility into all our data assets. Denodo has positively impacted my organization as since we started using this tool, it has been very helpful because it is a huge advantage that we can connect to many different databases to provide data rapidly and accurately and also gain insights, which helps us to make data-driven decisions easily. It has proven to be a valuable environment for deploying data virtualization solutions, and its user community is active in finding and fixing issues more accurately. Through data insights from Denodo, we have been able to improve our decision making, which helps to better communication between the stakeholders thanks to the real-time experience. It also saves a lot of time.
Chris Farris - PeerSpot reviewer
Manager, Data Operations at a manufacturing company with 5,001-10,000 employees
User-friendly interface facilitates efficient data migration and reduces operational overhead
Its usability and ease of use are standout features. It is really easy to use - almost too easy at times. Users don't have to be experts to use their tool set and utilize the clicking mechanisms, drop down boxes, and other features to build a package and run it. The configuration is very easy and the system is very stable. I would rate it at a 10 as it is highly reliable; we have never had any problems with it. Very little maintenance is required on my side. While you need to keep the product up to date, the maintenance requirements are minimal. SSIS integrates with all Microsoft tools seamlessly. We have used it against Oracle, DB2 and SQL. It integrates and can move data around from any data platforms, making it very diverse in that standpoint. It is a very robust tool that can work with many data sources, and its main strength is that it is extremely easy to use.
report
Use our free recommendation engine to learn which Data Integration solutions are best for your needs.
884,873 professionals have used our research since 2012.
 

Comparison Review

it_user90069 - PeerSpot reviewer
BI Expert at a healthcare company with 1,001-5,000 employees
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
21%
Manufacturing Company
12%
Government
7%
Computer Software Company
7%
Financial Services Firm
15%
Computer Software Company
9%
Government
8%
Manufacturing Company
6%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business16
Midsize Enterprise6
Large Enterprise21
By reviewers
Company SizeCount
Small Business27
Midsize Enterprise19
Large Enterprise57
 

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?
Pricing is pretty reasonable, so I would rate it at a 5. However, it could be a bit cheaper.
 

Comparisons

 

Also Known As

Denodo for AWS
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: March 2026.
884,873 professionals have used our research since 2012.