Skip navigation
Log in to follow, share, and participate in this community.

Recent Activity

Himanshu Dixit
Hi Folks,   I am new to Kettle. I have question regarding 'Join Rows (Cartesian Product)' step.   I am using 2 BigQuery tables as input and cross joining them with 3 conditions based on date fields. It does include operators like '>=' and '<' in the join condition. Count in first BigQuery table is around 5.5k and other BigQuery table has 700k… (Show more)
in Data Integration
Fabrizio Agosti
Hi, I'm using Pentaho Data Integration version 6.1.   I tring to use "Email messages input" for read email message from Gmail. The test of Connection configuration is Ok. The test of Input folder is ok,  but when execute the transformation I receive this error:   2018/04/20 07:31:54 - Spoon - Spoon 2018/04/20 07:50:00 -… (Show more)
in Data Integration
B262C6VU
In 6.x or 7.x is there a maximum number of steps that you can have in a single Kettle transformation and do any of the transformation settings affect this maximum? I have noticed that sometimes just adding one more step to some transforms cause it to become unstable and/or not start promptly and/or run properly.   (and yes I usually break up my… (Show more)
in Data Integration
B932F9CY
Hello everyone, I'm convinced this situation already happened to some of you, so I'm here to request your help. I'm trying to access some of Google's API and the call must be authenticated with an OAuth token which I get in exchange for my private key. I have the private key in both JSON and P12 files. I'm not a Java developer and now I'm unsure… (Show more)
in Data Integration
Joao Ciocca
So, I even found a couple JIRA reports about this, but no aparent solution. Since we started using the Pentaho Server repository, using Spoon became a patience workout. Everything is sluggish, even moving steps around. I have no idea on how/where to diagnose what's causing it. Any tips, at all, are welcome.
in Data Integration
Rob Burgess
How do you return a ResultSet from a SQL Server stored procedure with multiple parameters?   I understand you can use the Table Input step but I am unsure of the syntax to execute the stored procedure with more than 1 parameter.
in Data Integration
Ricardo Carrera
Hi In PDI 8, where do I find the "Run this transformation in a clustered mode?" option?   In PDI 6, the option is in the advanced tab of the transformation job entry, but in PDI 8 is not. I need this option to execute clustered transformations via job and command line.   Is a bug? Or is there another way to execute a clustered ETL on PDI 8?  … (Show more)
in Data Integration
Kamil Nesetril
I want to let users store input files (csv, Excel) the Pentaho repository and I want to use it by PDI. I know that Pentaho repository is not a file system (but can be sync with it by Pentaho Repository Synchronizer).
in Data Integration
Luca Domenella
hi guys, recently i installed on our test environment the new version of PDI from 7 to 8. It runs on Centos 7.4 server with Oracle Java 1.8.0_162 When we run spoon.sh we get those errors: 15:53:01,990 INFO  [KarafBoot] Checking to see if org.pentaho.clean.karaf.cache is enabled 15:53:02,067 INFO  [KarafInstance]… (Show more)
in Data Integration
Load more items