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

Spoon Execute remotely doesn't work

I followed the tutorials online try to design ETL process on my local machine and upload it to slave machine for execution. I did the following things: Setting up one Slave server under "Slave server" folder Right click and monitor this slave…
Hello lad
  • 17,344
  • 46
  • 127
  • 200
0
votes
0 answers

Dynimically load table text,Xml values into ETL Pentaho JOB

I am very new to Pentaho. I have one table, it has type column which has different data, such as XML, text. Here I am sending ex of type data: Type : 1." 3 132 Holt, R A …
user4355016
  • 1
  • 2
0
votes
5 answers

Expired time for acquiring lock pentaho

I'm using pentaho BI (spoon) and I have a problem with it. At each action (open job/transformation or save for example) it show this window https://i.stack.imgur.com/bqmZQ.jpg now I can't open existing transformation. Does anyone know this issue?
Motosega
  • 35
  • 2
  • 11
0
votes
1 answer

How can I design action sequences in pentaho server 5

I have a web service which uses pentaho bi server and few ktr files and one xaction file I know spoon and my ktr file is running fine as standalone But I don't know what is xaction and how to use it. I am using Penatho 5. I am searching for pentaho…
user1994660
  • 5,253
  • 11
  • 30
  • 33
0
votes
1 answer

How can I make pentaho spoon auto-create a table?

I am having few issues with pentaho spoon: I want to copy a table from one database to another. When I click on "copy table" in the tool menu, it auto creates the transformation for that. But when I run it then I get these issues: The truncate…
user1994660
  • 5,253
  • 11
  • 30
  • 33
-1
votes
2 answers

save multiple csv to multiple table in table output

I have multiple csv file for example 1.csv,2.csv,3.csv then I want to create each csv file new tables in my postgres database. currently im using "get file names" to read my folder that contains multiple csv files, then im using "CSV file input" to…
SharkJr
  • 1
  • 2
-1
votes
1 answer

Pentaho cde & Report-designer source

How to learn penatho cde dashboard and reports or how to start pentaho cde and reports and is there any books or source files, youtube channel e.t.c to learn became a good pentaho cde developer.if any books or url please share me. I want to search…
Kalla Suribabu
  • 1
  • 3
-1
votes
1 answer

How to increase pentaho transformation input/output speed

I am using Pentaho data integration (PDI)-spoon to create ETL's and I am very focused on performance. I develop an ETL to process that copy of 2,500,000 rows (each row has 104 columns) from MySQL 8 to Clickhouse database and it takes 30…
sai
  • 1
  • 2
-1
votes
2 answers

Could not connect pentaho with oracle

enter image description here this is my first time to use pentaho woth oracle. I tried to add ojdbc8.jar file into /lib but nothing changed. Can someone help on how to connect them I tried to add ojdbc8.jar file into /lib but nothing changed. I…
Muhammad Muizzuddin Muskamal
  • 1
-1
votes
1 answer

Mismatch on the day of week and week name in Pentaho

I am creating a date dimension table using pentaho and im following the tutorial linked https://www.fabguy.de/howto-create-a-date-dimension-with-pdi-kettle.html but when I preview my data, I found a mismatch between the column day of week and the…
Allen
  • 3
  • 2
-1
votes
1 answer

Permission when setup Hadoop Cluster in Pentaho

I try to setup new hadoop cluster in pentaho 9.3 but i got permission error. It requires username and password for hdfs but i don't know how to create user and password for hdfs. step 1 step 2 I get Error Error
Yoona Lim
  • 1
  • 2
-1
votes
1 answer

How to use loop to find related object using Pentaho Data Integration

I want to identify the bad/invalid records so that i can add in a separate SQL Table. For example, we have an account object. And i want to find bad accounts. But i need to apply some filters on contact object. If conditions satisfy based on contact…
Tayyaba Noor
  • 1
  • 1
-1
votes
1 answer

Delete records from MySQL source database table ,after copying to MySQL target database using Pentaho spoon

I would like to do the below operation using Pentaho spoon/PDI. Copy data from the Mysql source database to the Mysql target database. 2)After that I would like to truncate/Delete Data from Source Database Can Someone help with this?
Pydi Raju
  • 103
  • 3
-1
votes
1 answer

Pentaho - Spoon - Kettle delete if exist rows (obtained in a previous step) in a target table

I'm working in a transformation where I'm obtaining some data in stream, the problem is that I want to check if each element obtained exist in a table B (target), if those elements exist I want to delete each one of them, but the problem is that I…
Eduardo Silva
  • 1
-1
votes
1 answer

Pentaho Text Input multiple languages English and Japanese Characters Loaded into MSSQL data table separate columns

I am trying to load a SQL table with a text file. I am using the Text File Input Step. All but one column may contain Japanese characters(Comment). How can I pass all English text and Japanese text as readable characters? Is there a regex or Java…
CPHILLIPS1234
  • 45
  • 4
1 2 3
…
55 56