Pentaho offers the most comprehensive ETL and reporting solution for MongoDB. With visual data integration, Pentaho and MongoDB meet today’s growing demand to prepare complex data for analysis.


Unleash the Value of Data for Business and IT

With Pentaho, MongoDB data can be accessed, blended, visualized and reported with any other data source for increased insight and operational analytics.

Accelerate Data Access, Maximize Productivity

  • With no impact on throughput, this native integration leverages unique MongoDB features and capabilities such as the Aggregation Framework, Replication and Tag Sets.
  • Preparing MongoDB data for reporting is simplified with Pentaho’s drag and drop interface, automatic document sampling, and schema generation.

Pentaho and MongoDB

Easily Access, Consolidate and Transform Data

With native integration, Pentaho simplifies the process of accessing, consolidating and transforming data stored in MongoDB.  

Visual Design for ETL, Scheduling, Events and Orchestration

  • Blend and integrate multiple MongoDB collections with other internal and external data sources, including enterprise data.
  • Design, develop and deploy MongoDB analytic solutions faster using Pentaho’s visual analytics environment.
  • Leverage an extensive library of graphical data orchestration and transformation steps to simplify the analytic process.

Pentaho and MongoDB

Blend, Enrich and Report on Disparate Data

Creating a single, easily accessible view of patients, customers, employees, or financial investments can have a big impact on business.  Blending the data from proprietary and open, unstructured data sources to get there is a challenge.  

Pentaho helps accelerate MongoDB development efforts making it easy to enrich and blend data from disparate sources for quicker reporting. Read how we helped healthcare software provider Remedy Partners:

Business Challenge

  • Required a scalable reporting solution to grow Remedy’s Episode Connect, the only enterprise software that functions as a complete operating system for managing value-based payment programs
  • Needed to provide accurate and immediate data accessibility of patient information to over 2,200 healthcare facilities across the United States

Pentaho Benefits

  • Provided a more scalable way to blend disparate data across MongoDB, MySQL, CSV (Medicare FTP monthly and quarterly claims files)
  • Remedy could handle increasingly larger volumes of health plan data and report on it, identifying nearly 300,000 patients each year for bundled payment programs while driving savings of over $250,000 per day for health care providers

Read the entire case study.