Denodo vs Hitachi Lumada Data Integration comparison

Cancel
You must select at least 2 products to compare!
Comparison Buyer's Guide
Executive Summary

We performed a comparison between Denodo and Hitachi Lumada Data Integration based on real PeerSpot user reviews.

Find out in this report how the two Data Integration Tools solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI.
To learn more, read our detailed Denodo vs. Hitachi Lumada Data Integration Report (Updated: March 2023).
688,083 professionals have used our research since 2012.
Featured Review
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 feature is Data Catalogs.""Denodo makes it easy to export data as a service or data link to other services.""Denodo is lightweight in terms of how it leads you to combine your discrete data systems at one spot.""Denodo's best features are its performance, easy data transformation, and the job scheduler.""The most valuable features are query optimization and the single language independence from the sources we're using to catch data.""In PL/SQL, first you need to gather all the data and then start writing the file, but in Denodo you fetch the data and write the data simultaneously. So, for example, if you have 1 million or 2 million records, you don't have to wait to fetch all of the 2 million; you can keep on fetching and writing in the file simultaneously.""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.""This solution provides us with the ability to sync data, and make it available for anyone to use across the business."

More Denodo Pros →

"We use Lumada’s ability to develop and deploy data pipeline templates once and reuse them. This is very important. When the entire pipeline is automated, we do not have any issues in respect to deployment of code or with code working in one environment but not working in another environment. We have saved a lot of time and effort from that perspective because it is easy to build ETL pipelines.""Sometimes, it took a whole team about two weeks to get all the data to prepare and present it. After the optimization of the data, it took about one to two hours to do the whole process. Therefore, it has helped a lot when you talk about money, because it doesn't take a whole team to do it, just one person to do one project at a time and run it when you want to run it. So, it has helped a lot on that side.""I absolutely love Hitachi. I'm one of the forefront supporters of Hitachi for my firm. It's so easy to integrate within our environments. In terms of being able to quickly build ETL jobs, transform, and then automate them, it's really easy to integrate throughout for data analytics.""We also haven't had to create any custom Java code. Almost everywhere it's SQL, so it's done in the pipeline and the configuration. That means you can offload the work to people who, while they are not less experienced, are less technical when it comes to logic.""The fact that it enables us to leverage metadata to automate data pipeline templates and reuse them is definitely one of the features that we like the best. The metadata injection is helpful because it reduces the need to create and maintain additional ETLs. If we didn't have that feature, we would have lots of duplicated ETLs that we would have to create and maintain. The data pipeline templates have definitely been helpful when looking at productivity and costs.""It's my understanding that the product can scale.""Flexible deployment, in any environment, is very important to us. That is the key reason why we ended up with these tools. Because we have a very highly secure environment, we must be able to install it in multiple environments on multiple different servers. The fact that we could use the same tool in all our environments, on-prem and in the cloud, was very important to us.""The graphical nature of the development interface is most useful because we've got people with quite mixed skills in the team. We've got some very junior, apprentice-level people, and we've got support analysts who don't have an IT background. It allows us to have quite complicated data flows and embed logic in them. Rather than having to troll through lines and lines of code and try and work out what it's doing, you get a visual representation, which makes it quite easy for people with mixed skills to support and maintain the product. That's one side of it."

More Hitachi Lumada Data Integration Pros →

Cons
"There have been some issues when you are at a table. Currently, Denodo exports data sets for a tabular model. When you are finished modeling your database or data warehouse they export a link to be used in Tableau. They should support other tools like Power BI.""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.""I would like to see a proper way to avoid killing the sourcing systems.""It would be good if the solution provided a much-needed cellular platform.""We would like this solution to be more universally user-friendly. At present it is really only aimed at IT specialists.""Denodo's training documentation could be improved by providing more material. From an administrative standpoint, I've found that only Denodo websites provide the usual tutorials. It may be because it's a bit of a restricted tool, but it results in trouble with learning. Normally, I can find help and solutions from other sources, but I haven't been able to find any for Denodo. Other that, it's fine and it performs well. I only have six months of experience, so I can't accurately suggest improvements.""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.""Tasks such as conversion of a date format or conversion of a number format that can be done in a very easy way in different languages, like SQL or Oracle, are not so easy to do in Denodo. For example, if you want to convert a date from one format to another, in Oracle it's pretty easy; in Denodo, however, it requires so many lines of code. Simple things that can be done very quickly in other database languages require more lines of code in Denodo."

More Denodo Cons →

