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

Denodo vs SAP Data Hub vs SSIS comparison

 

Comparison Buyer's Guide

Executive Summary

Review summaries and opinions

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

Mindshare comparison

Data Virtualization
Data Governance
Data Integration
 

Featured Reviews

Snehasish Das - PeerSpot reviewer
Enable efficient AI and ML development through a unified virtual data environment
The most valuable feature in Denodo is data virtualization. This feature focuses on creating a virtualized data environment that allows for simpler connections between data sources and systems. It significantly eases the process of developing AI and ML strategies by centralizing access to various data sources and allowing algorithms to efficiently connect to and utilize data.
VM
The solution is seamless, but the database sometimes leads to confusion
We used to have multiple different kinds of databases, which internally, had different compliance levels. Retention management is very different now. If the policy is live and the claim has been completed, I couldn't archive the claim. I needed to keep a reference integrity of that claim and understand which policy paid out the claim. With this solution, the policy came in six months ago and qualified for archiving. The claim had been paid and in every environment, the claim had been closed, including the reporting system, the claims system, etc. With the payment set gateway, I can just go and archive. But, we had a hard time during this process. I rate the overall solution a seven out of ten.
Albert Lacerda - PeerSpot reviewer
Efficient data processing and seamless cloud integration have been achieved through powerful data pipelines
One of the best aspects of SSIS ( /products/ssis-reviews ) is that it is built into Microsoft SQL Server ( /products/sql-server-reviews ), so there are no additional costs involved. Despite the complexity when dealing with advanced transformations, it is straightforward for simple data movements, and the performance is excellent. I can process 1.2 million lines of data in a few minutes, even when running over a VPN connection.

Quotes from Members

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

Pros

"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 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's best features are its performance, easy data transformation, and the job scheduler."
"Denodo is lightweight in terms of how it leads you to combine your discrete data systems at one spot."
"The most valuable features are query optimization and the single language independence from the sources we're using to catch data."
"The performance and the speed to market are the most valuable features of this solution."
"While we may not be using all the features of Denodo at this time, we have found the data virtualization features to be very useful in helping us connect our data sources together, bringing all our data into one platform."
"The data catalog feature is valuable as it helps define data structures without storing data."
"The most valuable feature is the S/4HANA 1909 On-Premise"
"SAP is one of the most seamless ERPs that have integrated SAP archiving within Excel. I have not seen this with any other database."
"Its connection to on-premise products is the most valuable. We mostly use the on-premise connection, which is seamless. This is what we prefer in this solution over other solutions. We are using it the most for the orchestration where the data is coming from different categories. Its other features are very much similar to what they are giving us in open source. Their push-down approach is the most advantageous, where they push most of the processing on to the same data source. This means that they have a serverless kind of thing, and they don't process the data inside a product such as Data Hub. They process the data from where the data is coming out. If it is coming from HANA, to capture the data or process it for analytics, orchestration, or management, they go to the HANA database and give it out. They don't process it on Data Hub. This push-down approach increases the processing speed a little bit because the data is processed where it is sitting. That's the best part and an advantage. I have used another product where they used to capture the data first and then they used to process it and give it. In Data Hub, it is in reverse. They process it first and give it, and then they put their own manipulations. They lead in terms of business functions. No other solution has business functions already implemented to perform business analysis. They have a lot of prebuilt business functions for machine learning and orchestration, which we can use directly to get an analysis out from the existing data. Most of the data is sitting as enterprise data there. That's a major advantage that they have."
"The setup is straightforward. It's very easy to install."
"The most valuable features of SSIS are that it works with the query language and it can import data from different sources."
"It has a drag and drop feature that makes it easy to use. It has a good user experience because it takes into account your most-used tools and they're lined up nicely so you can just drag and drop without looking too far. It also integrates nicely with Microsoft."
"The initial setup was easy."
"The most valuable feature of SSIS is its ease of use. It is easier to use than other applications."
"The most valuable features for our company are the flexibility and the quick turn around time in producing simple ETL solutions."
"Its compatibility with Microsoft products has been very valuable to our company. It fits well within the architecture."
"It's already very user-friendly and has a good dashboard."
 

Cons

