Amazon Web Services

Pentaho on Amazon Web Services (AWS) provides scalable, high-performance solutions for blending, orchestrating, and analyzing big data in the cloud.

Amazon Web Services


Powering Big Data Analytics in the Cloud

Moving big data to the cloud not only requires hosted data stores and frameworks, but also technologies for blending and analyzing massive amounts of information. Pentaho and Amazon Web Services enable organizations like NASDAQ OMX to manage and analyze billions of transactions a day on elastic infrastructure.

With the Pentaho platform, large volumes of diverse data can be ingested into Amazon Elastic MapReduce (EMR) and other hosted Hadoop distributions, then transformed, refined, and immediately pushed into Amazon Redshift. Business users and analysts are then offered a full spectrum of analytics including interactive data visualization, reporting, dashboards and advanced and predictive analytics.

Cloud architecture

Self-Service Data Prep on Amazon Redshift

Pentaho data integration offers an easy-to-use interface to eliminate the need for specialized big data coding skills to deploy and maintain systems, including:

  • Visual data integration and orchestration for Amazon Elastic MapReduce (EMR), the AWS cloud-based Hadoop solution
  • Native execution of MapReduce jobs in the EMR cluster for high performance and scalability
  • Intuitive visual ETL for Amazon Redshift, the AWS cloud-based data warehouse solution
  • Accelerated big data insights with automatic model generation and publishing for Redshift
  • Deployable on cloud infrastructure for rapid time-to-value

Rich Analytics for All Data in the Cloud

Pentaho delivers scalable business intelligence in the cloud, empowering users with a suite of rich analytics to improve products, understand customers, optimize marketing, and prevent fraud.

Uncover Patterns and Make Better Decisions

  • Advanced analytics for a broad set of users include an array of self-service analytics and visualization for all end users - business users, analysts, and data scientists
  • Rich visualizations and interactive web-based interfaces for ad hoc reporting, charting and dashboards
  • Deployable on Amazon Web Services cloud infrastructure for rapid time-to-value

High Speed Data Refinery in the Cloud

Pentaho helped NASDAQ, the world's largest securities exchange, streamline data processing and drive business insight. NASDAQ unified its data and analytics architecture on Amazon Web Services.

Business Challenge

NASDAQ manages several rows of financial information each business day, exhausting their existing architecture. They needed a modern, cost-efficient way to make this information accessible for interactive analysis for several lines of business.


Pentaho's end-to-end platform to transform large complex data sets and integrate with Amazon Web Services empowering end users with self-service analytics and dashboards to effectively manage several lines of business.

Value Added

With Pentaho and Amazon Web Services, NASDAQ created a cloud-based solution that manages huge volumes of data cost efficiently to drive better business decisions.

Read the entire use case