This documentation supports the 20.08 version of BMC CMDB, which is available only to BMC Helix subscribers (SaaS).

To view an earlier version, select the version from the Product version menu.

Adding intermediate steps to 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 manipulate the data before adding it to BMC CMDB. 

For information about additional steps that you can add to your job, see the Spoon User Guide at

Intermediate steps for jobs 


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


Starts a job.


Adds a dummy step to enable you to test your job. The dummy step does not perform any evaluation.


Executes a previously defined job.


Clears an error state found in a job and forces it to the success state.


Executes a previously defined transformation.

Mail menu

Get mails

Retrieves email messages from a POP server and stores them into one or more files.


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.


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


Executes a JavaScript script.


Executes a shell script on the host where the job is running.


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.

Was this page helpful? Yes No Submitting... Thank you