"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."
"Denodo currently integrates with ChatGPT, but the ability to manage and utilize them directly within Denodo would be a significant improvement."
"While AI and ML integration is present, understanding its implementation better could be beneficial."
"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."
"The cache configuration is more complicated."
"They need to invest more in the optimization engine. It will be a fantastic tool for them to enhance automation and improve the GUI interface, especially for Integration, as some tools are still not fully integrated, such as Iceberg."
"The cache configuration is more complicated."
"In 2018, connecting it to outside sources, such as IoT products or IoT-enabled big data Hadoop, was a little complex. It was not smooth at the beginning. It was unstable. It took a lot of time for the initial data load. Sometimes, the connection broke, and we had to restart the process, which was a major issue, but they might have improved it now. It is very smooth with SAP HANA on-premise system, SAP Cloud Platform, and SAP Analytics Cloud. It could be because these are their own products, and they know how to integrate them. With Hadoop, they might have used open-source technologies, and that's why it was breaking at that time. They are providing less embedded integration because they want us to use their other products. For example, they don't want to go and remove SAP Analytics Cloud and put everything in Data Hub. They want us to use SAP Analytics Cloud somewhere else and not inside the Data Hub. On the integration part, it lacks real-time analytics, and it is slow. They should embed the SAP Analytics Cloud inside Data Hub or support some kind of analysis. They do provide some analysis, but it is not extensive. They are moreover open source. So, we need a lot of developers or data scientists to go in and implement Python algorithms. It would be better if they can provide their own existing algorithms and give some connections and drop-down menus to go and just configure those. It will make things really quick by increasing the embedded integrations. It will also improve the process efficiency and processing power. Its performance needs improvement. It is a little slow. It is not the best in the market, and there are other products that are much better than this. In terms of technology and performance, it is a little slow as compared to Microsoft and other data orchestration products. I haven't used other products, but I have read about those products, their settings, and the milliseconds that they do. In Azure Purview, they say that they can copy, manage, or transform the data within milliseconds. They say that they can transform 100 gigabytes of data within three to five seconds, which is something SAP cannot do. It generally takes a lot of time to process that much amount of data. However, I have never tested out Azure."
"The company has everything offshore."
"Nowadays there are some inconsistencies in data bases, however, they upgrade and release the versions to market."
"The solution should work on the GPU, graphical processing unit. There should also be piping integration available."
"The interface could use improvement, as well as the administrative tools. Jobs fail from time to time for different reasons. It's not a problem with Microsoft, or SSIS itself. The problems are external, but to find the problems and analyze them it takes too much time."
"SSIS is stable, but extensive ETL data processing can have some performance issues."
"I would like to see more features in terms of the integration with Azure Data Factory."
"Improving the login procedure would make our reporting easier on monitoring our ETL processes."
"We In upgrading SSIS, we encountered challenges fixing SQL Server and performance issues, including problems during a failover in our data warehouse."
"I have a tool called ZappySys. I need that tool to cut down on the complexity of SSIS. That tool really helps with a quick turnaround. I can do things quickly, and I can do things accurately. I can get better reporting on errors."
"SSIS has a difficult learning curve when dealing with complex transformations."
 

Pricing and Cost Advice

"Denodo provides a lightweight 30-day free trial, but when we do courses on top of it, it costs $150 for each person."
"Cost wise, on a scale from one to five, with one being the cheapest and five being the most expensive, Denodo would be at three. We get all the features in a bundle."
"There is an express edition and a licensed enterprise edition."
"I don't know the actual cost, but it's tens of thousands of dollars per month."
"Talking with my manager and others, nobody has complained about the pricing so far which is a positive sign."
"I am not super familiar with the pricing, but so far, it seems good. We have been happy. We haven't seen any problems. The only time we had to pay extra was during the upgrade. We didn't upgrade at the time they told us to upgrade, and we had to pay extra to keep the service. They had stopped the support for the older version and moved to the newer version. It was not their fault. It was our fault because we didn't get on board quickly."
"The cost for Denodo is in line with other similar products."
"For us, the cost has been okay. Also, there are no additional costs; it's just the standard licensing fee."
"The Cloud is very expensive, but SAP HANA previous service is okay."
"The solution is available at a lesser price than that of Informatica."
"If you don't want to pay a lot of money, you can go for SSIS, as its open-source version is available. When it comes to licensing, SSIS can be expensive."
"I'm not involved in licensing details, but SSIS provides value to our organization by simplifying data management tasks."
"SSIS is a cheaper option compared to the cost of other ETL tools."
"Based on my experience and understanding, Talend comes out to be a little bit expensive as compared to SSIS. The average cost of having Talend with Talend Management Console is around 72K per region, which is much higher than SSIS. SSIS works very well with Microsoft technologies, and if you have Microsoft technologies, it is not really expensive to have SSIS. If you have SQL Server, SSIS is free."
"SSIS' licensing is a little high, but it gives good value for money."
"It would be beneficial if the solution had a less costly cloud offering."
"The solution is economical. You don't have to worry about the pricing as long as you're installing both services on the same server."
report
Use our free recommendation engine to learn which Data Virtualization solutions are best for your needs.
851,823 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%
Computer Software Company
10%
Manufacturing Company
9%
Government
7%
Financial Services Firm
15%
Computer Software Company
14%
Manufacturing Company
14%
Government
11%
Financial Services Firm
19%
Computer Software Company
12%
Government
8%
Manufacturing Company
6%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
No data available
 

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 fro...
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 ...
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...
What do you like most about SAP Data Hub?
SAP is one of the most seamless ERPs that have integrated SAP archiving within Excel. I have not seen this with any o...
What needs improvement with SAP Data Hub?
We moved from Oracle. If you're aware of your monitoring system, the RPU market, and the managed system, you should m...
What is your primary use case for SAP Data Hub?
I technically handle the database, like cycle management projects. When transaction data comes in, we see it based on...
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 ...
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.
 

Also Known As

No data available
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
Kaeser Kompressoren, HARTMANN
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