I have an issue when I try running Pentaho Data Integration on Mac bigSur (M1). issue code in below: I'm sorry, this Mac platform [arm64] is not yet supported! Please try starting using 'Data Integ...

Having finally got kettle to start and not hang, I still cannot use it to much avail, as when I try to create a new Database Connection (after creating a new Transformation) I get this error: org.p...

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 have a job and multiple transformations. If i wanted to define a database connection in the Job , and use the same database connection for all the transformations , how do I go about it ? I am us...

I have written Java code to execute my transformation and Jobs and I have manually added all the Jar files present in the data-integration/lib folder to my class path and evrything is working fine....

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 using windows batch file to call a Pentaho Data integration job, intermittently, the job gets hung indefinitely. The error message in Pentaho logs is as below : 06:43:37,951 ERROR [Blueprin...

Scenario: I have created transformation to load data into table from csv file and I have following columns in csv file: Customer_Id Company_Id Employee_Name But user may give input file with c...

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...

I am trying to form an array from a string using Modified Java Script Value step. Here is my code to parse a string and to form a JSON object. var info = {}; var keywords = 'Adjust course (C-6),Id...

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....

I'm developing a web-app based ETL too (with Kettle engine), using Java. I'm running into issues, while trying to stop a running Job. I'm not sure if using the CarteSingleton.java is correct. I'm...

I am quit new to linux and Amazon EC2. i configure JAVA_HOME by following below two link How to know JAVA_HOME_Variable bash_profile so current path in my bash_profile are export JAVA_HOME=/us...

I am using oracle SQL queries in an external Program (Pentaho Data Integration (PDI)). I need to convert all columns to string values before I can proceed with using them. What i am looking for ...

I've been using Pentaho Kettle for quite a while and previously the transformations and jobs i've made (using spoon) have been quite simple load from db, rename etc, input to stuff to another db. B...

I have a requirement such that whenever i run my Kettle job, the database connection parameters must be taken dynamically from an excel source on each run. Say i have an excel with column names : ...

Brand new to Pentaho (and a newbie SO poster so look out!) I'd like to use Kettle/PDI to transform data coming in from an RDBMS from this (for example): Question1 Question2 Question3 Question4 ...

I'm trying to process the following with an JSON Input step: {"address":[ {"AddressId":"1_1","Street":"A Street"}, {"AddressId":"1_101","Street":"Another Street"}, {"AddressId":"1_102","Street"...

I would like to dynamically add fields (or a new columns) to the resulting output row in Kettle. After spending hours reading through froum posts and he not so well done scripting documentation, I...

I am a newbie to Pentaho (installed today). I was able to do basic transformation in Spoon. Now I need to do some stuff, which I can't figure out how. my input looks like 2012-09-17|garima|fbhjgj...

I am processing data, where i get some information from rest api, based on the value of a field. Now, value may repeat for that field and if I already have fetched the data for that value, from R...

I am using XStream under Kettle to deserialize XML to a Java object and it always gives me the exception: nodecom.thoughtworks.xstream.mapper.CannotResolveClassException Then I tried my code separ...