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

Remove special characters using Pentaho - Replace in String

I wanted to remove the special characters like ! @ # $ % ^ * _ = + | \ } { [ ] : ; < > ? / in a string field. I used the "Replace in String" step and enabled the use RegEx. However, I do not know the right syntax that I will put in "Search" to…
M. Loyyy
  • 45
  • 1
  • 1
  • 4
4
votes
4 answers

Pentaho | GC overhead limit exceeded

I want to insert data from xlsx file into table. Excel has around 1,20,000 records. But while running transformation, I am getting below error: GC overhead limit exceeded I have changed in spoon.bat. Xmx2g -XX:MaxPermSize=1024m But still I am…
Nilesh Patil
  • 91
  • 2
  • 11
4
votes
0 answers

How to retrieve data from webservice with pagination using pentaho data-integration tool?

I am attempting to use the rest client to query a webservice for data. The flow is as follows: POST request with the query that returns a cursor Id (Get Initial Cursor) GET request with the cursor ID to retrieve the first batch of 5000 rows Along…
Shoan
  • 4,003
  • 1
  • 26
  • 29
4
votes
1 answer

How to read password protected excel input in pentaho?

How to read data from a password protected excel sheet in pentaho excel input step? If we cant read data from password protected excel sheet, how can we skip the file and read only password less excel sheets in pentaho? Please help me with…
harish kumar
  • 45
  • 1
  • 8
4
votes
1 answer

Pentaho generic error handling script

At this moment I am trying to make a generic error handling script using Pentaho. So far I've found some information about Shell scripts but they do not seem to work for me. What I want to create is a script (Shell or whatever) that can send…
Mick
  • 324
  • 4
  • 14
4
votes
1 answer

Pentaho ETL : Database Join vs Table Input

I need to write a database table data to a text file with some transformation. There are two steps available to retrieve the data from the table, namely Table input and Database join. I don't see much difference between them except the "outer join?"…
Jeet
  • 1,006
  • 1
  • 14
  • 25
3
votes
1 answer

REST API calls through Pentaho Data Integration (Spoon)

Hello Pentaho Experts, I am attempting to make a REST API call through REST Client in Pentaho. I have a Api key for authentication. I tried it in Postman, and it works perfectly fine, but Pentaho throws 403 status code. Below is the postman…
Nikhil
  • 621
  • 1
  • 13
  • 25
3
votes
2 answers

MySQL Pentaho communication link error ETL

When trying to load one month data from DW by the last day of the month or second last day of the month, while loading the data, communication link error comes and it stops the running job. due to this last few set of data is not loading. About…
Sathish D
  • 4,854
  • 31
  • 44
3
votes
1 answer

How can I replace the value of a field(s) based on another field(s) in Pentaho

I need to replace some values that I get from a database with the values of another field (same database), providing the other field is populated. In my database I have the following fields (amongst others): RMM, RMY, IRM, IRY If IRM is populated I…
J.A
  • 41
  • 2
  • 6
3
votes
2 answers

How to setup Headers and body on REST POST method in Pentaho?

I need to setup headers (Authorization) on the REST Client (Post method) in Pentaho. I'm passing on the Authorization header as a parameter to the REST Client. Then use that variable inside the Headers field. But I'm not sure I'm doing it…
luiz kava
  • 187
  • 1
  • 2
  • 14
3
votes
2 answers

blocking Step vs Block this step until steps finish in Pentaho transformation

What is the use case of blocking step in Pentaho Transformations ? In which scenarios we will be using this step in Pentaho transformations. I understood that "block this step until steps finish steps" is to control synchronization by configuring…
Rams
  • 729
  • 10
  • 11
3
votes
8 answers

Pentaho spoon is not starting

I'm just trying to open the GUI interface, but it is not opening and without any reason, any error message. Any Idea? C:\software\data-integration>Spoon.bat DEBUG: Using JAVA_HOME DEBUG: _PENTAHO_JAVA_HOME=C:\Program Files\Java\jre1.8.0_152 DEBUG:…
Nuno Ferreira
  • 41
  • 1
  • 1
  • 5
3
votes
3 answers

How to calculate the overall value of the row?

The results I want Please Help Me, Thanks for attention.
Endi Nurcahyo
  • 31
  • 3
3
votes
2 answers

How to create an ArrayList object in an User Defined Java Class in Kettle?

I am trying to declare an ArrayList object in an User Defined Java Class object in pentaho kettle. I am trying a simple code inside the User Defined Java Class: import java.util.List; import java.util.ArrayList; List where = new…
psr
  • 2,619
  • 4
  • 32
  • 57
3
votes
1 answer

How to get Field value in User Defined Java Class in kettle?

I am trying to get the Link field in the User Defined Java Class step from my below transformation. Here is the code which I have written in User Defined Java Class: private String link; public boolean processRow(StepMetaInterface smi,…
psr
  • 2,619
  • 4
  • 32
  • 57
1
2
3
…
55 56