Using the Atrium Integrator Spoon client


In Action Request System, the Pentaho Spoon application is referred to as Atrium Integrator Spoon. You can edit jobs in the Atrium Integrator Spoon. BMC provides limited support for Pentaho and Atrium Integrator Spoon. For more information see the Atrium Integrator Spoon support documentation.


Related topic

Atrium Integrator Spoon has a drag-and-drop graphical user interface that makes it easy for you to edit your transformations and clean up your data before putting it into BMC Helix CMDB.

On a remote Windows computer, Atrium Integrator Spoon directly connects to the Action Request System database to save and retrieve transformations and jobs.

Atrium Integrator Spoon is installed as part of the Action Request System. 

For information about launching Atrium Integrator Spoon, see User-interface-overview. 

To install the Atrium Integrator Spoon client

Important

When you upgrade to BMC Helix Innovation Suite 23.3.04, uninstall the existing Atrium Integrator Spoon Client and reinstall the 23.3.04-supported version from EPD. Because the Atrium Integrator Spoon Client 23.3.04 supports JDK17, make sure you have JDK17 installed on the system where you want to install the Atrium Integrator Spoon client.

  1. In the search field, enter BMC Helix ITSM .
  2. In the search results, download the following files by selecting 23.3.04 > Product:
    • AR System Clients: Developer Studio, Data Import version 23.3.04
    • BMC Atrium Integrator Client Version 23.3.04
  3. In your local system, unzip these files.
  4. Open the ARSuiteKitDeveloperWindows folder.
  5. Navigate to the Disk 1 folder and run the setup.exe file.
  6. On the Introduction page, click Next.
  7. On the License Agreement page, review the license agreement, click I agree to the terms of license agreement, and then click Next.
  8. On the User Inputs page, in the Destination Directory field, specify the directory in which you want to install the AR System clients, and click Next.
    The default location is C:\Program Files\BMC Software\ARSystem
  9. In the 64-bit JAVA Path field, specify the JRE path, and click Next.
    Make sure you set the JDK17 path.
  10. Similarly, install the BMC Atrium Integrator Client from atriumintegrator23.3.04.client.win folder.
    Spoon client install.jpg

  11. Open Atrium Integrator Spoon from the Start menu on your system.
    start_menu_ai.JPG

The following videos provide an overview Atrium Integrator Spoon:


icon-play.png https://youtu.be/20KG2SwOsS4

icon-play.png https://youtu.be/ZGbnAL9yPro

Atrium Integrator Spoon interface

The following figure illustrates the parts of Atrium Integrator Spoon interface. 

AI Spoon UI.jpg

Menu bar

The menu bar provides access to common actions such as creating a new transformation or job, editing it, connecting to a repository, and running or debugging the job or transformation.

Navigation panel

The navigation panel on the left contains a View tab and Design tab.

  • The View tab maintains a history of the different types of steps that were added to the active transformation or job. For a new transformation or job, this tab displays the steps that a transformation must include to run successfully.
  • The Design tab provides an organized list of transformation steps or job entries used to build transformations and jobs.

You can perform a search in either tab by typing a phrase in the search field and pressing the Enter key. The steps containing the search phrase are displayed. 

Click the Expand icon.gif icon to expand all steps and the  Collapse icon.gif icon to collapse the steps.

Toolbar

The toolbar provides buttons for common actions such as creating a new file, opening a saved file, and saving a file. It also provides buttons for quick access to common actions specific to the active transformation or job, such as Run, Preview, and Debug.

Canvas

The canvas is the main design area for building transformations and jobs.

Active transformation or job

The canvas displays a number of tabbed views that represent the open transformations and jobs.


Atrium Integrator Spoon support

BMC provides limited support for Atrium Integrator Spoon and you must consider the following:

Unsupported parameter for macro: tags Due of this, the macro might have some unexpected results.

  • Install and use only the Pentaho and Atrium Integrator Spoon version that is packaged with the AR System installer.
    For more information see, Installing.
  • Though Pentaho Spoon is supported on other platforms, BMC supports Atrium Integrator Spoon only on the Windows platform.
    For more information see, System requirements.
  • BMC supports selected steps from those provided in the Spoon. See, Steps-in-Atrium-Integrator-transformation. This list will be revisited periodically and support for new steps might be added or removed during each revision. Any queries around complex customization using unsupported steps will be addressed selectively and at discretion of BMC. For information about steps other than supported by BMC, see the Pentaho online documentation.
  • BMC supports selected vendor databases which include – IBM DB2, MS SQL Server, Oracle, Sybase, and My SQL. So for example, when you use the Table Input or Table output step, you can point only to the BMC supported vendor databases.


 

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