Category: PDI
-
Annoying feature of group by step in PDI
PDI offers two steps – Memory Group By or Group By. Both of them offer aggregate function for Concatenate strings separated by , However the result add a space before the next value. In most cases this not desirable.
-
Generate a Google access token from a JSON service account file in PDI transformation step
Overview This article explains how to generate an access token from a service account JSON file using User Defined Java Class (UDJC) step. Once a token is generated then you can use it to access Google APIs using Pentaho Rest Client or other steps. Prerequisites Create a project in Google Cloud Platform. Activate the API…
-
Automating Pentaho Data Integration testing using Behavioural Driven Development Framework
Pentaho Data Integration capabilities facilitate the process of capturing, cleansing, and storing data using a uniform and consistent format that is accessible and relevant to solve many of the data integration challenges. Testing ETL process can be accomplished using PDI embedded engine and Cucumber. Developed a java based tool which provide set of HTTP endpoints…