Sold by: Hitachi Vantara LLC
Deployed on AWS
Free Trial
Ingest, Blend, Cleanse and Prepare Diverse Data From Any Source, in Any Environment - With No Code.
4.3
Overview
For Private Offer Pricing, please contact:
Datasheet:Pentaho Data Integration
With Pentaho Data Integration - Managing the enormous volumes, variety, and velocity of data is simplified
By allowing data preparation from any source and automating your data pipeline, Pentaho Data Integration allows you to curate data better for your business user. This software delivers business analytics to end users faster with visual tools that reduce time and complexity - without writing SQL or coding in Java or Python. Organizations immediately gain real value from their various data sources in the cloud or on premises, including files, relational databases, big data sets and more.
Turn Data Into Actionable Insights
More than just ETL (Extract, Transform, Load), Pentaho Data Integration is a codeless data orchestration tool that blends diverse data sets into a single source of truth as a basis for analysis and reporting. Effortlessly managed in a drag-and-drop graphical interface, so you can easily track where it's coming from, where it's going and how it's transforming.
Data Processing Performance and Productivity
PDI speeds performance time, reduces the complexity of integrating big data sources, and provides:
- Code-free data transformation
- Template-based approach to rapidly onboard data sources into Hadoop
Scalability, Simplicity, and Self-Service
With broad connectivity to any data type and high-performance Spark and MapReduce execution, PDI simplifies and speeds the process of integrating existing databases with new sources of data.
- Intuitive, drag-and-drop designer
- Rich library of prebuilt components
- Powerful orchestration capabilities
Integration and Extensibility
- API Integration: Comprehensive REST and SOAP APIs
- Plugin Architecture: Extend capabilities with a rich plugin ecosystem
- Third-Party Tool Integration: BI tools, databases, etc
Broad Connectivity and Data Delivery
PDI offers broad connectivity to a variety of diverse data, including structured, unstructured and semi-structured data.
- Relational database management system (RDBMS): Oracle, IBM DB2, MySQL, Microsoft SQL Server, Postgres, IBM MQ
- Spark and Hadoop: Cloudera, Hortonworks, Amazon EMR, MapR (HPE Ezmeral Data Fabric), Microsoft Azure HDInsights, and Elastic Search
- NoSQL databases and object stores: MongoDB, Cassandra, HBase, Hitachi Content Platform, AWS S3, Google Cloud Storage, Microsoft Azure ADLS Gen 2
- Analytic databases: Redshift, Snowflake, Vertica, Greenplum, Teradata, SAP HANA, Amazon Redshift, Google Big Query
- Business applications: SAP, Salesforce, Google Analytics
- Files: XML, JSON, Microsoft Excel, CSV, txt, Avro, Parquet, ORC, EBCDIC (mainframe), unstructured files with metadata, including audio, video and visual files
Highlights
- Code-free data transformation design that empowers 15x faster productivity versus hand-coding and executes in-cluster for high performance - Template-based approach to rapidly onboard data sources into Hadoop via metadata injection feature set.
- Ability to seamlessly switch between execution engines, such as Spark and the PDI native engine, to fit data volume and transformation complexity - Support for advanced analytics models from R, Python, Scala and Weka to operationalize predictive intelligence while reducing data prep time.
- Robust Dataflow Orchestration of pipeline - Support both structured and unstructured data.
Details
Sold by
Categories
Delivery method
Delivery option
64-bit (x86) Amazon Machine Image (AMI)
Latest version
Operating system
Ubuntu 20.04 LTS
Deployed on AWS
New
Introducing multi-product solutions
You can now purchase comprehensive solutions tailored to use cases and industries.
Features and programs
Financing for AWS Marketplace purchases
AWS Marketplace now accepts line of credit payments through the PNC Vendor Finance program. This program is available to select AWS customers in the US, excluding NV, NC, ND, TN, & VT.
Pricing
Free trial
Try this product free for 30 days according to the free trial terms set by the vendor. Usage-based pricing is in effect for usage beyond the free trial terms. Your free trial gets automatically converted to a paid subscription when the trial ends, but may be canceled any time before that.
Pricing is based on actual usage, with charges varying according to how much you consume. Subscriptions have no end date and may be canceled any time. Alternatively, you can pay upfront for a contract, which typically covers your anticipated usage for the contract duration. Any usage beyond contract will incur additional usage-based costs.
Additional AWS infrastructure costs may apply. Use the AWS Pricing Calculator to estimate your infrastructure costs.
Dimension | Cost/hour |
|---|---|
m5.large Recommended | $3.57 |
m5.2xlarge | $12.49 |
m5.8xlarge | $36.53 |
m5.4xlarge | $21.83 |
m5.xlarge | $7.13 |
Dimensions summary
You pay by the hour for the EC2 instance size you choose to run this ETL software. The five options are all m5 general-purpose instances: large, xlarge, 2xlarge, 4xlarge, and 8xlarge. They differ by compute and memory capacity, not by feature set. Pricing scales with instance size — larger instances cost more per hour and handle heavier data workloads. You are billed only for the hours each instance runs, with no upfront commitment. Pick the size that matches your processing needs.
Top-of-mind questions for buyers
Each option is an m5 general-purpose EC2 instance with a fixed compute and memory allocation. The size steps up from large through 8xlarge, doubling capacity at each step. You pick one instance size to run the ETL software, and that size sets the compute and memory available for your data jobs.
Software charges accrue only while the instance runs, since billing is per hour. A stopped instance does not accrue software hours. However, underlying AWS storage for the instance volumes may still incur separate AWS fees while the instance is stopped. The software meters running time only.
One running instance handles your transformations and jobs through the included client and server tools. You choose a larger instance size for heavier data volumes rather than adding instances. The software installs as an auto-start service, and a repository is included on the instance for storing your ETL work.
docs.pentaho.com
Helpful?
Vendor refund policy
No Refunds
Custom pricing options
Request a private offer to receive a custom quote.
Legal
Vendor terms and conditions
Upon subscribing to this product, you must acknowledge and agree to the terms and conditions outlined in the vendor's End User License Agreement (EULA) .
Content disclaimer
Vendors are responsible for their product descriptions and other product content. AWS does not warrant that vendors' product descriptions or other product content are accurate, complete, reliable, current, or error-free.
Delivery details
64-bit (x86) Amazon Machine Image (AMI)
Amazon Machine Image (AMI)
An AMI is a virtual image that provides the information required to launch an instance. Amazon EC2 (Elastic Compute Cloud) instances are virtual servers on which you can run your applications and workloads, offering varying combinations of CPU, memory, storage, and networking resources. You can launch as many instances from as many different AMIs as you need.
Version release notes
Additional details
Usage instructions
Application access: http://IP_ADDRESS:8080
Launching a Pentaho instance in AWS: https://docs.pentaho.com/install/10.2-install/pentaho-installation-overview-cp/hyperscalers-landing-page
Product Documentation: https://docs.pentaho.com/pdia-data-integration
Getting Started: https://docs.pentaho.com/pdia-data-integration/basic-concepts-of-pdi
Administration: https://docs.pentaho.com/pdia-admin
Product Documentation: https://docs.pentaho.com/pdia-data-integration
Pentaho website: https://pentaho.com/
Resources
Support
Vendor support
AWS infrastructure support
AWS Support is a one-on-one, fast-response support channel that is staffed 24x7x365 with experienced and technical support engineers. The service helps customers of all sizes and technical abilities to successfully utilize the products and features provided by Amazon Web Services.
Similar products
Matrix Business offers a comprehensive range of specialized services. Our offerings include Monitoring Service to ensure continuous and efficient oversight, Managed and Configuration Service for comprehensive and personalized management, Operation Service to optimize operational performance, and Cell Base Service providing a focused and dedicated approach to managing and developing your projects. By facilitating the management and/or operation of Pentaho on AWS, we offer clients the flexibility to choose services tailored to their specific needs.
We provide Data Engineering professional services, specializing in the deployment of data architectures integrating Cloudera, Pentaho, Databricks, and Neo4j.
Consulting for the design, deployment, and optimization of data architecture, focusing on data streaming, integration, and storage with governance.
Our solutions run on any cloud environment, private or public.
Automated Discovery, Classification, and Optimization - Know Your Data. Trust Your Data. Build Your Data Products.
Customer reviews
Dhiraj D.
One the best ETL tool
Reviewed on Aug 08, 2025
Review provided by G2
What do you like best about the product?
It's a open source software still it's a very user-friendly interface and I just love all functionalities . It's a very simple design steps which are self explanatory kind of , easy to use.
What do you dislike about the product?
Sometimes faces performance issues when data volume is huge
What problems is the product solving and how is that benefiting you?
We are using for our data pipelines and it's benifits us for loading of data used for our application and we use it for reporting purposes.
Sandeep C.
Pentaho an etl tool for bussiness
Reviewed on Mar 12, 2025
Review provided by G2
What do you like best about the product?
Pentaho is one of the best etl tool to extract ,transform and load the data among various sources ,it just requires connections of the database and transfers data very fast .it also executes sql and generates reports into excel or any other required source.it has all basic components like execute sql,table input,excel input ,excel output,txt output,hdfs output.
What do you dislike about the product?
Pentaho job runs fast but modifying a job is time consuming ,it is usually so slow.better if it fast like any other application and also required some tutorials from pentaho side.
What problems is the product solving and how is that benefiting you?
It usually best to transfer huge data from one source to another like oracle to hue.It is best to generate reports into excel using sql queries.
Karthick V.
Totally worth it!!
Reviewed on Mar 31, 2022
Review provided by G2
What do you like best about the product?
Best price in market, Hitachi sponsored and high quality in data integration.
What do you dislike about the product?
Limitation in features, connector is
having portability issue and less user friendly.
having portability issue and less user friendly.
What problems is the product solving and how is that benefiting you?
We used PDI for data integration for designed reports. So far, had the best experience.
Information Technology and Services
ETL for Dashboards
Reviewed on Oct 08, 2020
Review provided by G2
What do you like best about the product?
Pentaho Data Integration (aka Kettle) is a tool included in the Pentaho suite that we use in our Smart Cities projects to obtain data from various data sources. It has a large number of tools already built for Input, Ouput, Transform ... that allow developers to save a lot of time. Its use is easy even for inexperienced users.
What do you dislike about the product?
If we want to have support with the Pentaho suite we should not use its Community version (free), but in some Smart Cities specifications of our clients they require a free and open source tool with associated support.
What problems is the product solving and how is that benefiting you?
PDI allows us to obtain data from various data sources such as databases, excel files, csv, big data / hadoop type databases and use preconfigured tools so that obtaining this data is simple and parameterizable. Other languages such as python require the writing of complete modules, with PDI the implementation and debugging are integrated through Plug & Play tools.
Recommendations to others considering the product:
The Pentaho suite has a Community version that is free and free software, so our recommendation is to download it and test it to verify that this tool meets your requirements. For our part, we recommend it as we use it practically whenever we need to extract data from a data source quickly and easily.
Information Technology and Services
ETL with graphical interface
Reviewed on Jun 10, 2020
Review provided by G2
What do you like best about the product?
Pentaho data integration is one of the most powerful tools for building ETL processes that we use within our Smart Cities projects. It is a tool with a graphical interface that allows you to debug quickly and easily and has a multitude of preconfigured modules. Furthermore, it combines very well with the Hitachi Pentaho CDE tool for the generation of Dashboards.
What do you dislike about the product?
When you want to do a very simple development maybe you can choose to use Python source code directly. There are other powerful alternatives like Talend Studio.
What problems is the product solving and how is that benefiting you?
Pentaho Data Integration allows us to collect data from different data sources such as both relational and non-relational databases such as Big Data (HDFS), it allows us to bring information from Excel files ... and almost from any source of information we need. Also, their debugging tools save us a lot of time.
Recommendations to others considering the product:
Pentaho has a suite called Community that is free and available to everyone. In addition, it has many examples and information. We recommend trying it out before deciding if we need to purchase the paid version. It is a great tool and we recommend it.