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
2
votes
1 answer

How mysql repository works in Pentaho User console?

Based on Pentaho guideline (https://help.pentaho.com/Documentation/8.2/Setup/Installation/Archive/MySQL_Repository) I successfully converted pentaho File based repository to MySQL database repository. Now does anyone have any idea how MySQL…
NP007
  • 659
  • 8
  • 21
2
votes
2 answers

Pentaho cannot connect to SQL Server 2017

I downloaded the latest Pentaho version (v8.3) from here and successfully connected to PostgreSQL. When I try to connect to SQL Server 2017: and hit the TEST button, nothing happens. After I did a re-search, I tried different solutions but nothing…
display_name
  • 91
  • 1
  • 1
  • 7
2
votes
1 answer

Where do I upload p12 file received from Google Analytics to Pentaho Server?

I am using Pentaho community version and using PDI on my local machine. I am trying to integrate PDI with Google Analytics and I am able to do so with my local machine. But when I put the same transformation file on to the server (PUC upload), It is…
Rosh Verma
  • 157
  • 1
  • 1
  • 8
2
votes
1 answer

How can I pass parameters from Windows command prompt to Kitchen.bat (Pentaho)?

My problem I have created a Windows cmd file test.cmd which is expecting two parameters to be passed to Kitchen.bat (Pentaho). I call test.cmd in Windows command line by passing two parameters: test.cmd 1 2 In Spoon (designer), I write the two…
Edward
  • 23
  • 4
2
votes
1 answer

can I get parameters from URL in pentaho?

Can I use a parameter from Carte's URL in a Job? Something like this: http://localhost:8080/kettle/startJob/?name=myjob&xml=Y&testvar=filename.txt I want to do this because I have a job to transform an input file but I want to change that filename…
Ms13
  • 151
  • 2
  • 2
  • 14
2
votes
1 answer

Pentaho Spoon:How to modify all the values of a column?

I am new to Pentaho spoon and even after a long time of research, didn't resolve my problem: I have a table, and want to multiply by 3 all the values of few columns. For instance, if I have inside of a column (5, 10, 3) then it becomes (15, 30,…
user11492726
2
votes
1 answer

Unexpected conversion error while converting value [BigNumber] to a BigNumber

I am getting the field X from a lookup and trying to Load into a table using Insert/Update. But I get an error saying "Unexpected conversion error while converting value [BigNumber] to a BigNumber" I have even used select values and gave type with…
user10449251
  • 45
  • 9
2
votes
1 answer

Pentaho DI Opening transformation: [null] in directory

guys! I have problem with starting kettle job from server. I have simple job with one trasformation. Trasformation is saved in the repository server. job in spoon If i start job from Pentaho local machine, the job runs successful, but transformation…
Nelli
  • 31
  • 2
2
votes
1 answer

PDI: Output only if no errors

i want to transform a csv-file to an XML-file. In the Transformation i have also a small Validation of data, for example length of a string must be < 50. So i have a Textfile Input Step > Modified JavaScript Step with two hops to Abort Step (for the…
Marko Unverzagt
  • 23
  • 2
2
votes
2 answers

Unzip file issue in Pentaho-spoon

I'm trying to unzip a file in a job, everything's ok until the filename inside the zip has some special characters like "á, é, í, ó, ú". When the filename inside the zip has those characters I got an error and this log: Unzip file - ERROR (version…
Roger Nieto
  • 63
  • 10
2
votes
0 answers

Pentaho Kettle don't work after packages update on Ubuntu 14.04

The spoon was working normally until an Ubuntu update was run. After updating the . / spoon.sh command don't start the application. I accessed the update log and saw that it only updated things pertaining to postgresql as shown…
Danilo Santos
  • 21
  • 4
2
votes
1 answer

Creating a JSON structure in PDI without blocks

I'm trying to get a simple JSON output value in PDI from a field that was defined in an earlier step. The field is id_trans, and I want the result to look like {"id_trans":"1A"} when id_trans value is 1A. However, when using the JSON Output step…
cdel
  • 21
  • 5
2
votes
2 answers

Where to download sun.jdbc.odbc.JdbcOdbcDriver (trying to connect output csv from Spoon to SSMS)

I have a csv that I have transformed in Kettle/Spoon/PDI and I am trying to output it to SSMS. In Spoon, it's a two step process: read the csv (and edit a couple types), then output to SQL. I get this error: "Driver class…
CD9999
  • 109
  • 1
  • 3
  • 14
2
votes
1 answer

Merge Rows (diff) is comparing row by row, not one row to entire rows of other table

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 row its showing same data is delete, its suppose to…
Ravindra Gupta
  • 1,256
  • 12
  • 42
2
votes
1 answer

Pentaho Kettle Database Repository

Currently we have multiple file based kettle repositories, we are planning to move them to database . Some of these repositories have transformations with same name, we have a oracle back end and when we are trying to import the repositories into…
Ravi
  • 2,470
  • 3
  • 26
  • 32
1 2 3
…
55 56