3,854 questions
-1
votes
1
answer
65
views
How do I clear the cache in Pentaho Data Integration? [closed]
How do you clear the cache for Pentaho in a Linux environment? Is there a particular file I need to delete somewhere?
0
votes
1
answer
41
views
Move files based on size in Pentaho
Within Pentaho, how do I move files from a particular local directory that are 1 KB in size to another folder? Ideally, I'd like to move all 1 KB files at once and not go one by one (we're talking ...
- 719
0
votes
1
answer
159
views
Pentaho Unable to get database metadata from this database connection
We are using Pentaho 9.3.
Pentaho will work fine, but occasionally we will get an error message "Error connection to database [database_name]. Unable to get database metadata from this database ...
0
votes
0
answers
33
views
Get variable in a CpythonScripExecutor step in Pentaho
I’m trying of get a variable value in a CpythonScriptExecutor step in pentaho spoon but i don’t know how to do that.
I’ve tried with getVariable(“My_var”, “default_value”) , os.getenv(…) and ${My_var} ...
- 1
0
votes
0
answers
49
views
Pentaho Reporting Issues and Gradle
I am trying to build a project using Gradle, but I'm encountering compilation errors related to missing Pentaho Reporting Engine packages. I don't know if it is the gradle version or so, but they are ...
0
votes
0
answers
30
views
Pentaho: How to import csv from SharePoint
I am new to Pentaho tool, Can anyone please explain how to import a CSV file from SharePoint in Pentaho ETL tool.
Thanks in advance.
Krishna
0
votes
0
answers
67
views
Kettle10.2 cannot use the database repository
I have installed Kettle10.2, but I am unable to find the connection options for the database repository. May I ask if this feature was removed in version 10.2?
I compared it with version 9.4 and it ...
0
votes
0
answers
151
views
Java 21 and Pentaho Data Integration
Hitachi has the worst documentation so I figured I would ask here.
Has anyone used Java 21 with Pentaho and had any issues?
I haven't had any issues running it, but wanted to see if there is anything ...
1
vote
0
answers
31
views
Draw chart in .prpt file using Java API and pentaho
How can I draw a chart in .prpt format using Java API and pentaho?
I'm using pentaho files (.prpt) and Java API to create reports. Data is being sent using Angular and hql with .prpt and pdf files ...
0
votes
1
answer
125
views
Why doesn't pentaho capture SQL errors when using the execute row SQL script?
We are using the Execute Row SQL script node to execute large dynamic SQL scripts in SQL Server.
The code is metadata driven, so none of the below can be hard-coded. The SQL is compiled at run-time. ...
1
vote
0
answers
38
views
Pentaho HTTP Post error "Name may not be null"
I have some issues with a HTTP post step in Pentaho. If I preview it works, and does the post acuratly, however when I properly run the transformation I get this error (in the HTTP post step). The ...
-1
votes
1
answer
108
views
Pentaho Data Integration 9.3 - Postgres Incremental load
i m using Pentaho Data Integration for loading incremental data from Production Postgres to Staging Postgres DB.
For doing so i m getting max timestamp from staging DB and querying production DB for ...
- 5,634
1
vote
2
answers
132
views
Read csv and get table data and write as text file output
I have a csv file which has the below mentioned data of Table names in a sql server instance in ubuntu.
Tables
TableName1
TableName2
TableName3
.
.
.
I want to read this csv file and I want to get ...
- 23
0
votes
1
answer
70
views
I'm trying to add a header to the output file in pentaho but the column names from the actual data that I am writing are getting removed from file
I am trying to write some data into text file but before that I want to write about the type of the data being written to the file.
eg.
This is the data about City and country
City~Country
Mumbai~...
- 37
0
votes
0
answers
31
views
convert files from multiple csv files to multiple txt files in pentaho
I need to create a job that takes a folder in which only csv files are found but these have the name with the date for example 03-16-2024_shopping in this way x files I would like to take all the ...
0
votes
0
answers
483
views
Pentaho Data Integration (PDI) Jobs Failing After Upgrading to OpenJDK 11 on CentOS VM
I recently upgraded my Java version from 8 to 11 (openjdk 11.0.22 2024-01-16 LTS
) on a CentOS virtual machine where I run Pentaho Data Integration (PDI) jobs. According to documentation, PDI 9.3 ...
- 621
0
votes
1
answer
174
views
How to write a blob file to local filesystem using PDI?
I have a transformation where I read in a raw application/octet-stream into a stream field using a RESTClient step, which is working correctly. Now, I would like to write the (*.jpg) file to the ...
0
votes
1
answer
180
views
Slowly Changing Dimension Type 2
I am trying to create an SCD type 2 data warehouse with Pentaho. I don't actually know how to load surrogate_ids and other data simultaneously and properly. I'd be glad if someone helps.
I'm trying to ...
0
votes
0
answers
141
views
Amazon S3 multi part upload error using Pentaho 9.3
I am trying to upload multiple GZip files to Amazon S3 using Pentaho 9.3. I have also set the part size to maximum in the kettle property but am still facing the S3 multi-part error. Reference for ...
0
votes
1
answer
107
views
Get row number from stream to perform concat
Can we simply extract the row number from stream in Pentaho Spoon to perform a concat operation with it, for example?
Let's consider we have:
#
Country
RowNum
1
FR
null
2
BE
null
Here I want to ...
- 61
0
votes
0
answers
75
views
Troubleshooting 'No such file or directory' Error for Network Paths in Pentaho Server Job Execution
I'm facing an issue with a Pentaho Server job that executes a Python script (Automacao_latromi_relatoriobi_inbound_V4.py). The job fails with a "No such file or directory" error when ...
0
votes
0
answers
145
views
Pentaho Unable to access Remote Excel file
I am using Pentaho 8.2. In one of my transformation step, I am trying to read an Excel file from a remote shared path on another server. However, I am encountering the following error:
ERROR (version ...
- 270
-1
votes
1
answer
141
views
Pentaho: Multiple excel in folder to a excel [closed]
I've successfully input multiple Microsoft Excel files from a folder. How can I save all of them into one Excel file?
referensi input : https://stackoverflow.com/a/66865749/23392458
I want all Excel ...
- 1
0
votes
1
answer
161
views
Disable Pentaho Info Logs
When I kick off Pentaho to run the logs start off like this...
NFO: Lock acquired. Setting startlevel to 100
Jan 20, 2024 7:06:24 PM org.apache.karaf.main.Main$KarafLockCallback lockAcquired
INFO: ...
0
votes
1
answer
249
views
How to get parent directories from pentaho variable
In Pentaho the directory where the current job is stored in the variable:
${Internal.Job.Filename.Directory}
But how can I move backward to get the parent directories ?
I want to use it to set a ...
- 2,659