Questions tagged as 'pentaho-kettle'

1
answer

Problem with LEFT JOIN using Pentaho Kettle

There is behavior regarding JOIN that I can not understand. I have two tables in these formats Sick Table ID_Doente Doente 1 Pedro 2 Paulo 3 Rui Query table ID_Consulta ID_Doente Tipo 1...
asked by 17.03.2014 / 16:44
1
answer

Java 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 put the file that the class will read in the Resources / KTR folder. But when I try to run the code as a java (java -jar) application, I get an error saying that th...
asked by 28.08.2018 / 14:12
1
answer

Problems 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 data in Excel looks like this: WhenItryt...
asked by 10.10.2018 / 00:15
0
answers

Pentaho - Error trying to write to an Oracle table

I created a process in the PDI that makes a query in a table Postgres (step Table Input) and then selects the fields (step Select value) to later execute the insertion of the metadata of these fields in an Oracle table (spep Table Output). er...
asked by 17.10.2018 / 22:12
0
answers

Java Spring Boot - Read file inside .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 (java -jar) application, I get an error saying that the f...
asked by 27.08.2018 / 21:21
2
answers

Pentaho Data-Integration

I configured the PDI to access an FTP server and download a file in csv, so everything is fine, the problem is that inside the folder on the FTP server there will always be more of file, REC_PEND_FECH_COM20180219130059.csv REC_PEND_FECH_COM201...
asked by 22.02.2018 / 19:01
0
answers

"Assert: Shift is not as expected" error when creating report

I created a report in Pentaho Report Designer. There are 13 pizza charts in a row, changing only the query from one to another. When I added graphic number 11 and went to visualize, I got the error below. I checked the SQL of the query and it...
asked by 16.04.2014 / 19:09
1
answer

Inserting foreign keys by Kettle

I need to load some data that is in spreadsheets into a relational database, but I have been facing some challenges with regard to inserting foreign keys. In these images you can see that I enter the project data first, the auto increment of...
asked by 27.08.2018 / 00:37
1
answer

Pentaho Data Integration repository does not appear in POI

Good evening. I have a constant problem with the POI. Sometimes when I open spoon.bat it does not load the repository or even enable the option to connect to a repository. I have already researched in several forums and so far the past soluti...
asked by 06.11.2018 / 21:51
0
answers

Spoon Kettle does not work after updating Ubuntu packages (14.04)

The spoon was working normally until an Ubuntu update was run. After updating the command ./spoon.sh nothing happens and the application is not started. I accessed the update log and saw that only postgresql stuff was updated as shown...
asked by 17.08.2018 / 19:19