# PDI job entries Entries extend and expand the functionality of Pentaho Data Integration (PDI) entries. You can use the following steps in PDI. ## Entries: A - F | Name | Category | Description | | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------------ | --------------------------------------------------------------------------------------------------------------------------------------------- | | [Abort job](https://pentaho-community.atlassian.net/wiki/spaces/EAI/pages/371558484/Abort+Job) | Utility | Abort the job. | | [Add filenames to result](https://pentaho-community.atlassian.net/wiki/spaces/EAI/pages/372703461/Add+filenames+to+result) | File management | Add filenames to result. | | [Amazon EMR Job Executor](https://docs.pentaho.com/pdia-data-integration/9.3-data-integration/pdi-job-entries-reference-overview/amazon-emr-job-executor) | Big Data | Execute MapReduce jobs in Amazon EMR. | | [Amazon Hive Job Executor](https://docs.pentaho.com/pdia-data-integration/9.3-data-integration/pdi-job-entries-reference-overview/amazon-hive-job-executor) | Big Data | Execute Hive jobs in Amazon EMR. | | [Bulk load from MySQL into file](https://pentaho-community.atlassian.net/wiki/spaces/EAI/pages/388311823/BulkLoad+from+Mysql+to+file) | Bulk loading | Load from a MySQL table into a file. | | [Bulk load into Amazon Redshift](https://docs.pentaho.com/pdia-data-integration/9.3-data-integration/pdi-job-entries-reference-overview/bulk-load-into-amazon-redshift) | Bulk loading | Bulk loads files located in S3 buckets into an Amazon Redshift database. | | [Bulk load into Azure SQL DB](https://docs.pentaho.com/pdia-data-integration/9.3-data-integration/pdi-job-entries-reference-overview/bulk-load-into-azure-sql-db) | Bulk loading | Load data into an Azure SQL database from Azure Data Lake Storage. | | [Bulk load into MSSQL](https://pentaho-community.atlassian.net/wiki/spaces/EAI/pages/388311826/BulkLoad+into+MSSQL) | Bulk loading | Load data from a file into a MSSQL table. | | [Bulk load into MySQL](https://pentaho-community.atlassian.net/wiki/spaces/EAI/pages/371558487/Bulkload+into+MySQL) | Bulk loading | Load data from a file into a MySQL table. | | [Bulk load into Snowflake](https://docs.pentaho.com/pdia-data-integration/9.3-data-integration/pdi-job-entries-reference-overview/bulk-load-into-snowflake) | Bulk loading | Load data from a file into a Snowflake data warehouse | | [Check Db connections](https://pentaho-community.atlassian.net/wiki/spaces/EAI/pages/386803260/Check+Db+connections) | Conditions | Check if we can connect to one or several databases. | | [Check files locked](https://pentaho-community.atlassian.net/wiki/spaces/EAI/pages/388311365/Check+Files+Locked) | Conditions | Check if one or several files are locked by another process. | | [Check if a folder is empty](https://pentaho-community.atlassian.net/wiki/spaces/EAI/pages/372703491/Check+if+a+folder+is+empty) | Conditions | Check if a folder is empty. | | [Check if connected to repository](https://pentaho-community.atlassian.net/wiki/spaces/EAI/pages/388311171/Check+if+connected+to+Repository) | Repository | Return `true` if we are connected to a repository. | | [Check if XML file is well formed](https://pentaho-community.atlassian.net/wiki/spaces/EAI/pages/372703498/Check+if+XML+file+is+well+formed) | XML | Check if one or several XML files is/are well formed. | | [Check webservice availability](https://pentaho-community.atlassian.net/wiki/spaces/EAI/pages/386793920/Check+webservice+availability) | Conditions | Check if a webservice is available. | | [Checks if files exist](https://pentaho-community.atlassian.net/wiki/spaces/EAI/pages/388311875/Checks+if+files+exists) | Conditions | Checks if files exist. | | [Columns exist in a table](https://pentaho-community.atlassian.net/wiki/spaces/EAI/pages/372703493/Columns+exist+in+a+table) | Conditions | Check if one or several columns exist in a table on a specified connection. | | [Compare folders](https://pentaho-community.atlassian.net/wiki/spaces/EAI/pages/372703464/Compare+folders) | File management | Compare two folders (or two files). | | [Convert file between Windows and Unix](https://pentaho-community.atlassian.net/wiki/spaces/EAI/pages/388303164/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](https://pentaho-community.atlassian.net/wiki/spaces/EAI/pages/372703442/Copy+Files) | File management | Copy files. | | [Copy or Move result filenames](https://pentaho-community.atlassian.net/wiki/spaces/EAI/pages/388303022/Process+result+filenames) | File management | Copy or move result filenames (since version 5.0, this job entry has been renamed to Process result filenames and it handles Delete as well). | | [Create a folder](https://pentaho-community.atlassian.net/wiki/spaces/EAI/pages/372703482/Create+a+folder) | File management | Create a folder. | | [Create file](https://pentaho-community.atlassian.net/wiki/spaces/EAI/pages/371558469/Create+a+file) | File management | Create an empty file. | | [Create Snowflake warehouse](https://docs.pentaho.com/pdia-data-integration/9.3-data-integration/pdi-job-entries-reference-overview/create-warehouse-pdi-job-entry) | Service management | Create a Snowflake virtual warehouse. | | [Decrypt files with PGP](https://pentaho-community.atlassian.net/wiki/spaces/EAI/pages/388311882/Decrypt+files+with+PGP) | File encryption | Decrypt files encrypted with PGP (Pretty Good Privacy). This job entry needs GnuPG to work properly. | | [Delete file](https://pentaho-community.atlassian.net/wiki/spaces/EAI/pages/371558476/Delete+a+file) | File management | Delete a file. | | [Delete filenames from result](https://pentaho-community.atlassian.net/wiki/spaces/EAI/pages/372703484/Delete+filenames+from+result) | File management | Delete filenames from result. | | [Delete files](https://pentaho-community.atlassian.net/wiki/spaces/EAI/pages/372703421/Delete+Files) | File management | Delete files. | | [Delete folders](https://pentaho-community.atlassian.net/wiki/spaces/EAI/pages/372703488/Delete+folders) | File management | Delete specified folders. If a the folder contains files, PDI will delete them all. | | [Delete Snowflake warehouse](https://docs.pentaho.com/pdia-data-integration/9.3-data-integration/pdi-job-entries-reference-overview/delete-snowflake-warehouse) | Service management | Drops a Snowflake warehouse. | | [Display Msgbox Info](https://pentaho-community.atlassian.net/wiki/spaces/EAI/pages/371558483/Display+Msgbox+info) | Utility | Display a simple message information box. | | [DTD Validator](https://pentaho-community.atlassian.net/wiki/spaces/EAI/pages/372703436/DTD+Validator+Job+Entry) | XML | Verify if an XML file corresponds to a certain structure or format. | | [Dummy](https://pentaho-community.atlassian.net/wiki/spaces/EAI/pages/370967990/Dummy+Job+Entry) | General | Use the Dummy job entry to do nothing in a job. | | [Encrypt files with PGP](https://pentaho-community.atlassian.net/wiki/spaces/EAI/pages/388311885/Encrypt+files+with+PGP) | File encryption | Encrypt files with PGP (Pretty Good Privacy). This job entry needs GnuPG to work properly. | | [Evaluate files metrics](https://pentaho-community.atlassian.net/wiki/spaces/EAI/pages/388311879/Evaluate+files+metrics) | Conditions | Evaluate files size or files count. | | [Evaluate rows number in a table](https://pentaho-community.atlassian.net/wiki/spaces/EAI/pages/376442133/Evaluate+rows+number+in+a+table) | Conditions | Evaluate the content of a table. You can also specify an SQL query. | | Example job (deprecated) | Deprecated | Is an example test job entry for a plugin. | | [Export repository to XML file](https://pentaho-community.atlassian.net/wiki/spaces/EAI/pages/386794735/Export+repository+to+XML+file) | Repository | Export repository to XML file. | | [File Compare](https://pentaho-community.atlassian.net/wiki/spaces/EAI/pages/371558478/File+compare) | File management | Compare two files. | | [File exists (Job Entry)](https://docs.pentaho.com/pdia-data-integration/9.3-data-integration/pdi-job-entries-reference-overview/file-exists-job-entry) | Conditions | Check if a file exists. | | [FTP Delete](https://pentaho-community.atlassian.net/wiki/spaces/EAI/pages/388311891/FTP+Delete) | File transfer | Delete files in a remote host. | ## Entries: G - L | Name | Category | Description | | ------------------------------------------------------------------------------------------------------------------------------------------------------- | --------------- | ------------------------------------------------------------------- | | [Get a file with FTP](https://pentaho-community.atlassian.net/wiki/spaces/EAI/pages/371558464/Get+a+file+with+FTP) | File transfer | Get files using FTP (File Transfer Protocol). | | [Get a file with FTPS](https://pentaho-community.atlassian.net/wiki/spaces/EAI/pages/388311894/Get+a+file+with+FTPS) | File transfer | Get a file with FTP secure. | | [Get a file with SFTP](https://pentaho-community.atlassian.net/wiki/spaces/EAI/pages/371558467/Get+a+file+with+SFTP) | File transfer | Get files using SFTP (Secure File Transfer Protocol). | | [Get mails (POP3/IMAP)](https://pentaho-community.atlassian.net/wiki/spaces/EAI/pages/372703419/Get+Mails+from+POP) | Mail | Get mails (POP3/IMAP) server and save into a local folder. | | [Google BigQuery loader](https://docs.pentaho.com/pdia-data-integration/9.3-data-integration/pdi-job-entries-reference-overview/google-bigquery-loader) | Big Data | Load data into Google BigQuery from a Google Cloud Storage account. | | [Hadoop Copy Files](https://docs.pentaho.com/pdia-data-integration/9.3-data-integration/pdi-job-entries-reference-overview/hadoop-copy-files) | Big Data | Copies files in a Hadoop cluster from one location to another. | | [Hadoop job executor](https://pentaho-community.atlassian.net/wiki/spaces/EAI/pages/388311170/Hadoop+Job+Executor) | Big Data | Execute a map/reduce job contained in a jar file. | | [HL7 MLLP Acknowledge](https://pentaho-community.atlassian.net/wiki/spaces/EAI/pages/388311956/HL7+MLLP+Acknowledge) | Utility | Acknowledge HL7 messages. | | [HL7 MLLP Input](https://pentaho-community.atlassian.net/wiki/spaces/EAI/pages/388311958/HL7+MLLP+Input) | Utility | Read data from HL7 data streams within a transformation. | | [HTTP](https://pentaho-community.atlassian.net/wiki/spaces/EAI/pages/371558468/HTTP) | File management | Get or upload a file using HTTP (Hypertext Transfer Protocol). | | [JavaScript](https://pentaho-community.atlassian.net/wiki/spaces/EAI/pages/367624224/JavaScript+job+entry) | Scripting | Evaluate the result of the execution of a previous job entry. | | [Job (job entry)](https://docs.pentaho.com/pdia-data-integration/9.3-data-integration/pdi-job-entries-reference-overview/job-job-entry) | General | Execute a job. | ## Entries: M - R | Name | Category | Description | | ------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------------ | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | [Mail](https://pentaho-community.atlassian.net/wiki/spaces/EAI/pages/371558462/Mail) | Mail | Send an email. | | [Mail validator](https://pentaho-community.atlassian.net/wiki/spaces/EAI/pages/372081634/Mail+Validator) | Mail | Check the validity of an email address (SNMP trap to a target host.) | | [Modify Snowflake warehouse](https://docs.pentaho.com/pdia-data-integration/9.3-data-integration/pdi-job-entries-reference-overview/modify-warehouse-pdi-job-entry) | Service management | Modify a Snowflake virtual warehouse. | | [Move Files](https://pentaho-community.atlassian.net/wiki/spaces/EAI/pages/372703489/Move+files) | File management | Move files. | | MS Access bulk load (deprecated) | Deprecated | Load data into a Microsoft Access table from a CSV file format. Replaced by [Microsoft Access Output Step](https://pentaho-community.atlassian.net/wiki/spaces/EAI/pages/371558136/Access+Output). | | [Oozie Job Executor](https://pentaho-community.atlassian.net/wiki/spaces/EAI/pages/388311153/Oozie+Job+Executor) | Big Data | Execute Oozie workflows. | | Palo cube create (deprecated) | Deprecated | Create a cube on a Palo server. | | Palo cube delete (deprecated) | Deprecated | Delete a cube on a Palo server. | | [Pentaho MapReduce](https://docs.pentaho.com/pdia-data-integration/9.3-data-integration/pdi-job-entries-reference-overview/pentaho-mapreduce) | Big Data | Execute transformation-based MapReduce jobs in Hadoop. | | [Pig Script Executor](https://pentaho-community.atlassian.net/wiki/spaces/EAI/pages/386793532/Pig+Script+Executor) | Big Data | Execute a Pig script on a Hadoop cluster. | | [Ping a host](https://pentaho-community.atlassian.net/wiki/spaces/EAI/pages/371558480/Ping+a+host) | Utility | Ping a host. | | [Put a file with FTP](https://pentaho-community.atlassian.net/wiki/spaces/EAI/pages/388311904/Put+a+file+with+FTP) | File transfer | Put a file with FTP. | | [Process result filenames](https://pentaho-community.atlassian.net/wiki/spaces/EAI/pages/388303022/Process+result+filenames) | File management | Copy, move, or delete result filenames. | | [Put a file with SFTP](https://pentaho-community.atlassian.net/wiki/spaces/EAI/pages/371558479/Put+a+file+with+SFTP) | File transfer | Put files using SFTP (Secure File Transfer Protocol). | ## Entries: S - Z | Name | Category | Description | | ---------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------------ | ----------------------------------------------------------------------------------------------------------------- | | [Send information using Syslog](https://pentaho-community.atlassian.net/wiki/spaces/EAI/pages/388311962/Send+information+using+Syslog) | Utility | Send information to another server using the Syslog protocol. | | [Send Nagios passive check](https://pentaho-community.atlassian.net/wiki/spaces/EAI/pages/388302578/Send+Nagios+passive+check) | Utility | Send Nagios passive checks. | | [Send SNMP trap](https://pentaho-community.atlassian.net/wiki/spaces/EAI/pages/389941184/Send+SMNP+trap) | Utility | Send SNMP trap to a target host. | | [Set variables](https://pentaho-community.atlassian.net/wiki/spaces/EAI/pages/388311910/Set+variables+job+entry) | General | Set one or several variables. | | [Shell](https://pentaho-community.atlassian.net/wiki/spaces/EAI/pages/371558460/Shell) | Scripting | Execute a shell script. | | [Simple evaluation](https://pentaho-community.atlassian.net/wiki/spaces/EAI/pages/379257190/Simple+evaluation+Job+Entry) | Conditions | Evaluate one field or variable. | | [Spark Submit](https://docs.pentaho.com/pdia-data-integration/9.3-data-integration/pdi-job-entries-reference-overview/spark-submit) | Big Data | Submit Spark jobs to Hadoop clusters. | | [SQL](https://pentaho-community.atlassian.net/wiki/spaces/EAI/pages/371558463/SQL) | Scripting | Executes SQL on a certain database connection. | | [Sqoop Export](https://pentaho-community.atlassian.net/wiki/spaces/EAI/pages/388311154/Sqoop+Export) | Big Data | Export data from the Hadoop Distributed File System (HDFS) into a relational database (RDBMS) using Apache Sqoop. | | [Sqoop Import](https://pentaho-community.atlassian.net/wiki/spaces/EAI/pages/388311159/Sqoop+Import) | Big Data | Import data from a relational database (RDBMS) into the Hadoop Distributed File System (HDFS) using Apache Sqoop. | | SSH2 Get (deprecated) | Deprecated | Get files using SSH2 (Deprecated in 5.0 in favor of the SFTP job entry). | | SSH2 Put (deprecated) | Deprecated | Put files in a remote host using SSH2 (Deprecated in 5.0 in favor of the SFTP job entry). | | [Start](https://pentaho-community.atlassian.net/wiki/spaces/EAI/pages/370967988/Start) | General | Defines the starting point for job execution. Every job must have one (and only one) Start. | | [Start a PDI Cluster on YARN](https://pentaho-community.atlassian.net/wiki/spaces/EAI/pages/388312923/Start+a+PDI+Cluster+on+YARN) | Big Data | Start a PDI Cluster on YARN. | | [Stop a PDI Cluster on YARN](https://pentaho-community.atlassian.net/wiki/spaces/EAI/pages/388312925/Stop+a+PDI+Cluster+on+YARN) | Big Data | Stop a PDI Cluster on YARN. | | [Start Snowflake warehouse](https://docs.pentaho.com/pdia-data-integration/9.3-data-integration/pdi-job-entries-reference-overview/start-snowflake-warehouse) | Service management | Resumes a Snowflake warehouse. | | [Stop Snowflake warehouse](https://docs.pentaho.com/pdia-data-integration/9.3-data-integration/pdi-job-entries-reference-overview/stop-snowflake-warehouse) | Service management | Suspends a Snowflake warehouse. | | [Success](https://pentaho-community.atlassian.net/wiki/spaces/EAI/pages/372703425/Success) | General | Clear any error state encountered in a job and forces it to a success state. | | [Table exists](https://pentaho-community.atlassian.net/wiki/spaces/EAI/pages/371558465/Table+Exists+Job+Entry) | Conditions | Check if a table exists on a database connection. | | Talend job execution (deprecated) | Deprecated | Execute an exported Talend job. | | [Transformation (job entry)](https://docs.pentaho.com/pdia-data-integration/9.3-data-integration/pdi-job-entries-reference-overview/transformation-job-entry-cp) | General | Run a transformation. | | [Truncate tables](https://pentaho-community.atlassian.net/wiki/spaces/EAI/pages/372081674/Truncate+tables) | Utility | Truncate one or several tables. | | [Unzip file](https://pentaho-community.atlassian.net/wiki/spaces/EAI/pages/372703451/Unzip+file) | File management | Unzip file in a target folder. | | [Upload files to FTPS](https://pentaho-community.atlassian.net/wiki/spaces/EAI/pages/388311907/Upload+files+to+FTPS) | File transfer | Upload files to a FTP secure. | | [Verify file signature with PGP](https://pentaho-community.atlassian.net/wiki/spaces/EAI/pages/388311888/Verify+file+signature+with+PGP) | File encryption | Verify file signature with PGP (Pretty Good Privacy). This job entry needs GnuPG to work properly. | | [Wait for](https://pentaho-community.atlassian.net/wiki/spaces/EAI/pages/371558481/Wait+for) | Conditions | Wait for a delay. | | [Wait for file](https://pentaho-community.atlassian.net/wiki/spaces/EAI/pages/371558477/Wait+for+a+file) | File management | Wait for a file. | | [Wait for SQL](https://pentaho-community.atlassian.net/wiki/spaces/EAI/pages/388311119/Wait+for+SQL) | Utility | Scan a database and success when a specified condition on returned rows is `true`. | | [Write to file](https://pentaho-community.atlassian.net/wiki/spaces/EAI/pages/388311173/Write+to+File) | File management | Write text content to file. | | [Write To Log](https://pentaho-community.atlassian.net/wiki/spaces/EAI/pages/372703439/Write+to+log) | Utility | Write message to log. | | [XSD Validator](https://pentaho-community.atlassian.net/wiki/spaces/EAI/pages/372703433/XSD+Validator+Job+Entry) | XML | Perform an XSD validation against data in a file or in an input field. | | [XSL Transformation](https://pentaho-community.atlassian.net/wiki/spaces/EAI/pages/371558485/XSL+Transformation+Job+Entry) | XML | Make an XSL transformation. | | [Zip file](https://pentaho-community.atlassian.net/wiki/spaces/EAI/pages/371558486/Zip+file) | File management | Zip files from a directory and process files. |