Category: Programming
-
TRANSFORM CONSTANTS in Modified JavaScript | Pentaho Data Integration
In Modified JavaScript Step in Pentaho, you will notice that there are few pre-defined variable or constants defined. Check the image. What is interesting here…
-
Passing Parameters to Kettle Using Java | Pentaho Data Integration
The blog post provides instructions on how to pass parameters in Pentaho Data Integration/Kettle, both in transformations (.ktr) and jobs (.kjb) using a Java code.…
-
Inserting XML Node into a XML Source Data using Pentaho Data Integration | Handling Complex XML Structures
Inserting a new xml node into a complex XML data source will fail with the approach provided in my previous blog. This is because handling…
-
Inserting XML Node into a XML Source Data using Pentaho Data Integration
Let us suppose, we have a XML data source as below: Now if we want to insert a new XML Node in between the <Node></Node>…
-
Using External Jars import in Pentaho Data Integration
[Update 2023]: This blog is now applicable for the older versions of Pentaho Data Integration. Pentaho version 8, 9 and above are not applicable and…
-
Java and Pentaho Kettle | Executing a Kettle File using Java
The blog provides steps for executing transformation files in Java using Pentaho Data Integration. It guides through creating Maven Project, adding dependencies, creating a sample…
-
Special Character Remover | version 1.1.0 | Pentaho Kettle Step Plugin
This is a blog on an upgraded version of the Special Character Remover Pentaho Kettle Plugin. Please read the Version 1.0.0 of this plugin before…
-
Special Character Remover | Clean your data of special characters | Pentaho Kettle Step Plugin
Problem Statement When handling data especially in a data warehousing environment, developers tends to face serious issues with the data quality issue. Though there are…
-
Maven Dependencies for building Pentaho DI (Kettle) Plugins
[Update 2023]: This blog is updated with information for Pentaho Kettle 8.x.x or higher. For Pentaho Kettle version 8.0.0 or lower In case you want…
-
Adding Parameter – Pentaho Report Designer | Stop repetitive task
[Update 2023]: If you are an Enterprise user of Pentaho/Hitachi Vantara, please contact the Pentaho support team to help with approved solutions and approach. Otherwise,…
-
Memory Handling in Pentaho Data Integration
The post discusses how to handle memory issues in Pentaho. Solutions include increasing memory parameters for on-premise installations, making specific considerations for running Pentaho on…
Tech Spaghetti 