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) | 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 |
---|---|---|
Sends an e-Mail | ||
Mail validator | 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) | 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 |
---|---|---|
Sends an e-Mail | ||
Mail validator | 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 |