"Since Hitachi took over, I don't feel that the documentation is as good within the solution. It used to have very good help built right in.""In the Community edition, it would be nice to have more modules that allow you to code directly within the application. It could have R or Python completely integrated into it, but this could also be because I'm using an older version.""Lumada could have more native connectors with other vendors, such as Google BigQuery, Microsoft OneDrive, Jira systems, and Facebook or Instagram. We would like to gather data from modern platforms using Lumada, which is a better approach. As a comparison, if you open Power BI to retrieve data, then you can get data from many vendors with cloud-native connectors, such as Azure, AWS, Google BigQuery, and Athena Redshift. Lumada should have more native connectors to help us and facilitate our job in gathering information from these new modern infrastructures and tools.""I work with different databases. I would like to work with more connectors to new databases, e.g., DynamoDB and MariaDB, and new cloud solutions, e.g., AWS, Azure, and GCP. If they had these connectors, that would be great. They could improve by building new connectors. If you have native connections to different databases, then you can make instructions more efficient and in a more natural way. You don't have to write any scripts to use that connector.""It could be better integrated with programming languages, like Python and R. Right now, if I want to run a Python code on one of my ETLs, it is a bit difficult to do. It would be great if we have some modules where we could code directly in a Python language. We don't really have a way to run Python code natively.""Parallel execution could be better in Pentaho. It's very simple but I don't think it works well.""Its basic functionality doesn't need a whole lot of change. There could be some improvement in the consistency of the behavior of different transformation steps. The software did start as open-source and a lot of the fundamental, everyday transformation steps that you use when building ETL jobs were developed by different people. It is not a seamless paradigm. A table input step has a different way of thinking than a data merge step.""Although it is a low-code solution with a graphical interface, often the error messages that you get are of the type that a developer would be happy with. You get a big stack of red text and Java errors displayed on the screen, and less technical people can get intimidated by that. It can be a bit intimidating to get a wall of red error messages displayed. Other graphical tools that are focused at the power user level provide a much more user-friendly experience in dealing with your exceptions and guiding the user into where they've made the mistake."

More Hitachi Lumada Data Integration Cons →

