{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"excerpt","parameters":{"macroParams":{"hidden":{"value":"true"}},"macroMetadata":{"macroId":{"value":"e7e539c3-3225-40a5-b242-347b41a45ab3"},"schemaVersion":{"value":"1"},"title":"Excerpt"}}},"content":[{"type":"paragraph","content":[{"text":"Job Entries are Parts of Jobs","type":"text"}]}]},{"type":"heading","attrs":{"level":1},"content":[{"text":"Introduction","type":"text"}]},{"type":"paragraph","content":[{"text":"This page contains the index for the documentation on all the standard job entries in Pentaho Data Integration version 3.2.","type":"text"}]},{"type":"table","content":[{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"extension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"legacy-content","text":"","parameters":{"cxhtml":"top

\n\n

General

Dummy
Abort job
Display MsgBox Info
Job
Send SNMP trap
Set variables
Transformation
Wait for SQL
\\\\\\\\

\n\n

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"column","parameters":{"macroParams":{"align":{"value":"top"}},"macroMetadata":{"macroId":{"value":"47003a4f-7b67-435e-b572-62a8272f3897"},"schemaVersion":{"value":"1"},"title":"Column"}}},"content":[{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"General","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Start","type":"text","marks":[{"type":"link","attrs":{"href":"https://pentaho-public.atlassian.net/wiki/spaces/EAI/pages/370967988"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Dummy","type":"text","marks":[{"type":"link","attrs":{"href":"https://pentaho-public.atlassian.net/wiki/spaces/EAI/pages/370967990"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Abort job","type":"text","marks":[{"type":"link","attrs":{"href":"https://pentaho-public.atlassian.net/wiki/spaces/EAI/pages/371558484"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Display MsgBox Info","type":"text","marks":[{"type":"link","attrs":{"href":"https://pentaho-public.atlassian.net/wiki/spaces/EAI/pages/371558483"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Job","type":"text","marks":[{"type":"link","attrs":{"href":"https://pentaho-public.atlassian.net/wiki/spaces/EAI/pages/371558458"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Ping a host","type":"text","marks":[{"type":"link","attrs":{"href":"https://pentaho-public.atlassian.net/wiki/spaces/EAI/pages/371558480"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Send SNMP trap","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Set variables","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Success","type":"text","marks":[{"type":"link","attrs":{"href":"https://pentaho-public.atlassian.net/wiki/spaces/EAI/pages/372703425"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Transformation","type":"text","marks":[{"type":"link","attrs":{"href":"https://pentaho-public.atlassian.net/wiki/spaces/EAI/pages/371558335"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Truncate tables","type":"text","marks":[{"type":"link","attrs":{"href":"https://pentaho-public.atlassian.net/wiki/spaces/EAI/pages/372081674"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Wait for SQL","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Write to log","type":"text","marks":[{"type":"link","attrs":{"href":"https://pentaho-public.atlassian.net/wiki/spaces/EAI/pages/372703439"}}]},{"text":"\\\\\\\\","type":"text"}]}]}]}]}],"version":1}}}}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"extension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"legacy-content","text":"","parameters":{"cxhtml":"top

\n\n

Mail

Get mails from POP
Mail validator

\n\n

File management

Copy files
Copy or move result filenames
Delete file
Delete files
Wait for file
Zip files

\n\n

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"column","parameters":{"macroParams":{"align":{"value":"top"}},"macroMetadata":{"macroId":{"value":"3dcdc46a-c705-4425-b52f-b4482abfd140"},"schemaVersion":{"value":"1"},"title":"Column"}}},"content":[{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"File management","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Add filenames to result","type":"text","marks":[{"type":"link","attrs":{"href":"https://pentaho-public.atlassian.net/wiki/spaces/EAI/pages/372703461"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Compare folders","type":"text","marks":[{"type":"link","attrs":{"href":"https://pentaho-public.atlassian.net/wiki/spaces/EAI/pages/372703464"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Copy files","type":"text","marks":[{"type":"link","attrs":{"href":"https://pentaho-public.atlassian.net/wiki/spaces/EAI/pages/372703442"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Copy or move result filenames","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Create a folder","type":"text","marks":[{"type":"link","attrs":{"href":"https://pentaho-public.atlassian.net/wiki/spaces/EAI/pages/372703482"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Create a file","type":"text","marks":[{"type":"link","attrs":{"href":"https://pentaho-public.atlassian.net/wiki/spaces/EAI/pages/371558469"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Delete file","type":"text","marks":[{"type":"link","attrs":{"href":"https://pentaho-public.atlassian.net/wiki/spaces/EAI/pages/371558476"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Delete filenames from result","type":"text","marks":[{"type":"link","attrs":{"href":"https://pentaho-public.atlassian.net/wiki/spaces/EAI/pages/372703484"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Delete files","type":"text","marks":[{"type":"link","attrs":{"href":"https://pentaho-public.atlassian.net/wiki/spaces/EAI/pages/372703421"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Delete folders","type":"text","marks":[{"type":"link","attrs":{"href":"https://pentaho-public.atlassian.net/wiki/spaces/EAI/pages/372703488"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"File compare","type":"text","marks":[{"type":"link","attrs":{"href":"https://pentaho-public.atlassian.net/wiki/spaces/EAI/pages/371558478"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"HTTP","type":"text","marks":[{"type":"link","attrs":{"href":"https://pentaho-public.atlassian.net/wiki/spaces/EAI/pages/371558468"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Move files","type":"text","marks":[{"type":"link","attrs":{"href":"https://pentaho-public.atlassian.net/wiki/spaces/EAI/pages/372703489"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Unzip file","type":"text","marks":[{"type":"link","attrs":{"href":"https://pentaho-public.atlassian.net/wiki/spaces/EAI/pages/372703451"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Wait for file","type":"text","marks":[{"type":"link","attrs":{"href":"https://pentaho-public.atlassian.net/wiki/spaces/EAI/pages/371558477"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Zip files","type":"text","marks":[{"type":"link","attrs":{"href":"https://pentaho-public.atlassian.net/wiki/spaces/EAI/pages/371558486"}}]},{"type":"hardBreak"}]}]}]}]}],"version":1}}}}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"extension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"legacy-content","text":"","parameters":{"cxhtml":"top

\n\n

Conditions

Check if files exist
File exists
Simple evaluation
Table exists

\n\n

Scripting

JavaScript

\n\n

Bulk Loading

Bulk Load from MySQL into file
Bulk Load into MS SQL Server
Bulk Load into MySQL
MS Access Bulk Load

\n\n

XML

DTD validator
XSD validator
XSL transformation

\n\n

File transfer

FTP Delete
Put a file with FTP
SSH2 Get
SSH2 Put

\n\n

Repository

Check if connected to repository
Export repository to XML file

\n\n

Experimental

no items at this time

Pentaho Data Integration v3.2. Job Entries

Introduction