Introduction

This page contains the index for the documentation on all the standard steps in Pentaho Data Integration.
We invite everyone to add more details, tips and samples to the step pages.

This page reflects the categories and steps from PDI version 3.1.
The steps page for version 3.2 is over here : Pentaho Data Integration v3.2. Steps

Input Access Input CSV Input De-serialize from file Excel Input Fixed File Input Generate Rows Generate Random Value Get File Names Get Files Row Count Get System Info Get Data From XML LDAP Input(UPDATE) LDIF Input Mondrian Input Property Input RSS Input SalesForce Input Streaming XML Input Table Input Text File Input XBase Input XML Input	Output Access Output Delete Excel Output Insert / Update Property Output SQL File Output Serialize to file Table Output Text File Output Update XML Output	Transform Abort Add XML Add a checksum Add constants Add sequence Analytic Query Append streams Blocking step Calculator Clone row Closure generator Data validator Delay row Dummy (do nothing) Filter rows Group By Metadata structure Null if... Row Normaliser Row De-normaliser Row flattener Select values Sort rows Split fields Split field to rows Switch / Case Unique rows Value mapper XSD Validator XSL Transformation
Lookup Call DB Procedure Check if a column exists Database Join Database Lookup File exists HTTP client Stream Lookup Table Exists Web services lookup	Joins Join rows (Cartesian product) Merge Join Merge rows (diff) Sorted Merge XML Join	Scripting Execute SQL script Modified Java Script Value Regex Evaluation Formula
Data Warehouse Combination lookup/update Dimension lookup/update	Mapping Mapping (sub-transformation) Mapping input\\ Mapping output	Job Copy rows to result Get Variables Get files from result Get rows from result Set variables Set files in result
Experimental Greenplum Bulk Loader (TODO) PostgreSQL Bulk Loader Get Subfolder names (TODO) Mail Validator Mail MonetDB bulk loader	Deprecated Aggregate rows	Bulk loading Oracle Bulk Loader(UPDATE)

Page Operations

Browse Space

Pentaho Data Integration Steps

Labels:

Introduction

Input

Output

Transform

Lookup

Joins

Scripting

Data Warehouse

Mapping

Job

Experimental

Deprecated

Bulk loading

Child Pages (102)