BLUEPRINT FOR BIG DATA SUCCESS:

Optimize the Data Warehouse

Reduce the increasing strain on your data warehouse by offloading less frequently used data and corresponding transformation workloads without coding or relying on legacy scripts and ETL product limitations.

An optimized Data Warehouse solution enables chief data officers and database administrators to provide business analysts with improved query and report performance to quickly identify business insights.

Our Data Warehouse Optimization Solution provides a quick and cost-effective way to immediately get value from data through integrated reporting, dashboards, data discovery and predictive analytics. With Pentaho’s Data Warehouse Optimization solution, you can:

Simplify HADOOP Acessibility, AND BE 15X FASTER

Pentaho simplifies offloading of data and transformation workloads to Hadoop and reduces ETL development and deployment time up to 15x versus hand-coded approaches. Complete visual integration tools eliminate the need for hand coding in SQL or Java-based MapReduce jobs.

Save on data costs and boost analytics performance

  • An intuitive graphical, no-coding big data integration interface
  • Access to every data source – from operational to relational to NoSQL technologies
  • Future-proof support for every major Hadoop distribution with the Pentaho’s adaptive big data layer
  • Achieve improved processing performance with Pentaho MapReduce
  • 100% Java - fast and efficient

As part of the Pentaho Business Analytics Platform, the Data Warehouse Optimization Solution provides a quick and cost-effective way to immediately get value from data through integrated reporting, dashboards, data discovery and predictive analytics.

Example of how Optimizingthe Data Warehouse may look within an IT landscape

  • A company leverages data from disparate sources including CRM, Billing, and ERP systems
  • A Hadoop cluster has been implemented to offload less frequently used data from an existing data warehouse
  • The company saves on storage costs and increases query performance and access to its analytic data marts

How It Works

The Results

  • Staff savings and productivity: Pentaho’s Visual MapReduce graphical user interface and big data integration means existing data warehouse developers can move data between the data warehouse and Hadoop without coding
  • Time to value: MapReduce development time is reduced by up to 15x versus hand-coding based
  • Faster job execution: Pentaho MapReduce runs faster in Hadoop clusters versus using code-generating scripting tools

Leading Global Network Storage Company

Big Data Goal:

Scaling machine data management to enhance product performance and customer success.

  • Quickly and affordably scale storage device data for customer applications
  • Predict device failure
  • Enhance product performance

Architecture Example:

Pentaho Benefits:

  • 15x data storage cost reduction
  • Easy to use ETL and analysis for Hadoop, Hbase, and Oracle data sources
  • Improved customer satisfaction and better performance against customer service level agreements