This documentation supports the 19.08 version of BMC CMDB.

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

Creating a job in Atrium Integrator Spoon

You can use Atrium Integrator Spoon to import and export data from inputs like LDAP, Remedy AR System forms, Remedy ITSM suite forms, and those requiring complex staging tasks or complex data manipulations. BMC provides several sample jobs that you can use as a starting point. You can also refer to sample transformations for each step, which can be accessed from the following location: 


For more information about different complex jobs, see Managing complex jobs using Atrium Integrator Spoon.

Best practice

  • Use a naming convention for jobs and transformations that makes them easy to identify. Use the same name prefix to identify related jobs and transformations.
  • Use variables for file paths or computer-specific connection information so that file paths and so forth can be determined dynamically instead of statically. You can refer to the Sample jobs for this information.
  • When you create a transformation from Atrium Integrator Spoon, ensure that the Remedy AR System server connnection used in the CMDBInput CMDBOutput, LookUp, ARInput, and AROutput steps has an entry in the UDM:RAppassword form with the Remedy Application service user and its password.
  • When creating or running an Atrium Integrator job, we recommended that you do not use PDIrepo as a source connection. For CMDB Plugins, use SAMPLE_CMDB_Connection or create an Remedy AR System datastore in the Atrium Integrator Console, and use that datastore in the connection.

To customize a sample job or transformation

The starting point for creating a job using Atrium Integrator Spoon is to customize a sample job or transformation that is already available. If you have deployed BMC Helix CMDB as a container image in your on-premises environment, or if you are a SaaS subscriber

  1. On the computer where the Atrium Integrator Spoon client installed, select Start > Programs > BMC Software > AR System > BMC Atrium Integrator Spoon.
    The Remedy AR System connection dialog box appears. 
    Remedy AR System Connection

  2. Log on as follows:
    1. From the AR Server list, select the Remedy Action Request System server on which you have installed the Remedy Action Request System database.
    2. In the User Name field, enter the user name for the Remedy Action Request System server.
      For information about the user name that you must specify, see Atrium Integrator permissions.
    3. In the Password field, enter the credentials for the Remedy Action Request System server.
    4. Click OK.
  3. In the Atrium Integrator Spoon window, select Tools > Repository > Explore.
    The Repository explorer dialog box shows the sample jobs and transformations in the BMCSAMPLES directory.
  4. Double-click a sample job or transformation.
  5. Select File > Save as.
  6. In the properties window, enter a name for the job or transformation and then click OK.
    The sample job or transformation is saved with the name that you specify.


    When you create an Remedy Action Request System transformation from Atrium Integrator Spoon, the records inserted and updated are displayed in the Output column of the Step Matrix table.

  7. Edit the job or transformation as needed.


    When you schedule a job from Atrium Integrator Spoon, the scheduling information is not updated the Remedy AR System Job and Remedy AR System Item forms.

To edit a custom Spoon job in a containerized environment

In a containerized environment, you cannot copy flat files, such as CSV and XML directly on the server. You must first create entries in the UDM attachments form. If you have a custom job that reads a data file such as Textfile Input and MS Excel Input, perform the following actions:

  1. Create a record for the source data file in an Remedy AR System form that support attachments such as the UDM:Attachments form.
    To open the form, use the URL http://<server-name>:<port>/arsys/forms/<server-name>/<form name>.
  2. Save the form.
  3. Go to Pentaho Spoon to edit the custom job or transformation.
  4. Before the data file input step, add a step in the transformation that downloads the attachment from the Remedy AR System form and save it to a local file system.
    Set the parameters in this step to download the job specific attachment and pass it as an input to the data file input step.
    See this sample custom transformation to help you modify your custom transformation: Sample .ktr file.

For more information about creating a job in Atrium Integrator Spoon, see the Spoon User Guide at .

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