Our Blog


Anupam Dasgupta

Hitachi Vantara launched Pentaho 8.0 in the recently concluded Pentaho World 2017. We at GrayMatter, as pioneers in Pentaho from 2006, view this as a breakthrough in the analytics world particularly with respect to Big Data. GrayMatter has proven expertise of delivering remarkable ROI on Big Data Analytics engagements to global customers. This expertise coupled with the …

Read full Blog.



Manikandan Anbalagan

GrayMatter‘s experts address customers’ Pentaho Reporting related needs and challenges on a daily basis. Starting from data integration using Pentaho Data Integration to dashboarding using dashboard designer, reporting using report designer, best-in-class custom components, we have done it all for 200+ projects around the globe. I am going to focus on reporting in this blog. …

Read full Blog.



Jagdeesh SS

Pentaho Reporting Export Options

October 13, 2016   Posted By


This is a part of a series of blogs that provide quick tips and tricks to enable better usage of Pentaho. We start with this piece on improvising your Pentaho reporting export options. Have a look at the below GrayMatter‘s Pentaho screenshot. This is a snapshot of a PRPTI report exported to excel. As you …

Read full Blog.



Gangadhara Boranna

Clustering means that 2 or more instances of Pentaho share a common repository. Pentaho 5.0.X now uses the Jackrabbit Content Repository (JCR) for the BA Repository. Pentaho reporting related content, for instance, about reports that you create, examples we provide, report scheduling data, and audit data in the BA Repository. The BA Repository resides on …

Read full Blog.



Sandeep Kemparaju

We are looking at a transformation designed to use insert/update step to perform data load on the target table. Pentaho Kettle step Insert/Update works as follows Let us take an example of loading a target table. Assume that there is a daily load of 100k records into a target table with 10 million records and …

Read full Blog.



Gangadhara Boranna

We strongly encourage you to move to Pentaho’s latest environment that provides advanced Pentaho Data Migration features. Listed below are 6 top reasons why Pentaho 5.0 could be your ideal solution. 1. Integrated Administration in PUC & Merge of enterprise console into Pentaho user console This aspect gives a completely fresh look to the user …

Read full Blog.



Gangadhara Boranna

There are several Performance tuning methodologies in Pentaho. However, Pentaho Developer Dashboard designs are a combination of individual components such as reporting and analyser. Any Pentaho Developer Dashboard performance tuning would need to impact all such components. Two such areas are 1) Size of Data to be transferred from server to client environment (To optimize …

Read full Blog.



Gangadhara Boranna

Cross-tabs have been on the horizon for several years now. They lived a happy, undisturbed life along with the unicorns and gnomes guarding the pot of gold at the end of the rainbow. In Pentaho BI Implementation, Cross-tabs are an easy and relatively easy way to visualize tabular data along two or more axis. They …

Read full Blog.



Suresh Narayanappa

Pentaho and Big Data

April 21, 2014   Posted By


GrayMatter‘s Pentaho Big Data Services provides open source reporting, data mining, and analysis, workflow and dashboard capabilities. The company’s CEO, Quentin Gallivant, made a few predictions relating to Big Data for 2014. In my next blog sometime in May am going to share a unique use case for a Big Data implementation. The “power curve” …

Read full Blog.



Suresh Narayanappa

Pentaho Corporation recently announced the immediate availability of its Open Source Pentaho Community Edition 5.0 (Pentaho CDE). It is the latest version of business analytics and open source data integration platform. The launch event also included the Pentaho Marketplace, where members of the community can download and explore all available plug ins developed by the …

Read full Blog.