Top "Kettle" questions

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

Pentaho: How to dynamically add Field (= Column) to OutputRow?

I would like to dynamically add fields (or a new columns) to the resulting output row in Kettle. After spending …

pentaho kettle
Use JSON Input step to process uneven data

I'm trying to process the following with an JSON Input step: {"address":[ {"AddressId":"1_1","Street":"A Street"}, {"AddressId":"1_101","Street":"Another Street"}, {"…

json pentaho kettle data-integration
Pentaho Kettle: how to pass variable from transformation to another transformation inside job

I have two transformations in the job. In the first trasnformation - I get details about the file. Now I …

pentaho kettle spoon
Changing a field from String to Int in Pentaho Data Integration

I am taking JSON information from our online API and producing it in a table with DI. I have 4 fields …

pentaho kettle data-integration
pentaho kettle : get row count from stream

I would like to get the total record count from the get rows from result output and then pass it …

pentaho etl kettle data-integration
Not able to run spoon.bat or any other batch file in Pentaho Data Integration (Kettle)

Tried pdi-ce-4.1.0-stable and pdi-ce-4.2.0-stable My Machine - Windows 7 64 bit When I run Spoon.bat cmd line window appears …

java pentaho etl kettle
How to do loop in pentaho for getting file names?

I have 100 000 files. I want to get the name of those file names and have to put in database, I …

pentaho kettle
Using Pentaho Kettle, how do I load multiple tables from a single table while keeping referential integrity?

Need to load data from a single file with a 100,000+ records into multiple tables on MySQL maintaining the relationships defined …

mysql etl pentaho kettle
Pentaho data integration: jdbc connection to MS SQL Server not working

With the community edition of Pentaho Data Integration - Kettle 5.0.1 (http://community.pentaho.com/projects/data-integration/) I could connect to …

jdbc pentaho kettle mssql-jdbc
Send Email with pentaho PDI

I want to sent an email using PDI. I created an job and added the 'Mail' element. There are my …

email pentaho kettle data-integration