Currently Pentaho Kettle (v.9.1) officially only support Java 8. This is a problem for us, since we are maintaining a plugin that needs Java 11 because of a essential library that needs Java 11. Do...

I downloaded Pentaho Data Integration (or Kettle) to my Windows 10 machine from the sourceforge link on the Pentaho Community website. After unzipping the files I followed the instructions on the c...

Have a job which takes around 1/2 minutes to finish, now trying to run this job through the command line just goes on forever and doesn't finish. It doesn't look like I get any errors from this eit...

I am required to parameterize all variables in my kettle job and a transformation (the jobs will be run in AWS and all params are passed in as environment variables). My connections, paths and va...

I am comparing two sheets using Merge Rows (diff). 1st excel sheet: 2nd excel sheet: and my pentaho transaction: in preview data showing, that id 2.0 at 2nd row is add new row and at 4 ro...

M using pentaho spoon first time, i have one input table and i written one sql query, and want that the resulting data of the input table to store in different targeted table, but before storing th...

I have the following transformation in Pentaho PDI (note the question mark in the SQL statement): The transformation is called from a job. What I need is to get the value from the user when the ...

I'm building out an ETL process with Pentaho Data Integration (CE) and I'm trying to operationalize my Transformations and Jobs so that they'll be able to be monitored. Specifically, I want to be a...

I know I can check the Pentaho version by opening the spoon.sh in vi mode, but the Pentaho that is installed in production environment doesn't have that information in it. Probably some employee be...

I've generated a job via the Copy Tables wizard in Spoon UI, that copies some tables from an oracle database source to an SQL Server one, and made some changes to the job as well. Now I want to d...

When creating new objects in spoon there's two possibilities: Job and Transfromation. They've got a different set of possible components (although with some level of overlap) and the XML that is ge...

I'm new to Pentaho and I need to transpose a table from rows to columns, but the first column doesn't contain the headers. It looks something like this: Jan/15 Feb/15 Mar/15 Apr/15 1.1 3.4 1.7 2....