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
5.7
Organizations improved efficiency, achieving faster processing times, positive ROI, and enhanced KPIs due to Denodo's streamlined data management.
Sentiment score
7.6
SSIS is praised for cost-effective, efficient data management with significant savings, but users may switch with more budget.
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
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
7.1
Denodo support is praised for responsiveness and efficiency, though some note occasional setup challenges and bug handling issues.
Sentiment score
6.0
Users rely on forums for SSIS issues; Microsoft support is mixed, with some finding response times and quality lacking.
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 provides scalable data integration for medium to enterprise companies, supporting large user bases and efficient resource management.
Sentiment score
6.7
SSIS is scalable and excels in data integration, but efficiency varies with large datasets and real-time processing challenges.
For huge data requests, it cannot scale automatically; admin action is required.
Principal Architect at a manufacturing company with 10,001+ employees
While the solution scales well on a single machine, I have doubts about its scalability when deployed as part of a Java component cluster.
Datawarehouse & BI consultant, Owner, Mananging partner at NesCon B.V.
Its complexity in configuring and the requirement to install different connectors for different sources affects its scalability.
Technology Leader at eTCaaS
 

Stability Issues

Sentiment score
7.0
Denodo is generally stable with occasional connectivity issues, high reliability, and minor resource adjustments for optimal performance.
Sentiment score
7.4
SSIS is generally praised for stability and reliability, though some users note issues and the need for strong infrastructure.
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's data catalog requires enhanced functionality, user-friendliness, connectivity, integration, scalability, and modern tools for better user experience.
SSIS needs improved scalability, data source support, real-time processing, cloud integration, and user-friendly interfaces for better performance.
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's CPU/cores-based pricing is costly for small businesses but fair for larger enterprises, including some extra fees.
SSIS offers a cost-effective ETL solution for enterprises using Microsoft, enhancing affordability by integrating with SQL Server licenses.
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
 

Valuable Features

Denodo enhances data integration through virtualization, offering performance, usability, and seamless access to diverse data sources without replication.
SSIS provides user-friendly drag-and-drop functionality, excellent integration, scalability, cost-efficiency, and robust data transformation features.
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
8th
Average Rating
8.0
Reviews Sentiment
6.6
Number of Reviews
39
Ranking in other categories
Data Virtualization (1st), Cloud Data Integration (5th), Data Management Platforms (DMP) (3rd), AI Data Analysis (4th)
SSIS
Ranking in Data Integration
1st
Average Rating
7.6
Reviews Sentiment
6.8
Number of Reviews
75
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of December 2025, in the Data Integration category, the mindshare of Denodo is 1.5%, down from 1.8% compared to the previous year. The mindshare of SSIS is 4.6%, down from 7.7% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Data Integration Market Share Distribution
ProductMarket Share (%)
SSIS4.6%
Denodo1.5%
Other93.9%
Data Integration
 

Featured Reviews

Douglas Camargo - PeerSpot reviewer
Senior Backend Engineer at a pharma/biotech company with 51-200 employees
Has simplified multi-database querying and accelerated solution delivery with minimal setup
Denodo offers a great query language, the VQL, which was very easy to understand for someone that only knows SQL. It was easy to work with, and it was easy to integrate various types of databases in general. The usability of the platform is very great. The federated queries were also a feature that I used a lot. The easy usability of Denodo helped my work and made things easier for productivity. We were able to ship code faster than if we needed to use another type of data visualization tool or even an ETL. When we have multiple databases, the standard or common approach is just to have an ETL that matches the data, and we need to write this whole ETL. With Denodo, we can simplify this whole work to a few queries or setups in the databases and just make a few queries. This was actually easier, and it was faster to deliver a solution for a client instead of building a whole ETL pipeline or simply backfilling one database in another. Denodo simplifies your work and helps you ship code or ship solutions in a faster way. I really like the UI that Denodo has on the web app version. It was very simple and actually very beautiful to see. For a complicated program, it was very easy to understand how it works, even for someone who is just approaching the data engineering career or side of the programming language.
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.
879,259 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
22%
Manufacturing Company
12%
Computer Software Company
8%
Government
7%
Financial Services Firm
17%
Computer Software Company
10%
Government
8%
Manufacturing Company
6%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business15
Midsize Enterprise6
Large Enterprise19
By reviewers
Company SizeCount
Small Business26
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?
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.
 

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: December 2025.
879,259 professionals have used our research since 2012.