Running a transformation job in Atrium Integrator Spoon

If you edit or create a transformation job in Atrium Integrator Spoon, you can then run the transformation job locally or remotely by using the Execute a job dialog box. However, to run a transformation job remotely, you must first configure Atrium Integrator Spoon to use a slave server.

Important

Clustered execution of jobs in Atrium Integrator Spoon is not supported.

Before you begin

You must first create a job in the Atrium Integrator Spoon as described in Creating-a-job-in-Atrium-Integrator-Spoon.

Related topics

Remote execution of transformations
Initialize Slave Servers in Spoon

Configuring-Atrium-Integrator-Spoon-to-add-a-slave-server-to-execute-jobs-remotely

To run a job in 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\
  3. To open a job, go to Tools > Repository > Explore to open the Repository explorer dialog box.
  4. Double-click a job you want to run so that it is added to the Explorer pane.
  5. Select the job in the Explorer pane and click Run this job image2018-12-13_13-19-1.png.
    Run the AI job.jpg
  6. Click Run.
    The Run Options window opens. 
    Spoon run job options.jpg

  7. Perform either of the following steps:
    • To run the job locally, select Local execution.
    • To run the job remotely, select the Execute remotely check box and specify the remote host. 
      The Remote host list shows the servers that you entered in the Slave Server dialog when configuring Atrium Integrator Spoon to access the slave server.
      image2018-12-13_11-35-11.png
  8. Specify logging details.
    If you are troubleshooting, you can set this to Rowlevel.
  9. Click Launch.
    The job starts, and Atrium Integrator Spoon displays the progress in the Executing Results section of the window.

Tip

A Spoon job with an output step automatically uses the .txt extension for the output file. To change the file type, manually change the extension before you save the output file.


Troubleshooting

  • The Atrium Integrator Spoon closes unexpectedly when you run a Spoon job twice. This may occur if the Spoon job has a step that uses SQL Query, such as TableInput, and if the Windows screen resolution is set at 1920 x 1440.
  • When you run an Atrium Integrator Spoon job with a CMDBOutput step, the CMDB form stores junk characters. This might occur if the Atrium Integrator Spoon job has a TableInput step that connects to a Postgres database, and the Enable Lazy Conversion check box is selected.

 

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