Stack Overflow
Stack Overflow

Questions tagged [kettle]

Kettle is a code name for Pentaho Data Integration Community Edition tool. It is an open source GUI-based ETL (Extraction, Transformation, and Loading) tool.

Kettle is a code name for Pentaho Data Integration Community Edition. It is an ETL tool (Extraction, Transformation and Loading) that uses a metadata-driven approach.

https://help.pentaho.com/Documentation/8.2/Products/Data_Integration

1387 questions
7
votes
3 answers

JSON.parse() not working in javascript in pentaho

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),Identify underlying factors (C-4),Isolate teacher…
Arunraj
  • 558
  • 5
  • 21
7
votes
2 answers

How do I concatenate string in Pentaho spoon?

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…
Thoughtful Monkey
  • 648
  • 2
  • 10
  • 24
6
votes
2 answers

nodecom.thoughtworks.xstream.mapper.CannotResolveClassException while using xstream under Kettle

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 separately from Kettle and as a simple Java application.…
Kyleinincubator
  • 313
  • 1
  • 5
  • 12
6
votes
2 answers

Problems connecting Pentaho Kettle/Spoon to Heroku PostgreSQL using SSL

I'm trying to connect spoon to a Heroku PostgreSQL instance using the JDBC driver that came with Spoon. Heroku requires SSL for it's stand alone PostgreSQL instances, which I have enabled. I'm able to connect to the database using other client…
Jamie Buchanan
  • 3,868
  • 4
  • 22
  • 24
6
votes
1 answer

How do I transpose a table in Pentaho Kettle from rows to columns without the header column

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.0 2.5 4.5 2.4 3.3 And I…
Slaski
  • 65
  • 1
  • 1
  • 5
6
votes
4 answers

How to get the reorder the column with csv input fixed column in pentaho

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 column ordering (random order) as…
yuvi
  • 564
  • 5
  • 12
6
votes
1 answer

Stop running Kettle Job/Transformation using Java

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 using a custom singleton map. My code is as below…
Sanjeev Kulkarni N
  • 341
  • 1
  • 4
  • 14
6
votes
3 answers

Send Email with pentaho PDI

I want to sent an email using PDI. I created an job and added the 'Mail' element. There are my parameters. Server smtp.gmail.com Port: 587 Use Authentication User : mygmailusername Pass : mygmailpass Secure Con Type : TLS When I run the job I get…
flexxxit
  • 2,440
  • 5
  • 42
  • 69
6
votes
3 answers

Converting Row Columns to Rows with Pentaho Kettle/PDI

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 1/1/13 123.00 Test 1 Test…
jriggins
  • 668
  • 9
  • 15
5
votes
1 answer

Kettle: Filling field with sequence without conflict

I have a data stream with the following structure user_id (integer) user_name (string) The user_id is anything between 100 and 65536. I want to add a target_user_id (integer) field according to the following logic: If user_id is in range…
Notinlist
  • 16,144
  • 10
  • 57
  • 99
5
votes
2 answers

Pentaho Data Integration not starting on new Mac M1

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 Integration 32-bit' or 'Data Integration 64-bit' as…
Ivan Romanovych
  • 51
  • 2
  • 5
5
votes
0 answers

Pentaho - Unable to create a database connection

When I go to create a Database Connection in Kettle I am getting the exact same errors as in this question: Kettle / Pentaho Data Integration - unable to create a Database Connection (XulException:…
Pierre Delecto
  • 455
  • 1
  • 7
  • 26
5
votes
1 answer

Pentaho Spoon - Output to multiple files based on field content

I have been attempting splitting the results of a pentaho transform into multiple files based on the value of a specific field without any luck. E.g. a result set containing the following: SURNAME, FIRSTNAME, COUNTRY Obama, Barack, USA Cameron,…
t_barbz
  • 747
  • 2
  • 13
  • 21
5
votes
5 answers

Passing Environment Variables to a Pentaho Kettle Transformation via script

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 various other parameters in the job and its attendant…
NullPumpkinException
  • 1,396
  • 1
  • 18
  • 22
5
votes
3 answers

Data recognition, parsing, filtering, and transformation -- GUI?

Looking for a non-cloud based open source app for doing data transformation; though for a killer (and I mean killer) app just built for data transformations, I might be willing to spend up to $1000. I've looked at Perl, Kapow Katalyst, Pentaho…
blunders
  • 3,619
  • 10
  • 43
  • 65
1
2
3
…
92 93