This documentation supports the 21.3 version of BMC Helix 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, AR System forms, BMC Helix ITSM 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: 

<ARClientinstallDirectory>\diserver\dataintegration\Sample

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 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 AR System datastore in the Atrium Integrator Console, and use that datastore in the connection.

To access the Atrium Integrator Spoon

  1. Log in to the computer on which Atrium Integrator Spoon is installed.
  2. To open Atrium Integrator Spoon, open the Spoon.bat file at the following location:
    <installationDirectory>\diserver\data-integration\

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, perform the following steps:

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

    AR System

     Connection
    SpoonConnection.png

  2. Log on as follows:
    1. From the AR Server list, select the AR System server on which you have installed the Action Request System database.
    2. In the User Name field, enter the user name for the AR 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 AR 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.

    Important

    When you create an 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.

    Important

    When you schedule a job from Atrium Integrator Spoon, the scheduling information is not updated the AR System Job and 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 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 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.
    ARInput step in custom spoon job.png


For more information about creating a job in Atrium Integrator Spoon, see the Pentaho online documentation.


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*