Atrium Integrator Spoon

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, Atrium Integrator Spoon support documentation.

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 Accessing-components-of-BMC-Atrium-Core-Console.

Atrium Integrator Spoon interface

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

SpoonUI_4.1.0.png

The following video provides an overview Atrium Integrator Spoon:

https://youtu.be/20KG2SwOsS4

https://youtu.be/ZGbnAL9yPro

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 icon to expand all steps and the 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. In the following figure, the DiskDrive transformation is the active transformation.

Atrium Integrator Spoon support

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

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 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.