Adding intermediate steps to a Atrium Integrator job

You can add intermediate steps to a job that you create through the Integration Job Builder wizard, or to a custom job you create through the Atrium Integrator Spoon.

To add an intermediate step to a job

Click the step that you want to add and drag it to the canvas.

The following table lists the common steps you can add to your job to ma nipulate the data before adding it to BMC Atrium CMDB.

For information about additional steps that you can add to your job, see the Spoon User Guide at http://wiki.pentaho.com/display/EAI/Spoon+User+Guide.

Intermediate steps for jobs

Option	What it helps you do
Utility menu
Abort job	Aborts the specified job.
Display Msgbox Info	Displays a message box in the job to enable you to see where you are in the process.
Ping a host	Pings a host machine using the ICMP protocol.
Truncate tables	Truncates one or several tables.
Write to Log	Writes a specific string to the PDI logging system.
General menu
Start	Starts a job.
Dummy	Adds a dummy step to enable you to test your job. The dummy step does not perform any evaluation.
Job	Executes a previously defined job.
Success	Clears an error state found in a job and forces it to the success state.
Transformation	Executes a previously defined transformation.
Mail menu
Get mails	Retrieves email messages from a POP server and stores them into one or more files.
Mail	Sends a text or HTML email messages with optional file attachments.
File management menu
Add filenames to result	Adds a set of files or folders to the result list of the job entry. This list of file names can then be used in the various job entries all around.
Compare folders	Compares two folders to check if their content is identical.
Copy Files	Copies one of more files or folders.
Copy or Move result filenames	Copies or moves all the file names that are in the result files list of the last job entry.
Create a folder	Creates a folder at the specified location.
Create file	Create an empty file at the specified location. This is useful for creating trigger files from within jobs.
Delete file	Deletes the specified file.
Delete filenames from result	Delete all the file names that are in the result files list of the last job entry.
Delete files	Deletes a set of files.
Delete folders	Deletes one or more folders and all the content in them.
File Compare	Compares the contents of two files and controls the flow of the job by it. When the contents of the files are the same, the success outgoing hop is followed; otherwise, the failure hop is followed.
HTTP	Gets a file from a web server using the HTTP protocol.
Move Files	Moves a number of files and, folders, or both to alternate locations on your file system.
Unzip file	Unzips one or more files.
Wait for file	Waits for a file. This job entry sleeps and periodically checks whether the specified file exists, after which the flow continues. The job entry can either wait indefinitely for the file or it can time out after a certain time.
Zip file	Creates a standard ZIP archive using the options that you specify.
Conditions menu
Check if a folder is empty	Verifies if a folder is empty (contains no files).
Check if files exist	Verifies if certain files exist on the server on which Kettle runs.
Columns exist in a table	Verifies that one or more columns exist in a database table.
Evaluate rows number in a table	Define the success condition that can be evaluated. The job process can be branched by the result of this step. For the success condition, you can check the number of rows if they are: Equal to Different from Smaller than Smaller or equal to Greater than Greater or equal to
File Exists	Verify if the specified file exists on the server on which Kettle runs.
Simple evaluation	Evaluates contents of a variable or a field in the result stream. You can connect two steps with the output of the Simple Evaluation. The green connection is used to indicate success, the red one to indicate failure.
Table exists	Verifies if the specified table exists on a database.
Wait for	Wait for the specified time before running the next job entry.
Scripting menu
JavaScript	Executes a JavaScript script.
Shell	Executes a shell script on the host where the job is running.
SQL	Executes an SQL script.
Bulk loading menu
BulkLoad from Mysql into file	Loads data from a MySQL table to a text file.
BulkLoad into MSSQL	Loads data from a text file into a Microsoft SQL Server table.
BulkLoad into Mysql	Loads data from a text file into a MySQL table.
XML menu
Check if XML is well formed	Verifies that one or more files contain well formed (allowed) XML content.
DTD Validator	Verifies that an XML file corresponds to a certain structure or format.
XSD Validator	Validates the specified XML file against the specified XML Schema Definition (XSD) file.
XSL Transformation	Transforms the specified XML file into another document.
Repository menu
Check if connected to repository	Checks whether you are connected to the repository.
File transfer menu
Get a file with FTP	Gets one or more files from an FTP server.
Get a file with SFTP	Gets one or more files from an FTP server using the Secure FTP protocol.
Put a file with FTP	Puts one or more files on an FTP server.
Put a file with SFTP	Puts one or more files on an FTP server using the Secure FTP protocol.

Adding intermediate steps to a Atrium Integrator job

To add an intermediate step to a job

Comments