Skip to main content
Pentaho Documentation

Job Entry Reference

Overview

Index for supported Pentaho Data Integration job entry documentation.

 This page contains the index supported Pentaho Data Integration job entry documentation.

A-F

Name Category Description
Abort job Utility Abort the job
Add filenames to result File management Add filenames to result
Amazon EMR Job Executor Big Data Execute MapReduce jobs in Amazon EMR 
Amazon Hive Job Executor Big Data Execute Hive jobs in Amazon EMR 
BulkLoad from Mysql into file Bulk loading Load from a mysql table into a file
BulkLoad into MSSQL Bulk loading Load data from a file into a MSSQL table
BulkLoad into Mysql Bulk loading Load data from a file into a Mysql table
Check Db connections Conditions Check if we can connect to one or several databases.
Check files locked Conditions Check if one or several files are locked by another process
Check if a folder is empty Conditions Check if a folder is empty
Check if connected to repository Repository Return true if we are connected to a repository
Check if XML file is well formed XML Check if one or several XML files is/are well formed
Check webservice availability Conditions Check if a webservice is available
Checks if files exist Conditions Checks if files exists
Columns exist in a table Conditions Check if one or several columns exist in a table on a specified connection
Compare folders File management compare two folders (or two files)
Convert file between Windows and Unix File management Convert file content between Windows and Unix. Converting to Unix will replace CRLF (Carriage Return and line Feed) by LF (Line Feed)
Copy Files File management Copy Files
Copy or Move result filenames File management Copy or Move result filenames (since version 5.0, this job entry has been renamed to Process result filenames and handles Delete as well) 
Create a folder File management Create a folder
Create file File management Create (an empty) file
Decrypt files with PGP File encryption Decrypt files encrypted with PGP (Pretty Good Privacy). This job entry need GnuPG to work properly.
Delete file File management Delete a file
Delete filenames from result File management Delete filenames from result
Delete files File management Delete files
Delete folders File management Delete specified folders. Attention : if a the folder contains files, PDI will delete them all!
Display Msgbox Info Utility Display a simple Message box Information
DTD Validator XML DTD Validator
Dummy General  Use the Dummy job entry to do nothing in a job.
Encrypt files with PGP File encryption Encrypt files with PGP (Pretty Good Privacy). This job entry need GnuPG to work properly.
Evaluate files metrics Conditions Evaluate files size or files count
Evaluate rows number in a table Conditions Evaluate the content of a table. You can also specify a SQL query.
Example plugin General This is an example test job entry for a plugin
Export repository to XML file Repository Export repository to XML file
File Compare File management Compare 2 files
File Exists Conditions Checks if a file exists
FTP Delete File transfer Delete files in a remote host

G-L

Name Category Description
Get a file with FTP File transfer Get files using FTP (File Transfer Protocol)
Get a file with FTPS File transfer Get a file with FTP secure
Get a file with SFTP File transfer Get files using Secure FTP (Secure File Transfer Protocol)
Get mails (POP3/IMAP) Mail Get mails (POP3/IMAP) server and save into a local folder
Hadoop Copy Files Big Data   
Hadoop job executor Big Data  Execute a map/reduce job contained in a jar file
HL7 MLLP Acknowledge Utility   
HL7 MLLP Input Utility   
HTTP File management Gets or uploads a file using HTTP (HyperText Transfer Protocol)
JavaScript Scripting Evaluates the result of the execution of a previous job entry
Job General Executes a job

M-R

