• Sourcefire VJDBC driver as Datasource

    I am trying to use a VJDBC (com.sourcefire.vjdbc.VirtualDriver) supplied by vendor CISCO to access an equipment's database. The driver set up is explained in https://www.cisco.com/c/en/us/td/docs/security/fi...
    Gerardo Sevilla
    last modified by Gerardo Sevilla
  • Rest Client Authorization Headers with DELETE HTTP Method

    Good day. I'm working on Pentaho 7.1 and i'm using a rest client to perform activities through a specific URL. Authentication parameters such as Username and Password are properly set, in fact when i'm using HTTP Me...
    Mauro Matteo
    created by Mauro Matteo
  • PDI DI-FRAMEWORK - missing lines_read, etc all 0

    I have been exploring the best practice DI-FRAMEWORK (https://support.pentaho.com/hc/article_attachments/360014793351/PDI%20Project%20Setup%20and%20Lifecycle%20Management.pdf ) and got it running. However, w...
    Ramon Ankersmit
    last modified by Ramon Ankersmit
  • We're using Pentaho 6.2.  Errors are reported in the logging tab on Spoon.  Where is this log written to on disk?

    We're using Pentaho 6.2.  Errors are reported in the logging tab on Spoon.  Where is this log written to on disk?
    E Ebert
    last modified by E Ebert
  • Why step insert/update in spoon is so slownly?

    Hi,   I´ve to use the step insert/update in several transformations made with Pentaho Data Integration. I need to updatad tables with more then 2 millions of registers. I´ve noticed that this step is...
    Blanca Santos
    created by Blanca Santos
  • Pentaho PDI 8 libwebkit error

    When I run spoon on Fedora 27 I get following error:   WARNING:  no libwebkitgtk-1.0 detected, some features will be unavailable     Consider installing the package with apt-get or yum. ...
    Uwe Geercken
    last modified by Uwe Geercken
  • Automate sequences for every day

    Program a transformation that takes place every day without me having to activate it or do anything.   I'm creating different files through a database query but I want everything to be done automatically.  ...
    Juan Rodriguez
    last modified by Juan Rodriguez
  • Pentaho kettle convert date to unix

    I'm trying to pacha a string format dated "2019-05-14 13:30:00" to a UNIX format. In javascript I got it but in the javascript kettle module I am not able to return the numeric value 1557833442 the line...
    Manuel b munoz
    last modified by Manuel b munoz
  • Pentaho Community edition vs EE

    Hi All,   I wanted to know comparison between Pentaho Community edition and Enterprise edition? How can we get support for community edition from Pentaho team?
    Bharti Das
    last modified by Bharti Das
  • Pentaho 5.x Support

    Hi All, We are using Pentaho 5.x. May I know how to get support for this product in case of any issues? What is the process to get support as we know that this is CE version and no longer supported. Can we get help...
    Bharti Das
    last modified by Bharti Das
  • Loading a fact table from operational database

    Hello there, I know there is a lot of stuff about loading a fact table here but I don't really find answers that fit my needs. I have created a data warehouse on PostgreSQL with dimension tables already populated and ...
    Victorien DELANGUE
    last modified by Victorien DELANGUE
  • Data Explorer not available in Spoon?

    What steps or config are required to enable Data Explorer in PDI / Spoon? i.e., to inspect data. I'm running PDI 8.2.
    last modified by C324K41S
  • Failure to find org.apache.xbean:xbean:jar:2.5 in https://nexus.pentaho.org/content/groups/omni/

    Hi, I have a problem with using the FastJsonInput Step, I got the following error , any clues plz ? : [ERROR] Failed to execute goal on project FastJsonInput: Could not resolve dependencies for project com.trail2...
    Safouan ES-SEBBAR
    last modified by Safouan ES-SEBBAR
  • Streaming data from 2 diff data structures

    Marketplace has an add-in called 'PDI Stream Schema Merge' which "Merges the schema among multiple streams. Leaves fields blank where they don't exist in the source schema."   I have tested this with a simple 2 ...
    Rene Desaulniers
    last modified by Rene Desaulniers
  • Kafka consumer  java.lang.OutOfMemoryError: GC overhead limit exceeded

    We are trying for to run a Kafka consumer transformation in Pentaho Server 8.1. The transformation subscribes to a single topic that sends  500 messages per second. But after running a few hours (18 hours), the t...
    last modified by RAKOTONDRASOA Andry
  • Selecting rows from a csv file based on values in another csv file

    Hi all,   I have two CSV files 1. A big list of social media posts which contain the email ID of the poster, and other data 2. A list of unique people with name, email etc   What I would like to do is se...
    Matthew Hardman
    created by Matthew Hardman
  • Need clarification on Pan and Kitchen

    Hi Team, I am able to run transformation job using AEL (Spark Engine) in PDI client. So my question is, How to run Pan and Kitchen using AEL (Spark Engine).?
    girish athanikar
    last modified by girish athanikar
  • Error (Access Denied)

    Hey everyone. I am getting an error in a job I set up a few months ago and I can't seem to solve it. Here is the video (it's attached to the post) for more information if that is more helpful for you; basically, the p...
    Nathan Mahler
    created by Nathan Mahler
  • Kafka Consumer semantic in PDI 8.1

    Hi all I'm interested in setting up different semantics when retrieving data from Kafka with PDI: at most once, at least once, exactly once. I read [PDI-17272] Implement explicit commit in Kafka Consumer - Pentaho Pl...
    Virgilio Pierini
    last modified by Virgilio Pierini
  • Spark AEL Engine

    Hi Team,   I need some clarification regarding spark AEL engine which I am using to execute .ktr(transformation) through Web-Spoon.   Basically only a .ktr(transformation) can be executed through spark. I ...