Most voted "pentaho-kettle" questions
Kettle is an alias for Pentaho Data Integration, an open source data extraction, transformation and loading (ETL) tool.
Learn more…15 questions
Sort by count of
-
5
votes2
answers541
viewsProblem with LEFT JOIN using Pentaho Kettle
There is a behavior with respect to JOIN that I cannot understand. I have two tables in these formats Table Doente ID_Doente Doente 1 Pedro 2 Paulo 3 Rui Table query ID_Consulta ID_Doente Tipo 1 2…
-
3
votes1
answer1474
viewsJava Spring Boot - Read a file from the Resources folder inside a . jar
I am writing a class that will read an ETL Pentaho Kettle (transformation). I have put the file that the class will read in the Resources / KTR folder. But when I try to run the code as a java…
-
1
votes0
answers81
viewsError "Assert: Shift is not as expected" when creating report
I created a report in Pentaho Report Designer. There are 13 pizza charts in a row, just changing the query from one to the other. When I added graph number 11 and went to visualize, I got the error…
-
1
votes0
answers18
viewsPentaho - Error when trying to write to an Oracle table
I created a process in PDI that makes a query in a Postgres table (step Table Input) and then selects the desired fields (step Select value) to then execute the insertion of the metadata of these…
pentaho-kettleasked 5 years, 11 months ago aleestevao 133 -
1
votes0
answers373
viewsPentaho - Kettle - Job runs on the Spoon, but does not run on the Kitchen
I have a job simple that simply runs a transformation that connects to the Oracle database via jdbc, makes a select by a database input and writes the data to another table. It turns out that in…
-
1
votes0
answers354
viewsJava Spring Boot - Read file inside the . Jar
I’m doing a class that will read an ETL Pentaho Kettle (transformation), I put the file that the class will read in the Resources/KTR folder. But when I try to run the code as a java application…
-
1
votes1
answer303
viewsProblems importing data with Microsoft Excel Input
I’m importing several spreadsheets into a database, but some of them are having input problems. I’ve even tried to transform the format and use CSV File Input, but the problem remains the same. The…
-
0
votes2
answers989
viewsPentaho Data-Integration
I configured the PDI to access an FTP server and download a file in csv, so that’s okay, the problem is that inside the folder on the FTP server there will always be more file, example:…
pentaho-kettleasked 6 years, 7 months ago Edvaldo Lucena 135 -
0
votes1
answer287
viewsInsertion of foreign keys by the kettle
I need to load some data that are in spreadsheets in a relational database, but I have been facing some challenges regarding the insertion of foreign keys. In these images you can see that I first…
-
0
votes1
answer117
viewsJenkins - Pentaho execute script as logged in user
Good afternoon gentlemen, I’m using Jenkins to run a job in Pentaho, this job runs a script, which simulates user interaction, but as Jenkins runs in the background, it does not associate with any…
-
0
votes1
answer472
viewsPentaho - Error running bat by Windows Task Scheduler
Follows the code of .bat: @echo off TITLE MeuProcessoAutomatico SET currentdir=%~dp0 SET kitchen=C:\pdi\data-integration\Kitchen.bat SET logfile="%currentdir%main.txt" echo. >> %logfile% echo.…
-
0
votes0
answers5
viewsDenormalization of data with Pentaho
Suppose I have a table like this below in a CSV file, there is some command in PDI that I can turn the table into a dimensional model without I need to manually create columns with the relationship…
-
0
votes2
answers1611
viewsPentaho Data Integration repository does not appear in PDI
Good night. I’m in constant trouble with the PDI. Sometimes when I open Spoon.bat it doesn’t load the repository and it doesn’t enable the option to connect to a repository. I’ve searched several…
-
0
votes1
answer84
viewsReturn a JSON block within another block
Hello! I am using Pentaho Data Integration to return a JSON from the Twitter API, but I have an error in processing JSON and return only the values I want. I’m trying to return block values…
-
-1
votes1
answer105
viewsDELETE IN SQL WITH WHERE STATEMENT NO ID REQUIRED
I have ZIP table with a new OP field with DEL information to delete. When I perform the instruction: DELETE FROM cepdb.log_bairro where BAI_OPERACAO = 'del'; Returns: 2 Cannot delete or update a…