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
2 answers

Pentaho Spoon: load SQL code from txt file and run it

I'm using Execute SQL Script component to send SQL code to MSSQL to be executed. But I'd rather save SQL code in txt files, so that Subversion can control their changes. These files will be stored in a sql present on the same level of ktr file. I'd…
Hikari
  • 3,797
  • 12
  • 47
  • 77
0
votes
0 answers

Create report using data from 3 excel sheets sheets in pentaho

I just want to create a report using few excel sheets as the input in pentaho. After creating the report need to send it through email and to be specific the email should be scheduled.
Sheron
  • 61
  • 2
  • 7
0
votes
1 answer

Customize Pentaho Spoon components using Java

I'm still pretty new on Pentaho Soon. I'd like to know if this would be possible to be achieved. In the past I had many bad experiences with SSIS, so I decided at the time to develop my own ETL using C#. In practice, .Net only does the extract step.…
Hikari
  • 3,797
  • 12
  • 47
  • 77
0
votes
0 answers

Not able to fetch all files from Pentaho

I have to fetch approximately 2000 files using Pentaho Spoon but I am only getting 175 files. Is there any way to fetch all the files? Pentaho Spoon Failed Fetching
Allen BMC
  • 27
  • 1
  • 1
  • 5
0
votes
1 answer

Pentaho Error: Duplicate entry for non primary key

Hi guys i am new into pentaho, using pentaho kettle version 7.1 and mysql jdbc driver version is 5.1.43. I have two same table in different database. Let's called db1 is first database which hosted in production and db2 is another database which…
Jais Anasrulloh Ja'fari
  • 677
  • 9
  • 32
0
votes
1 answer

PowerShell script in Pentaho

I would like to use a PowerShell script to count lines in a text file. I use this code: Set-Location -Path D:\ $measure = Get-Content b27.csv | Measure-Object $lines = $measure.Count echo "line count is: ${lines}" However, I have got error. I…
SN Palita
  • 87
  • 1
  • 1
  • 9
0
votes
1 answer

[Pentaho][Using Shell script][CMD] insert count line and table name into txt file

I am trying to writing script by using shell scripting in pentaho. First,file name "test_viewpayment4.txt". I have to count the line, the correct output is 100(which not include the header), and I have to get the file name also. After that,creates…
SN Palita
  • 87
  • 1
  • 1
  • 9
0
votes
2 answers

Generate consecutive rows in Pentaho

How do I generate consecutive rows in Pentaho Spoon? I have a text file and I am using "Sample Rows" step to select every third line from the text file. But the problem with the "Sample Rows" is that I have to manually type "3,6,9,12....". I tried…
Allen BMC
  • 27
  • 1
  • 1
  • 5
0
votes
1 answer

Pentaho Spoon Database Lookup, how to compare between dates

I'm using Pentaho Spoon to develop an ETL, I need to make a serie of lookups taking Extract's denormalized data and retrieving Dimension's PKs. One of these dimensions has starting and ending date for the vigency of a record. So, I need to lookup…
Hikari
  • 3,797
  • 12
  • 47
  • 77
0
votes
3 answers

Pentaho error Required subelement 'user'

I get a error when I try to preview the query: I get this error : ParentException: java.lang.RuntimeException: Required subelement 'user' at org.osjava.sj.loader.convert.DataSourceConverter.convert(DataSourceConverter.java:54) at…
Hayk Manukyan
  • 1
  • 3
0
votes
1 answer

Not able to get system data at the end of transformation step

I wants to log transformation start time and end time into table. But I am getting error Field [start_date] is required and couldn't be found!. Following steps I did. Step 1 : Get Transformation name and system date from Get System Data as …
sachin
  • 1
  • 1
0
votes
2 answers

How to generate Password Protected output file in Pentaho Data Integration?

Stuck in a strange problem. As per client requirement, I need to generate all text output files in PDI with password-protection. I have implemented PGP encryption and Symmetric cryptography(OpenPGP configured on mysystem). But I am at loss how to…
Vikas Kumar
  • 87
  • 2
  • 18
0
votes
1 answer

Pentaho's "Hadoop File Input" (Spoon) always displays error when trying to read a file from HDFS

I am new to Pentaho and Spoon and I am trying to process a file from a local Hadoop node with a "Hadoop file input" item in Spoon (Pentaho). The problem is that every URI I have tried so far seems to be incorrect. I don't know how to really connect…
Catalin Dumitrache
  • 21
  • 5
0
votes
2 answers

Pentaho Kettle LDAP Output

How do I update the LDAP value using LDAP Output Step in Spoon? I couldn't find any documentation on Pentaho's website. I am trying to update the group name of a particular user in Active Directory. Until now, I was able to connect with the AD. But…
Allen BMC
  • 27
  • 1
  • 1
  • 5
0
votes
0 answers

I can't see my transformation files (PDI) in Pentaho user console

I have csv files in the local file system that contain output results of a program. I want to use Pentaho CDE to visualize those data in graphs (Pie charts ...) I can do that if I upload my csv files directly as a datasource. But I would like to…
AsmaaM
  • 63
  • 2
  • 3
  • 12
1 2 3
…
55 56