Name Category Description
Mail Mail Sends an e-Mail
Mail validator Mail Check the validity of an email address ( SNMP trap to a target host
Move Files File management Move Files
MS Access Bulk Load Deprecated Load data into a Microsoft Access table from CSV file format. ATTENTION, at the moment only the insertion is available! If target table exists, a new one will be created and data inserted.
Oozie Job Executor Big Data   
Palo Cube Create Palo  Creates a cube on a Palo server 
Palo Cube Delete Palo  Deletes a cube on a Palo server 
Pentaho MapReduce Big Data Execute Transformation Based MapReduce Jobs in Hadoop 
Pig Script Executor Big Data Execute a Pig script on a Hadoop cluster
Ping a host Utility Ping a host
Put a file with FTP File transfer Put a file with FTP
Process result filenames File management Copy, Move or Delete result filenames
Put a file with SFTP File transfer Put files using SFTP (Secure File Transfer Protocol)

S-Z

Name Category Description
Send information using Syslog Utility Sends information to another server using the Syslog protocol. 
Send Nagios passive check Utility  Send Nagios passive checks 
Send SNMP trap Utility Send SNMP trap to a target host
Set variables General Set one or several variables.
Shell Scripting Executes a shell script
Simple evaluation Conditions Evaluate one field or variable
SQL Scripting Executes SQL on a certain database connection
Sqoop Export Big Data Export data from the Hadoop Distributed File System (HDFS) into a relational database (RDBMS) using Apache Sqoop 
Sqoop Import Big Data Import data from a relational database (RDBMS) into the Hadoop Distributed File System (HDFS) using Apache Sqoop 
Start General  Start is where the job starts to execute and is required before the job can be executed.
Start a PDI Cluster on YARN Big Data Starts a PDI Cluster on YARN
Stop a PDI Cluster on YARN Big Data Stops a PDI Cluster on YARN
Success General Success
Table exists Conditions Checks if a table exists on a database connection
Talend Job Execution Utility This job entry executes an exported Talend Job
Transformation General Executes a transformation
Truncate tables Utility Truncate one or several tables.
Unzip file File management Unzip file in a targer folder
Upload files to FTPS File transfer Upload files to a FTP secure
Verify file signature with PGP File encryption Verify file signature with PGP (Pretty Good Privacy). This job entry need GnuPG to work properly.
Wait for Conditions Wait for a delay
Wait for file File management Wait for a file
Wait for SQL Utility Scan a database and success when a specified condition on returned rows is true.
Write to file File management Write text content to file.
Write To Log Utility Write message to log
XSD Validator XML XSD Validator
XSL Transformation XML Make an XSL Transformation
Zip file File management Zip files from a directory and process files

Overview

Quisque mattis rutrum ligula et pellentesque. Pellentesque massa enim, pulvinar quis quam quis, aliquet dapibus augue. Aliquam feugiat suscipit turpis, nec ultrices dolor adipiscing ut.

 This page contains the index for the documentation on all the standard job entries in Pentaho Data Integration.

A-F

Name Category Description
Abort job Utility Abort the job
Add filenames to result File management Add filenames to result
Amazon EMR Job Executor Big Data Execute MapReduce jobs in Amazon EMR 
Amazon Hive Job Executor Big Data Execute Hive jobs in Amazon EMR 
BulkLoad from Mysql into file Bulk loading Load from a mysql table into a file
BulkLoad into MSSQL Bulk loading Load data from a file into a MSSQL table
BulkLoad into Mysql Bulk loading Load data from a file into a Mysql table
Check Db connections Conditions Check if we can connect to one or several databases.
Check files locked Conditions Check if one or several files are locked by another process
Check if a folder is empty Conditions Check if a folder is empty
Check if connected to repository Repository Return true if we are connected to a repository
Check if XML file is well formed XML Check if one or several XML files is/are well formed
Check webservice availability Conditions Check if a webservice is available
Checks if files exist Conditions Checks if files exists
Columns exist in a table Conditions Check if one or several columns exist in a table on a specified connection
Compare folders File management compare two folders (or two files)
Convert file between Windows and Unix File management Convert file content between Windows and Unix. Converting to Unix will replace CRLF (Carriage Return and line Feed) by LF (Line Feed)
Copy Files File management Copy Files
Copy or Move result filenames File management Copy or Move result filenames (since version 5.0, this job entry has been renamed to Process result filenames and handles Delete as well) 
Create a folder File management Create a folder
Create file File management Create (an empty) file
Decrypt files with PGP File encryption Decrypt files encrypted with PGP (Pretty Good Privacy). This job entry need GnuPG to work properly.
Delete file File management Delete a file
Delete filenames from result File management Delete filenames from result
Delete files File management Delete files
Delete folders File management Delete specified folders. Attention : if a the folder contains files, PDI will delete them all!
Display Msgbox Info Utility Display a simple Message box Information
DTD Validator XML DTD Validator
Dummy General  Use the Dummy job entry to do nothing in a job.
Encrypt files with PGP File encryption Encrypt files with PGP (Pretty Good Privacy). This job entry need GnuPG to work properly.
Evaluate files metrics Conditions Evaluate files size or files count
Evaluate rows number in a table Conditions Evaluate the content of a table. You can also specify a SQL query.
Example plugin General This is an example test job entry for a plugin
Export repository to XML file Repository Export repository to XML file
File Compare File management Compare 2 files
File Exists Conditions Checks if a file exists
FTP Delete File transfer Delete files in a remote host

G-L

Name Category Description
Get a file with FTP File transfer Get files using FTP (File Transfer Protocol)
Get a file with FTPS File transfer Get a file with FTP secure
Get a file with SFTP File transfer Get files using Secure FTP (Secure File Transfer Protocol)
Get mails (POP3/IMAP) Mail Get mails (POP3/IMAP) server and save into a local folder
Hadoop Copy Files Big Data   
Hadoop job executor Big Data  Execute a map/reduce job contained in a jar file
HL7 MLLP Acknowledge Utility   
HL7 MLLP Input Utility   
HTTP File management Gets or uploads a file using HTTP (HyperText Transfer Protocol)
JavaScript Scripting Evaluates the result of the execution of a previous job entry
Job General Executes a job

M-R

Name Category Description
Mail Mail Sends an e-Mail
Mail validator Mail Check the validity of an email address ( SNMP trap to a target host
Move Files File management Move Files
MS Access Bulk Load Bulk loading Load data into a Microsoft Access table from CSV file format. ATTENTION, at the moment only the insertion is available! If target table exists, a new one will be created and data inserted.
Oozie Job Executor Big Data   
Palo Cube Create Palo  Creates a cube on a Palo server 
Palo Cube Delete Palo  Deletes a cube on a Palo server 
Pentaho MapReduce Big Data Execute Transformation Based MapReduce Jobs in Hadoop 
Pig Script Executor Big Data Execute a Pig script on a Hadoop cluster
Ping a host Utility Ping a host
Put a file with FTP File transfer Put a file with FTP
Process result filenames File management Copy, Move or Delete result filenames
Put a file with SFTP File transfer Put files using SFTP (Secure File Transfer Protocol)

S-Z

Name Category Description
Send information using Syslog Utility Sends information to another server using the Syslog protocol. 
Send Nagios passive check Utility  Send Nagios passive checks 
Send SNMP trap Utility Send SNMP trap to a target host
Set variables General Set one or several variables.
Shell Scripting Executes a shell script
Simple evaluation Conditions Evaluate one field or variable
SQL Scripting Executes SQL on a certain database connection
Sqoop Export Big Data Export data from the Hadoop Distributed File System (HDFS) into a relational database (RDBMS) using Apache Sqoop 
Sqoop Import Big Data Import data from a relational database (RDBMS) into the Hadoop Distributed File System (HDFS) using Apache Sqoop 
SSH2 Get Deprecated Get files using SSH2 (Deprecated in 5.0 in favor of the SFTP job entry) 
SSH2 Put Deprecated Put files in a remote host using SSH2 (Deprecated in 5.0 in favor of the SFTP job entry)
Start General  Start is where the job starts to execute and is required before the job can be executed.
Start a PDI Cluster on YARN Big Data Starts a PDI Cluster on YARN
Stop a PDI Cluster on YARN Big Data Stops a PDI Cluster on YARN
Success General Success
Table exists Conditions Checks if a table exists on a database connection
Talend Job Execution Utility This job entry executes an exported Talend Job
Transformation General Executes a transformation
Truncate tables Utility Truncate one or several tables.
Unzip file File management Unzip file in a targer folder
Upload files to FTPS File transfer Upload files to a FTP secure
Verify file signature with PGP File encryption Verify file signature with PGP (Pretty Good Privacy). This job entry need GnuPG to work properly.
Wait for Conditions Wait for a delay
Wait for file File management Wait for a file
Wait for SQL Utility Scan a database and success when a specified condition on returned rows is true.
Write to file File management Write text content to file.
Write To Log Utility Write message to log
XSD Validator XML XSD Validator
XSL Transformation XML Make an XSL Transformation
Zip file File management Zip files from a directory and process files

Replacements for Deprecated or Removed Job Entries

The following table lists deprecated or removed entries and their suggested replacements.

Removed or Deprecated Entry Replacement Entry
MS Access Bulk Load Entry Microsoft Access Output Step
SSH2 Get Entry Get a file with FTPS Entry
SSH2 Put Entry Upload files to FTPS Entry