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

License Missing or Expired Pentaho after Reinstalling

I installed the Pentaho server yesterday and had to reinstall it due to some modifications done by me. Now after reinstallation it when I try to log in to User Console it says like License files are missing or Expired. Expiration can't happen since…
Yasiru Nilan
  • 447
  • 5
  • 28
0
votes
2 answers

Set FTP file download limit in pentaho job

I have a pentaho job which contain "get file with ftp" entry which download all file from remote server to local. How can i limit the file download to a specified number, ie:if 300 files are there in remote directory i want to download only 50…
Nandu
  • 151
  • 1
  • 2
  • 12
0
votes
1 answer

Pentaho PDI (Kettle/spoon) Meta Data Injection for text files

I am interested in importing a Fixed Width file using Pentaho PDI. I have used its main GUI tool that sets the widths graphically in Spoon. BUT if the number of fields is very large, like a few hundred fields, it would be prone to error and take a…
Palu
  • 668
  • 3
  • 11
  • 26
0
votes
2 answers

Index function : Pentaho Data Integration

I need guidance regarding the most approriate approach to perform a index function using pentaho Data integration ( kettle ) my situation is as following : using the GLOBAL voip system report, I stored all data in a Mysql Database, which gives me…
Rootinshell
  • 1
  • 3
0
votes
1 answer

Pentaho Web Services Lookup can't load the url

I put de url and try load, but happen this error. I'm sure that it's work, because I can call this url in SOAPUI...
luiz kava
  • 187
  • 1
  • 2
  • 14
0
votes
1 answer

Skip first line in csv read on Kettle

Hello i am trying to skip the first line of a csv file when i import it to Kettle Pentaho PDI 8.1.0. The first line has the separator declaration sep=; The second line has the Headers. Cause of the first line the get fields button read only two…
kyrpav
  • 756
  • 1
  • 13
  • 43
0
votes
2 answers

CSV encoding inside input text file step on Kettle

I am doing i simple input text file into Kettle Pentaho PDI 8.1.0. The file has several acceding char like "á" and it is a .csv file. In the settings of the input text file step i set the encoding to ISO-8859-1. So when i go to "Show file content"…
kyrpav
  • 756
  • 1
  • 13
  • 43
0
votes
3 answers

Pentaho Transformation "Execute SQL Statements" vs "Table Input" step

I am new to PDI/Kettle.I need to execute simple SQL select similar to "SELECT EMPID FROM Employee" and need to write the output to "Microsoft Excel Output" as part of reports generation. When I write this query in "Execute SQL Statement" step under…
Rams
  • 729
  • 10
  • 11
0
votes
1 answer

How to set a starting point in a job?

The transformation file, ending in .ktr, runs with no problem: 2018/07/10 15:40:54 - Spoon - Transformation opened. 2018/07/10 15:40:54 - Spoon - Launching transformation [FullCoverageTestCaseSalesMappingToReconciledSchema]... 2018/07/10 15:40:54 -…
nicomp
  • 4,344
  • 4
  • 27
  • 60
0
votes
0 answers

Read jboss access logs from pentaho spoon

I'm new to pentaho and learning to work with using Spoon. My task is to connect to jboss and read access logs to generate performance report . I could not find any relevant documentation or solutions on internet . Could someone help me with this ?…
ostudy
  • 33
  • 5
0
votes
1 answer

Passing variable in column mapping of CSV file input

I have a CSV file Input step using which I am populating the CSV file data into my final_result table successfully. However, there is a ID column in my final_result table which will show that this feed belongs to which batch. The value of this ID…
sachin vaidya
  • 55
  • 10
0
votes
1 answer

Pentaho failing connection durring Job

Im importing data from Microsoft SQl database to MYSQl data base. I created a seperate transformation for each table input so i couldnt control the order of the imports of each table. the transformations all work when i run them seperatly but when I…
thisguy
  • 51
  • 1
  • 2
0
votes
0 answers

How to access pagination values in kettle from pentaho cde?

I have a table component with data source attached to kettle transformation. Now, I want to implement server side pagination and access the parameters "pageStart" and "pageSize" set by pentaho in kettle transformation using getVariables. I have…
Zeeshan Cornelius
  • 308
  • 1
  • 4
  • 15
0
votes
1 answer

How to set content-type in Rest Client step

I'm using the Rest Client as below, But every time I have the same error message HTTP Error 400. The request has an invalid header name. When I use the same config in postman client, (Content-Type:application/x-www-form-urlencoded) I've success…
luiz kava
  • 187
  • 1
  • 2
  • 14
0
votes
1 answer

Error Showing While Running Pentaho Data Integrator Community Edition on OSX

While running spoon.sh from my Mac OS I found following error: After a long time spoon open but there is no option in Design or Transformation. I am using OSX 10.13.5
Md Sirajus Salayhin
  • 4,974
  • 5
  • 37
  • 46
1 2 3
…
55 56