Pentaho consulting services for the jobs your reports depend on Pentaho Data Integration and reports kept fast, current and documented

Many companies have run Pentaho for years, with jobs written by people who have since moved on. We read every job and report, write down what each one does and what depends on it, and recommend what to keep, fix or replace.

Pentaho Data Integration, also called PDI or Kettle, is an open-source ETL tool. Our Pentaho developers build jobs and transformations in Spoon that extract data from your systems, clean and join it, and load it into a warehouse on a schedule.

We add error handling, logging and alerts, so a failed load is noticed in the morning, not at month end.

• Batch and near-real-time loads
• Data quality checks inside each job
• Scheduling with Carte or your own scheduler

We install and configure the Pentaho server, set up repositories, security and environments for development, testing and production, and move jobs between them in a controlled way.

On the Pentaho server, we build reports with Report Designer, dashboards, and analysis cubes that let people slice data by product, region and month.

When people need richer dashboards, we keep Pentaho for the loads and point Power BI or Tableau at the warehouse it fills.

We design the data marts and warehouses that Pentaho loads, with star schemas built for reporting, so reports stay fast as the data grows. Pentaho's data mining tools can then find patterns in that history.

We upgrade older Pentaho versions to a current release and test every job on the way. When you'd rather move, we rebuild the jobs on Azure Data Factory, dbt, Airflow or Databricks, run old and new side by side, and switch over when the loads match.

It's open source, runs on most platforms, connects to most databases and files, and has a visual designer that's quick to learn. It handles scheduling, metadata and data quality checks inside the same jobs.

Yes. We fix failing jobs, tune slow ones, help with upgrades and build new reports as and when you need it, as well as on a monthly support contract.

Yes. Our Pentaho developers and data engineers can join your team for a project or for as long as you need them, with clear roles agreed at the start.

It depends on the number of jobs and reports, the data volume, and whether you need ongoing support. A short review of your jobs gives us enough to quote.

From a couple of days for a simple dashboard on clean data, to a few weeks when the data needs integrating or modeling first.