447 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
1
vote
0
answers
49
views
Pentaho PDI 9.3 Can't connect after upgrade aws aurora mysql
After updating the database to a new version of Aurora MySQL on AWS, one of the steps no longer executes, and the log displays the following message:
Connection failed. Verify all connection ...
0
votes
0
answers
71
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
1
answer
6k
views
How to download previous versions of pentaho-data-integration CE(kettle)? [closed]
Below is the official download address for the open source community version:
https://pentaho.com/pentaho-developer-edition/
But I found it only provide the lastest version, and can not choose the ...
1
vote
1
answer
220
views
APACHE HOP - S3 File Plugin - HopException: Missing transform plugin
We are currently migrating our PDI to Apache Hop, and we are encountering errors in jobs where the S3 File plugin was added.
The error message is: "HopException: Missing transform plugin for 'S3 ...
0
votes
0
answers
416
views
Unable to save application/octet-stream (image file) to file using Java
I am using a "User-Modified Java Class" step in Pentaho Data Integration (PDI) to take an octet-stream returned via Rest API and save it to disk. I have a working example that assumes the ...
0
votes
1
answer
175
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 ...
1
vote
1
answer
179
views
Pentaho PDI || Windows Current User [closed]
PDI Version: 9.3
Environment: Windows Server
I'm trying to retrieve the username of the current user executing the transformation, with the aim of creating dynamic file paths based on this user ...
0
votes
1
answer
50
views
Transform XML with meta columns to csv in PDI
I have the below XML structure as input (number of columns/fields and rows can change based on query)
<?xml version="1.0" encoding="UTF-8"?>
<response>
<results&...
-1
votes
1
answer
151
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 ...
0
votes
1
answer
306
views
Issue with Channel Log Tables in Pentaho Data Integration V7: Works in Manual Execution but Not in Nightly Batch
In Pentaho Data Integration (V7), we have activated Kettle's own log tables to generate an error reporting system. So far, we have activated the Job, Transformation, and Channel log tables:
In the ...
0
votes
1
answer
139
views
How to loop through date variables in PDI?
So I have a job where first transformation step is "declaring date variables"
and I need to use 2 date variables as a range to create a loop between date_from and today ( 7 days range )
so ...
0
votes
1
answer
284
views
How to delete rows which were deleted in source table (Pentaho data integration)
I need to do an transformation which searches for id's coming from 2 different tables, and deletes from table 2 where the id of table two is not in table 1 (I'm using Pentaho)
That is harder than I ...
user avatar
user21051730
0
votes
1
answer
73
views
Connection between pentaho and mysql is reset
Whenever I'm in the middle of a "big" transformation, at some (random) moment the connection between Pentaho and MySQL is reset and I need to start all over again.
Is there any way to ...
-1
votes
1
answer
144
views
How to extract ObjectId to timestamp using mongodb function gettimestamp() in Pentaho Data Integrator
I'm trying to modify my ETL flow on Pentaho, which is mongodb to oracle. I'd like to change it to incremental flow so I need a create date.
In mongodb there is a column named _id which has ObjectId ...
0
votes
1
answer
739
views
Aborting job in pentaho without error message in log
A bit of context. We have a parent job, which calls a transformation which eventually retrieves and processes an XML file from a service, and then determines if there is a "next link" in the ...