Stack Overflow
Stack Overflow

Questions tagged [pentaho-spoon]

Spoon is the graphical transformation and job designer associated with the Pentaho Data Integration suite — also known as the Kettle project.

Spoon is the graphical transformation and job designer associated with the Pentaho Data Integration suite — also known as the Kettle project.

Documentation: http://wiki.pentaho.com/display/EAI/Spoon%2BUser%2BGuide

828 questions
9
votes
1 answer

Pentaho Kettle Java 11 Roadmap

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. Does anyone have details on the roadmap for the…
Stefan
  • 157
  • 1
  • 7
9
votes
4 answers

Duplicating a job in Pentaho Data Integration for different connections

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 duplicate the same job (same tables and same…
mounaim
  • 1,132
  • 7
  • 29
  • 56
8
votes
2 answers

What is the difference between a Job and a Transformation?

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 generated looks very similar. What's the difference…
nelsonda
  • 1,170
  • 1
  • 10
  • 21
7
votes
2 answers

How to run a pentaho job from Command Line

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 either. So the job seems to be starting and I know the…
OCTAVIAN
  • 336
  • 5
  • 18
7
votes
2 answers

Pentaho Data Integration: Error Handling

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 able to catch any errors and then send them to an…
jonnysamps
  • 1,067
  • 1
  • 14
  • 20
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
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
2 answers

Pass value from job to transformation in Pentaho

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 job is run and pass it to the transformation so the…
ps0604
  • 1,227
  • 23
  • 133
  • 330
5
votes
2 answers

How to check Pentaho kettle version from the command line?

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 before me has edited it. So is there any other way…
Ujjwal Chowdary
  • 125
  • 2
  • 5
  • 18
5
votes
2 answers

How to do complex document from three tables in json to mongodb using Pentaho

I have three tables in one database. These tables have a foreign key between they. The Table1 is master from Table2 and Table 2 is master from Table3. I want get data values and transform in MongoDB document like this: { "_id" :…
Renatto Machado
  • 1,534
  • 2
  • 16
  • 33
4
votes
1 answer

Pentaho DI - JSON Nested File Output

I have a requirement where I need to fetch records from multiple tables. The primary table is having one-to-many relationship to other tables. My data source is Oracle DB. Oracle db is having the specified tables. One called Student other one is…
sunita mohapatra
  • 53
  • 1
  • 5
4
votes
1 answer

Pentaho Data Integration: The job keeps running even though it has succeeded

I have a simple job of moving data from source to destination with some transformations. Most of the times the job succeeds without any issues. But lately when I run the job, it kind of gets stuck in the last with the hourglass symbol stating that…
Kuldip.Das
  • 191
  • 1
  • 3
  • 13
4
votes
2 answers

how to check data exist in targeted table in pentaho pdi

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 the data in targeted table check whether the data all…
Ravindra Gupta
  • 1,256
  • 12
  • 42
4
votes
3 answers

Spoon.batch file not launching software

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 community website for launching the software, quoted…
Rookatu
  • 1,487
  • 3
  • 21
  • 50
4
votes
3 answers

Overflow Exception when trying to write to Sql Server column with decimal(38,0) type from Pentaho

I'm trying to run a job which moves data from a set of tables in an Oracle connection to an Sql Server One. But I'm getting the following exception which causes the job stopping : 2017/04/04 11:00:56 - read from [DEMANDE].0 - ERROR (version…
mounaim
  • 1,132
  • 7
  • 29
  • 56
1
2 3
…
55 56