Overview

For Private Offer Pricing, please contact:
PrivateOfferPricing@pentaho.com

Datasheet:Pentaho Data Integration
Datasheet:Pentaho Business Analytics

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.

With Pentaho Business Analytics integrated - Dynamic Exploration, Simplified integration, and Innovative Reporting Tools are at your fingertips

Visualize your data, create reports, and design dashboards without depending on IT or developers with Pentaho Business Analytics, a powerful, cost-effective, and customizable no-code data visualization tool. Enable seamless, data-driven decision making and break down barriers to data access with real-time self-service capabilities and built-in data modeling.

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

Hitachi Vantara LLC

Typical total price

This estimate is based on use of the seller's recommended configuration (m5.2xlarge) in the US East (N. Virginia) Region. View pricing details

$14.654/hour

Pricing

Free trial

Try for free

Try this product at no cost 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.

Pentaho Data Integration and Analytics

Info

View purchase options

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 covering 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.

Region

Usage costs (3)

Info

Instance type	Product cost/hour	EC2 cost/hour	Total/hour
m5.2xlarge Recommended	$14.27	$0.384	$14.654
m5.4xlarge	$24.97	$0.768	$25.738
m5.8xlarge	$43.66	$1.536	$45.196

Additional AWS infrastructure costs

Type	Cost
EBS General Purpose SSD (gp2) volumes	$0.10/per GB/month of provisioned storage

Vendor refund policy

No Refunds

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.

Usage information

Info

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

https://docs.hitachivantara.com/v/u/en-us/pentaho-data-integration-and-analytics/10.2.0/rn-95pdia000

Additional details

Usage instructions

Application access: http://<IP_address>:8080

Launching a Pentaho instance in a hyperscaler https://docs.hitachivantara.com/r/en-us/pentaho-data-integration-and-analytics/9.5.x/mk-95pdia001/pentaho-installation/hyperscalers/launching-a-pentaho-instance-in-a-hyperscaler

Product Documentation: https://docs.hitachivantara.com/p/pentaho-dia

Getting Started: https://docs.hitachivantara.com/r/en-us/pentaho-data-integration-and-analytics/10.2.x/mk-95pdia000

Administration: https://docs.hitachivantara.com/r/en-us/pentaho-data-integration-and-analytics/10.2.x/mk-95pdia002

Product Documentation: https://docs.hitachivantara.com/p/pentaho-dia

Pentaho website: https://pentaho.com/

Resources

Vendor resources

Launching Pentaho AMI in AWS

Pentaho Community

Self-Paced Training

Support

Vendor support

Get 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.

Get support

Similar products

Pentaho Data Integration and Analytics [BYOL]

By Hitachi Vantara LLC

Ingest, Blend, Cleanse and Prepare Diverse Data From Any Source, in Any Environment - With No Code. And with Pentaho Business Analytics integrated you will have the ability to access, prepare, and analyze all data from any source, in any environment.

View product

Pentaho Data Integration

By Hitachi Vantara LLC

Ingest, Blend, Cleanse and Prepare Diverse Data From Any Source, in Any Environment - With No Code.

View product

Pentaho Data Integration and Analytics on AWS

By Matrix Business

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.

View product

Pentaho Data Integration [BYOL]

By Hitachi Vantara LLC

Ingest, Blend, Cleanse and Prepare Diverse Data From Any Source, in Any Environment - With No Code.

View product

Customer reviews

Write a review

Ratings and reviews

Info

0 ratings

5 star

4 star

3 star

2 star

1 star

0 AWS reviews

15 external reviews

External reviews are sourced from G2 and are not included in the star rating for this product.

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.

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.

Leave a comment 0 comments

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.

Leave a comment 0 comments

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.

Leave a comment 0 comments

Paco T.

PDI, best data cleaning tool

Reviewed on Apr 21, 2020

Review provided by G2

What do you like best about the product?

Pentaho comes in two editions, enterprise and community, I had experience with the community edition and here are all the advatages I see:

1. Its under apache2.0 license so while you read and work under the agreements, you can have this powerful tool for free
2. Has a very friendly user interface, so anybody, even without strong programming skill could make some transformations in just minutes
3. It has a wide variety of data inputs formats, allowing you to read from simple csv's or excels files to databases, json's and even s3 storage
4. It has a lot of tools for transformating your data without coding
5. If the functions that PDI has integrated aren't enough for you, you can add some scripting steps

What do you dislike about the product?

I see a strong oportunity on improving their documentation, sometimes its kinda hard finding examples for all the functionalities that PDI offers

What problems is the product solving and how is that benefiting you?

I mainly use pantaho for transforming data on the ETL cycle, so I do cleansing of different sources and storage it in a DWH

Leave a comment 0 comments

zahit B.

Open Source ETL Tools

Reviewed on Nov 18, 2019

Review provided by G2

What do you like best about the product?

Pentaho Data Integration (PDI) is a free and open source tool for all users.
Pentaho Data Integration (PDI) is a very high performance product compared to the paid ETL tools. The product is quite simple to use. The components on the left side of the product have all the components that the user needs. (For example; excel connection, row value, etc.) In my experience, the Logging screen is not descriptive. Sometimes you cannot identify the source of the error. Other than that, I am very satisfied with the PDI tool

What do you dislike about the product?

Since there are no detailed explanations of the errors on the logging screen, sometimes we cannot find the cause of the error. Also in the user community microsoft, oracle is not as strong.

What problems is the product solving and how is that benefiting you?

We needed to import the data from the json file into the tables in the database. With the Pentaho Data Integration tool, we have transferred the json files to the database. We designed daily job with Windows Task Scheduler.

Leave a comment 0 comments

View all reviews