Skip to content

User: Compatibility of Job Entries

Hiromu Hota edited this page Jan 25, 2018 · 1 revision

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)