Introduction

This page contains the index for the documentation on all the standard steps in Pentaho Data Integration version 3.2.

Input Access Input CSV Input De-serialize from file Excel Input (XLS, XLSX) including OpenOffice Workbooks (ODS) Fixed File Input Generate Rows Generate Random Value Get File Names Get Files Rows Count Get Sub-folder names Get System Info Get Data From XML Google Analytics Google Docs Input LDAP Input LDIF Input Mondrian Input Property Input RSS Input SalesForce Input Table Input Text File Input XBase Input	Output Access Output Delete Excel Output Insert / Update Property Output RSS Output SQL File Output Serialize to file Synchronize after merge Table Output Text File Output Update XML Output	Transform Add XML Add a checksum Add constants Add sequence Calculator Closure generator Number range Replace in String Row Normaliser Row De-normaliser Row flattener Select values Sort rows Split fields Split field to rows String cut Unique rows Unique rows by HashSet Value mapper XSL Transformation	Utility Clone row Delay row Execute a process If field value is null Mail Metadata structure Null if... Process files Write to log
Flow Abort Append streams Blocking step Detect empty stream Dummy (do nothing) Filter rows Identify last row in a stream Switch / Case	Scripting Execute SQL script Execute row SQL script Formula User Defined Java Expression Modified Java Script Value Regex Evaluation	Lookup Call DB Procedure Check if a column exists Database Join Database Lookup Dynamic SQL row File exists HTTP Post HTTP client Stream Lookup Table Exists Web services lookup	Joins Join rows (Cartesian product) Merge Join Merge rows (diff) Sorted Merge XML Join
Data Warehouse Combination lookup/update Dimension lookup/update	Validation Credit card validator Data validator Mail Validator XSD Validator	Statistics Analytic Query Group By Reservoir sampling Sample rows Univariate Statistics	Job Copy rows to result Get Variables Get files from result Get rows from result Set variables Set files in result
Mapping Mapping (sub-transformation) Mapping input\\ Mapping output	Experimental Greenplum Bulk Loader GZIP CSV Input MySQL Bulk Loader PostgreSQL Bulk Loader	Deprecated Aggregate rows XML Input Streaming XML Input	Bulk loading Infobright loader Oracle Bulk Loader [MonetDB bulk loader] LucidDB bulk loader

Page Operations

Browse Space

Pentaho Data Integration v3.2. Steps

Labels:

Introduction

Input

Output

Transform

Utility

Flow

Scripting

Lookup

Joins

Data Warehouse

Validation

Statistics

Job

Mapping

Experimental

Deprecated

Bulk loading

Child Pages (18)