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: 

<ARClientinstallDirectory>\diserver\dataintegration\Sample

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

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.

   Important

   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.

   Important

   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 http://wiki.pentaho.com/display/EAI/Spoon+User+Guide .