3,851 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
-1
votes
1
answer
69
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
194
views
Pentaho CE 10.2 error browsing project repository - Cannot invoke org.pentaho.di.repository.RepositoryDirectoryInterface.getName()
I am experiencing the following problem.
I have Pentaho CE 10.2.0.0-222 with JDK 17.0.10
I have created a local repository
When I select "Open file" and browse the Pentaho repository tree, ...
0
votes
1
answer
42
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 ...
0
votes
0
answers
24
views
Can I migrate DTSX packages to Pentaho?
We have lot of DTSX packages. We need to migrate to Pentaho. Is there a way I can migrate/upgrade to Pentaho package OR Do I need to rewrite/rebuild everything in Pentaho?
I am trying to rewrite and I ...
0
votes
1
answer
171
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
75
views
Snowflake Service Account can't connect with Task Scheduler using Pentaho Job
I have a service account user set up in Snowflake. I have an ETL process set up in Pentaho that is using this service account to connect to Snowflake. I am connecting to Snowflake from Pentaho using a ...
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
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
56
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 ...
-1
votes
1
answer
72
views
Pentaho Kettle Database Join Alias problem
I am using kettle version 9.4 and migrating some jobs from 5.0,
i have an issue with step Database Join, in which i write a simple query that retrieves a column as alias, example:
select u.user_id as ...
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
108
views
Pentaho - Trim Spaces Dynamically
Bit of a pentaho rookie so let me know if this does not make sense / is not possible:
I am trying to export the contents of a table from my database to a .csv where the columns can change overtime.
...
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
0
answers
44
views
dynamic variable in Pentaho
Suppose, I have set multiple variables in pentaho with values like following picture:
I have set it in global variable like : $YYYYMMDD:DD-1, $YYYYMM00:DD-1,...
Now, I have a table named 'xyz' with ...
1
vote
0
answers
35
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 ...