Search

Question

PDI:Carte "pass output to servlet" how can output UTF-8 data?

now it output question marks. Response headers no content-type I find out Carte charset trouble Pentaho remove preview Carte charset trouble Hi! Is there any way to make carte expose cyrillic symbols via json output? I've searched for solution several days and found none. Transformation I'm...

Question

In Pentaho version 9.2, repository section doesn't seem

In Pentaho version 9.2, repository section doesnt seem.Please,if there are have any solution,inform me.

Question

On the Pentaho Google Sheets Output plugin, I get cryptic error saying Read Timeout, which I later figured out was the result of google quota. Is there a way to do exception handling?

Ive used this from this plugin - https://github.com/jfmonteil/Pentaho-Google-Sheet-Plugin. For my dataset, I have ~ 56000 rows, and 12 columns of data. This, upon using the said plugin, errors out. Even with the 56K rows, it says it errored out and the transformation stops. However, the entire...

Question

i18n in report called from PDI

Hi, Im generating report through a Kettle Transformation (Pentaho reporting output component). Is there a way to trigger the appropriate i18n resource through a report input parameter? I think the question can also be: is there a way to configure the environment variables of a report (Im...

Question

Select current datetime from Database instead of PDI server time using Table Input step

Hi Pentaho Community users, I am using PDI community edition version 9.0. The table input step has a simple sql query pointed to postgres database connection and the statement is as shown below: select now() I expected that PDI will execute the query in the target database (which is running...

Question

How do you handle fixed text file with a multi line unevenely wrapped column?

Question

Pentaho DI - Java Platform SE binary is not responding

Hoping if anyone could help with such issue. I wanted to use pentaho, but that pentaho is not opening (spoon.bat) - its freezing after main UI is loaded - and I cannot do anything - connect to repo, tool just freezes and then crashes with mentioned in header error. intersting, that this happened...

Question

How to schedule the execution of a PDI job on Pentaho Server?

Hi, Ive a job that works correctly if launched from Pentaho PDI. How can I schedule this job on a Pentaho Server? Is there a tutorial on how to do this? Im using: Pentaho PDI 9.2 Pentaho Server CE 9.2 The server is on a Centos distribution. Thank you very much cld

Question

Configuring PDI transformation as report data source

Hello, is it possible to create report through Report Designer with a Pentaho Data Integration data source and in the File field provide the path to the PDI transformation using environment variables like $(Internal.Entry.Current.Directory)? Or is there any way to read the path or the...

Question

Table Input to a batch REST call

I need to save data by calling a REST API. On this REST API I can save data in batches, to gain performance. In one single call, I can save data from one thousand Table Input rows. What I need is to read a thousand rows from a table input, process it by concatenating each row to a JSON string...