Top "Kettle" questions

Kettle is a code name for Pentaho Data Integration Community Edition tool.

Pentaho Data Integration commercial costs + azure hosting

I did some Google searches but could not find any clear answer. How much does PDI/kettle costs for commercial …

pentaho kettle pdi
How do I concatenate string in Pentaho spoon?

I am a newbie to Pentaho (installed today). I was able to do basic transformation in Spoon. Now I need …

business-intelligence pentaho kettle
How to Pass parameter in table input?

I have one job with two transformation in it. Transformation get list of data which is pass to another transformation. …

pentaho kettle pdi
Maven Dependency for PDI(Pentaho Kettle) Jar files

I have written Java code to execute my transformation and Jobs and I have manually added all the Jar files …

maven pentaho kettle
Pentaho Spoon - Output to multiple files based on field content

I have been attempting splitting the results of a pentaho transform into multiple files based on the value of a …

pentaho kettle
Pass DB Connection parameters to a Kettle a.k.a PDI table Input step dynamically from Excel

I have a requirement such that whenever i run my Kettle job, the database connection parameters must be taken dynamically …

excel parameters pentaho kettle
Replace null value with NA using Pentaho Kettle

I have an input csv file with one column field value as empty. I want to replace that field value …

pentaho kettle data-integration pentaho-spoon
Remove special characters using Pentaho - Replace in String

I wanted to remove the special characters like ! @ # $ % ^ * _ = + | \ } { [ ] : ; < > ? / in a string field. I used the "Replace in String" …

regex pentaho kettle pentaho-spoon pdi
Kettle '?' not working Table Input Step

I want to get all the table names from the database and then get all the rows from the tables. …

pentaho kettle
Export data into different sheets in an excel spreadsheet using Pentaho Kettle

I want to export data from database tables into different sheets of an excel spreadsheet. For example, employee data from …

spreadsheet export-to-excel pentaho kettle