Pricing and Cost Advice
  • "I don't know the actual cost, but it's tens of thousands of dollars per month."
  • "The licensing charges for this solution are payable annually."
  • "The pricing is pretty good, and I would rate it at four out of five."
  • "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."
  • "Depending on the size of the client you want to work with, it can be prohibitively expensive at times."
  • "There is an express edition and a licensed enterprise edition."
  • "Talking with my manager and others, nobody has complained about the pricing so far which is a positive sign."
  • "For us, the cost has been okay. Also, there are no additional costs; it's just the standard licensing fee."
  • More Denodo Pricing and Cost Advice →

  • "It does seem a bit expensive compared to the serverless product offering. Tools, such as Server Integration Services, are "almost" free with a database engine. It is comparable to products like Alteryx, which is also very expensive."
  • "I think Lumada's price is fair compared to some of the others, like BusinessObjects, which is was the other thing that I used at my previous job. BusinessObject's price was more reasonable before SAP acquired it. They jacked the price up significantly. Oracle's OBIEE tool was also prohibitively expensive."
  • "When we first started with it, it was much cheaper. It has gone up drastically, especially since Hitachi bought out Pentaho."
  • "The cost of these types of solutions are expensive. So, we really appreciate what we get for our money. Though, we don't think of the solution as a top-of-the-line solution or anything like that."
  • "The pricing has been pretty good. I'm used to using everything open-source or freeware-based. I understand that organizations need to make sure that the solutions are secure, and that's basically where I hit a roadblock in my current organization. They needed to ensure that we had a license and we had a secure way of accessing it so that no outside parties could get access to our data, but in terms of pricing, considering how much other teams are spending on cloud solutions or even their existing solutions, its price point is pretty good. At this time, there are no additional costs. We just have the licensing fees."
  • "There was a cost analysis done and Pentaho did favorably in terms of cost."
  • "If a company is looking for an ETL solution and wants to integrate it with their tech stack but doesn't want to spend a bunch of money, Pentaho is a good solution"
  • "You need to go through the paid version to have Hitachi Lumada specialized support. However, if you are using the free version, then you will have only the community support. You will depend on the releases from Hitachi to solve some problem or questions that you have, such as bug fixes. You will need to wait for the newest versions or releases to solve these types of problems."
  • More Hitachi Lumada Data Integration Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Data Integration Tools solutions are best for your needs.
    688,083 professionals have used our research since 2012.
    Questions from the Community
    Top Answer: 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 it… more »
    Top Answer: 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… more »
    Top Answer: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… more »
    Top Answer:Hi Rajneesh, yes here is the feature comparison between the community and enterprise edition :… more »
    Top Answer: In my opinion, the reporting side of this tool needs serious improvements. In my previous company, we worked with Hitachi Lumada Data Integration and while it does a good job for what it’s worth, it… more »
    Top Answer:My company has used this product to transform data from databases, CSV files, and flat files. It really does a good job. We were most satisfied with the results in terms of how many people could use… more »
    Ranking
    10th
    Views
    9,917
    Comparisons
    6,844
    Reviews
    20
    Average Words per Review
    718
    Rating
    7.5
    6th
    Views
    6,004
    Comparisons
    3,376
    Reviews
    24
    Average Words per Review
    1,319
    Rating
    7.8
    Comparisons
    Also Known As
    Kettle, Pentaho Data Integration
    Learn More
    Overview

    Denodo is a leading data integration, management, and delivery platform that uses a logical approach to enable data science, hybrid and multi-cloud data integration, self-service BI, and enterprise data services. Organizations of different sizes across various industries utilize the product to get above the data silos. The solution offers organizations the freedom to migrate data to the cloud, or logically unify data warehouses and data lakes, without affecting business. This can ultimately result in the evolution of data strategies.

    The platform accelerates data provisioning through reduced data replication, provides business users the freedom to select their preferred applications, and enables consistent security and governance across multiple systems. The solution offers one of the leading logical data fabric solutions by initiating data virtualization and eliminating the complexity and exposing the data in business-friendly formats.

    Denodo also offers modern data integration and management for hybrid and multi-cloud environments for Denodo Platform for Cloud. This service can be purchased through the bring-your-own-license (BYOL) option. Users seeking faster deployment can license the product to popular cloud providers, including Amazon AWS, Google Cloud Platform, and Microsoft Azure. The solution integrates, manages, and delivers data in complex environments with high performance, governance, and security. It also offers additional solutions, such as the Denodo Platform for Cloud Modernization, the Denodo Platform for Cloud Data Integration, and the Denodo Platform for Cloud Analytics, which overcome common cloud data challenges.

    Denodo Features

    At the beginning of 2022, version 8.0 of Denodo introduced several new key features of the platform. These include:

    • Scalability: Denodo can scale from departmental or project to enterprise-wide with geographically distributed nodes. It can also handle large transactional loads of users, sources, and transactions as well as analytical loads of data volumes.

    • Query optimizers: This feature offers advanced cost-based and source constraint-based query optimization that includes query rewrite, query delegations, data movements, and join optimization.

    • Intelligent caching: This feature makes full, portal, and time-based caching possible.

    • Fine-grained security model: This Denodo feature makes integration with external systems possible.

    • Monitoring and auditing: Denodo offers enterprise-grade monitoring and auditing, which allows for integration with system management products, including Tivoli, Unicenter, and HP BTO.

    • Development and deployment support: The product offers full lifecycle support for the development and deployment of applications, providing users with all required tools.

    Denodo Benefits

    Denodo offers various benefits for its users through its services. Some of the greatest advantages of using this platform include:

    • The solution accelerates time to market for all types of business data through its services.

    • Denodo provides IT agility, which helps companies respond to business-changing demands in a timely manner.

    • Users can decide how much data replication they want to reduce through Denodo and use the product in full control.

    • The solution meets the industry's security and privacy requirements by providing high-grade protection for users' data.

    • Users can benefit from centralized control of data query executions for complete governance and full security.

    • Denodo offers legacy replacement, multi-cloud deployments, and cloud migrations with minimal disruptions and a fair price.

    • The solution utilizes artificial intelligence (AI) and machine learning (ML) to unlock data potential for customers.

    Reviews from Real Users

    Naresh M., a senior application developer at a financial services firm, appreciates Denodo because it offers quick and simple web services creation.

    Alisson M., a senior BigData DevOps engineer at Schaeffler, says that Denodo is great for queries and scouting data.

    Hitachi Lumada Data Integration is a top-raking data integration tool that aims to deliver accurate data from various sources to end users. This is a complete data integration platform that utilizes visual tools in the delivery of analytics-ready data. The product eliminates coding and complexity to ensure equal accessibility of its services to IT users as well as businesses that do not specialize in the field.

    The solution offers powerful data integration, which is achieved through:

    • Accelerated data onboarding
    • Flexible data self-service
    • Robust data flow orchestration

    Users of Hitachi Lumada Data Integration can collaborate to build, deploy, and monitor dataflows in order to streamline data delivery. The visual tools of the product reduce the time of operation and lower complexity, allowing even beginners to operate the platform seamlessly. The onboarding process is initiated through broad connectivity to a wide variety of data sources and applications.

    A drag-and-drop interface allows users to easily create data pipelines and ready-made templates to execute edge to cloud. The product provides users with the opportunity to blend data on premises or using cloud services, including Azure, Amazon Web Services (AWS), and Google Cloud Platform (GCP). The tool allows for a seamless switch between the native engine and Apache Spark, and operationalizes Python, Scala, and Weka machine-learning models.

    The tool offers features for extensive business analytics through:

    • Ad-hoc analysis
    • Flexible interface
    • Enterprise reporting

    Hitachi Lumada Data Integration offers its clients modern data architectures for data analytics. Through interactive visualizations and easy integration, users are able to increase data integrity for their organizations. The product offers a web-based drag-and-drop dashboard for a flexible experience, collaboration with other applications, and advanced multi tenancy. There is special enterprise reporting which consists of operational self-serving reporting, security with content permissions, and additional high-level protection, achieved through locking, and expirations.

    Hitachi Lumada Data Integration Features

    The tool offers its clients various features which can be used to achieve efficient data integration and further analysis. These features include:

    • Data access: The tool allows users to access data sources at the edge, core, and cloud. This reduces the time and complexity of the process while blending sources to deliver data in a format ready to be analyzed.

    • Machine learning: The solution offers a feature to orchestrate machine learning. R, Python, Scale, and Weka models are provided to users of this product.

    • Enterprise reporting: Hitachi Lumada Data Integration provides its clients with detailed visualized reporting. This feature is highly secured, which provides additional protection for clients' data.

    • Connect and move: This feature offers users the option to connect to sources on premises or in the cloud and move data of any size and format.

    • Flexibility: The product allows users broad connectivity and flexibility with no vendor lock-in to on-premise or cloud services.

    • Cluster to container: The tool offers the option to create scalable pipelines with Kubernetes clusters. This is possible across multiple clouds.

    • Dataflow studio: This feature allows users to build and manage data pipelines, view run metrics, analyze activities, and resume paused ones.

    • Authoring: The tool has an editor feature, which allows for the transformation of activities while the dataflow is in progress.

    Hitachi Lumada Data Integration Benefits

    The tool offers increased work productivity through efficient data integration. A number of the benefits include:

    • Ability to increase productivity in the work process due to effective automation.

    • Production deployment time can be sped up while saving costs for the company.

    • The no-code functionality improves pipeline quality in comparison to hand-coding data.

    • The tool offers high-quality reports which reduce implementation time.

    • Employees can save time and resources by manually embedding reporting and applications through this solution.

    • The utilization of this tool can increase business user adoption by improving data accuracy.

    Reviews from Real Users

    Philip R., a senior engineer at a comms service provider, says this product "Saves time and makes it easy for our mixed-skilled team to support the product".

    Ryan F., a senior data engineer at Burgiss, appreciates Hitachi Lumada Data Integration because low-code makes development faster than with Python.

    Offer
    Learn more about Denodo
    Learn more about Hitachi Lumada Data Integration
    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
    66Controls, Providential Revenue Agency of Ro Negro, NOAA Information Systems, Swiss Real Estate Institute
    Top Industries
    REVIEWERS
    Financial Services Firm31%
    Government8%
    Comms Service Provider8%
    Renewables & Environment Company8%
    VISITORS READING REVIEWS
    Financial Services Firm16%
    Computer Software Company14%
    Government8%
    Manufacturing Company7%
    REVIEWERS
    Healthcare Company19%
    Financial Services Firm19%
    Comms Service Provider11%
    Manufacturing Company11%
    VISITORS READING REVIEWS
    Computer Software Company17%
    Comms Service Provider13%
    Financial Services Firm13%
    Government7%
    Company Size
    REVIEWERS
    Small Business33%
    Midsize Enterprise11%
    Large Enterprise56%
    VISITORS READING REVIEWS
    Small Business16%
    Midsize Enterprise10%
    Large Enterprise74%
    REVIEWERS
    Small Business27%
    Midsize Enterprise31%
    Large Enterprise42%
    VISITORS READING REVIEWS
    Small Business24%
    Midsize Enterprise10%
    Large Enterprise65%
    Buyer's Guide
    Denodo vs. Hitachi Lumada Data Integration
    March 2023
    Find out what your peers are saying about Denodo vs. Hitachi Lumada Data Integration and other solutions. Updated: March 2023.
    688,083 professionals have used our research since 2012.

    Denodo is ranked 10th in Data Integration Tools with 20 reviews while Hitachi Lumada Data Integration is ranked 6th in Data Integration Tools with 24 reviews. Denodo is rated 7.4, while Hitachi Lumada Data Integration is rated 7.8. 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 Hitachi Lumada Data Integration writes "Saves time and makes it easy for our mixed-skilled team to support the product, but more guidance and better error messages are required in the UI". Denodo is most compared with Azure Data Factory, Informatica PowerCenter, Delphix, Informatica Enterprise Data Catalog and SAP HANA, whereas Hitachi Lumada Data Integration is most compared with SSIS, Talend Open Studio, Informatica Enterprise Data Catalog, Azure Data Factory and Spring Cloud Data Flow. See our Denodo vs. Hitachi Lumada Data Integration report.

    See our list of best Data Integration Tools vendors.

    We monitor all Data Integration Tools 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.