User: Compatibility of Job Entries - HiromuHota/pentaho-kettle GitHub Wiki

Standard job entries

The list of standard job entries here is the same as the one in here.

Name Category ID Executable Editable Comments
Abort job Utility ABORT Y Y
Add filenames to result File management ADD_RESULT_FILENAMES
Amazon EMR Job Executor Big Data EMRJobExecutorPlugin
Amazon Hive Job Executor Big Data HiveJobExecutorPlugin
BulkLoad from Mysql into file Bulk loading MYSQL_BULK_FILE
BulkLoad into MSSQL Bulk loading MSSQL_BULK_LOAD
BulkLoad into Mysql Bulk loading MYSQL_BULK_LOAD
Check Db connections Conditions CHECK_DB_CONNECTIONS
Check files locked Conditions CHECK_FILES_LOCKED
Check if a folder is empty Conditions FOLDER_IS_EMPTY Y Y
Check if connected to repository Repository CONNECTED_TO_REPOSITORY Y Y
Check if XML file is well formed XML XML_WELL_FORMED
Check webservice availability Conditions WEBSERVICE_AVAILABLE Y Y
Checks if files exist Conditions FILES_EXIST Y Y
Columns exist in a table Conditions COLUMNS_EXIST
Compare folders File management FOLDERS_COMPARE Y Y
Convert file between Windows and Unix File management DOS_UNIX_CONVERTER
Copy Files File management COPY_FILES Y Y
Copy or Move result filenames File management COPY_MOVE_RESULT_FILENAMES
Create a folder File management CREATE_FOLDER Y Y
Create file File management CREATE_FILE Y Y
Decrypt files with PGP File encryption PGP_DECRYPT_FILES
Delete file File management DELETE_FILE Y Y
Delete filenames from result File management DELETE_RESULT_FILENAMES
Delete files File management DELETE_FILES Y Y
Delete folders File management DELETE_FOLDERS Y Y
Display Msgbox Info Utility MSGBOX_INFO
DTD Validator XML DTD_VALIDATOR
Dummy General DUMMY (internal: SPECIAL) Y N/A
Encrypt files with PGP File encryption PGP_ENCRYPT_FILES
Evaluate files metrics Conditions EVAL_FILES_METRICS
Evaluate rows number in a table Conditions EVAL_TABLE_CONTENT
Example plugin General DummyJob
Export repository to XML file Repository EXPORT_REPOSITORY
File Compare File management FILE_COMPARE Y Y
File Exists Conditions FILE_EXISTS Y Y
FTP Delete File transfer FTP_DELETE
Get a file with FTP File transfer FTP
Get a file with FTPS File transfer FTPS_GET
Get a file with SFTP File transfer SFTP
Get mails (POP3/IMAP) Mail GET_POP
Hadoop Copy Files Big Data Y Y *1
Hadoop job executor Big Data HadoopJobExecutorPlugin
HL7 MLLP Acknowledge Utility
HL7 MLLP Input Utility
HTTP File management HTTP
JavaScript Scripting EVAL Y Y
Job General JOB Y Y
Mail Mail MAIL
Mail validator Mail JobCategory.Category.Mail_VALIDATOR
Move Files File management MOVE_FILES Y Y
MS Access Bulk Load Bulk loading MS_ACCESS_BULK_LOAD
Oozie Job Executor Big Data
Palo Cube Create Palo PALO_CUBE_CREATE
Palo Cube Delete Palo PALO_CUBE_DELETE
Pentaho MapReduce Big Data HadoopTransJobExecutorPlugin Y Y *1
Pig Script Executor Big Data HadoopPigScriptExecutorPlugin
Ping a host Utility PING
Put a file with FTP File transfer FTP_PUT
Process result filenames File management COPY_MOVE_RESULT_FILENAMES
Put a file with SFTP File transfer SFTPPUT
Send information using Syslog Utility SYSLOG
Send Nagios passive check Utility SEND_NAGIOS_PASSIVE_CHECK
Send SNMP trap Utility SNMP_TRAP
Set variables General SET_VARIABLES
Shell Scripting SHELL Y Y
Simple evaluation Conditions SIMPLE_EVAL
SQL Scripting SQL Y Y
Sqoop Export Big Data SqoopExport
Sqoop Import Big Data SqoopImport
Start General START (internal: SPECIAL) Y Y
Start a PDI Cluster on YARN Big Data StartYarnKettleCluster
Stop a PDI Cluster on YARN Big Data StopYarnKettleCluster
Success General SUCCESS Y Y
Table exists Conditions TABLE_EXISTS Y Y
Talend Job Execution Utility TALEND_JOB_EXEC
Telnet a file File transfer TELNET
Transformation General TRANS Y Y
Truncate tables Utility TRUNCATE_TABLES
Unzip file File management UNZIP
Upload files to FTPS File transfer FTPS_PUT
Verify file signature with PGP File encryption PGP_VERIFY_FILES
Wait for Conditions DELAY Y Y
Wait for file File management WAIT_FOR_FILE Y Y
Wait for SQL Utility WAIT_FOR_SQL
Write to file File management WRITE_TO_FILE Y Y
Write To Log Utility WRITE_TO_LOG Y Y
XSD Validator XML XSD_VALIDATOR
XSL Transformation XML XSLT
Zip file File management ZIP_FILE

*1: Tested with a locally deployed Cloudera quickstart VM (5.8)