• Run this transformation in a clustered mode?

    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 ...
    Ricardo Carrera
    last modified by Ricardo Carrera
  • Communications link failure during commit() with MySQL

    I have problem with MySQL in PDI (Kettle). This error appears in process of reading information by Input Table. Even if all data is gived out of base successfully, this error appears and, probably, doesn't affect on t...
    Alex Shumskiy
    last modified by Alex Shumskiy
  • How to get data from REST API with pagination? example www.abc.com/data?page=1, ..... with number of pages we do not know???

    I have a rest API with pagination, I would like to get all data with automatically passing the page number into the URL www.abc.com/data?page=1 www.abc.com/data?page=2 .... www.abc.com/data?page=n   n = the ...
    William Nguyen
    last modified by William Nguyen
  • Job containing "Build Model" step works in Spoon but fails on Kitchen

    Hi, I am developing a PDI job that: executes a transformation that loads data into a PostgreSQL table builds a model based on the table output step of the transformation using auto modeler publishes the model to t...
    Stefano Piva
    created by Stefano Piva
  • I have the following problem when trying to connect to an Oracle database:

    I have the following problem when trying to connect to an Oracle database:   Error connecting to database [DWH] :org.pentaho.di.core.exception.KettleDatabaseException: Error occurred while trying to connect to ...
    Giovani Stefani
    last modified by Giovani Stefani
  • Database lookup and Database join are driving me crazy

    Hi, I have a transformation where I use a database lookup or database join step to look up a value from my database. The problem is: it does not find the record in my table! I am 100 % sure it is there and if I run t...
    B241Q6DO
    last modified by B241Q6DO
  • PDI 8.1 not starting

    Hello All, I have PDI 8.1 downloaded and installed on my computer (community edition and trial enterprise edition).  It worked perfectly yesterday, and today when I try to start it, the command prompt pops up an...
    Zachary Pappas
    last modified by Zachary Pappas
  • Can Pentaho read .pdf files as input ?

    Hi Team,   I have a requirement to read a .pdf file which we cant convert into .txt or any other format due to insufficient privileges. Can Pentaho read .pdf files ? if yes then how can you please suggest ?
    Nilesh Purohit
    last modified by Nilesh Purohit
  • How to pass through variables the log database connection in Kettle?

    Hi everyone, I would like to know if there is a proper way to pass the database connections variable so they can be used in the logging sections of both jobs and transformations.   Regards, Nicolas.
    Nicolas Soria
    last modified by Nicolas Soria
  • Appending new data to existing table based on date

    Hi, I am pretty new to Kettle so apologies if my question is too simple - I want to create an ETL process that will allow me to test what rows currently exist in the output table (Max date for example) and then them u...
    Alina Lot
    last modified by Alina Lot
  • Problems reading CSV file

    Hi, I'm working with PDI Version 7.1 and I'm trying to read a CSV file with the CSV File Input step, but I'm having an error that I can not handle. My CSV file is delimited by the character | (ASCCI Code 124) and at ...
    Luis Suarez
    last modified by Luis Suarez
  • PDI pentaho reporting output parameter issue

    Hi,     I m using pentaho Data integrator 8.1 and pentaho reporting output component inside a transformation. The report contains a simple integer parameter ${batchno} which is working fine with report desi...
    Narasimha Rao Ch
    last modified by Narasimha Rao Ch
  • AEL Error resolving artifact pentaho:pentaho-osgi-config:cfg:pentaho-kerberos:8.1.0.0-365

    Hi Guys,   I'm trying to use AEL (Pentaho 8.1.0) against a Hortonworks cluster HDP 2.6.3.   My HDP cluster were configured with Kerberos + Ranger, but as we are creating a PoC with Pentaho CE, we disabled ...
    Kleyson Rios
    last modified by Kleyson Rios
  • Getting out of memory error while processing a SQL through hive on spark .I am running transformation on spoon having JVM size of 4GB.

    Java.lang.OutOfMemoryException :Java heap space. Resultset is having only 150 rows.Sometime it is throwing error on select value step some times on write to log step.
    kuldeep singh
    last modified by kuldeep singh
  • REST API

    Hi I am currently Investigation the funtionalities of the PDI REST API. I am trying to schedule some Reports in Pentaho and I am struggling  with the Syntax of the json or XML I have to Hand over to the rest cal...
    Nicole Erbe
    last modified by Nicole Erbe
  • PDI pentaho reporting output error

    hello,     i am using pdi 8.1 and pentaho reporting output component. While trying to generate the report (pentaho report 7.1) getting the following error in the transformation.     2018/09/07 12...
    Narasimha Rao Ch
    last modified by Narasimha Rao Ch
  • Does Pentaho DI CE support MongoDB Atlas (which enforces SSL/ 3.6) ? if yes can provide some guide?

    Does Pentaho DI 8.1 CE support MongoDB atlas (which enforces SSL, db-version 3.6)? If yes, please provide some guidance.
    Malith Madhushanka
    last modified by Malith Madhushanka
  • MongoDB Atlas support

    Does Pentaho 8.1 Data Integration CE support MongoDB Atlas (enforces SSL connection)? any guidance is appreciated. ex - "mongodb+srv://<USER-NAME>:<PASSWORD>@mycluster-f7t34.mongodb.net/test?retryWrites=t...
    Malith Madhushanka
    last modified by Malith Madhushanka
  • Spoon Webservices

    Hello, I'm testing the pentaho 8.0 webservice, input data is a string and data output is an XML. when executing it, it gives an error. Web Services Lookup.0 - ERROR (version 8.0.0.0-28, build 8.0.0.0-28 from 2017-11-...
    Aslee Guirola
    last modified by Aslee Guirola
  • Unzip file issue in Pentaho-spoon

    I'm trying to unzip a file in a job, everything's OK until the filename inside the zip has some special characters like "á, é, í, ó, ú". When the filename inside the zip has those char...
    Roger Nieto
    last modified by Roger Nieto