This documentation supports the 9.1 to 9.1 Service Pack 3 version and its patches of BMC Atrium Core. The documentation for version 9.1.04 and its patches is available here.

To view the latest version, select the version from the Product version menu.

Changing source configuration in Atrium Integrator Spoon

You can manipulate your source data in Atrium Integrator Spoon before transferring it to BMC Atrium CMDB. For example, you can limit the number of records to be transferred on an initial run. This is very useful for initial verification before bulk-loading data into BMC Atrium CMDB. You can also write an SQL query to limit the data to be processed rather than processing all the data from the source table.

To limit the number of rows for initial processing

  1. Open your transformation in Atrium Integrator Spoon. For more information, see Opening Atrium Integrator job or transformation.
  2. Double-click the input step to open the input step dialog box.
  3. In the Limit size field, enter the number of records to import to BMC Atrium CMDB.
  4. Click OK.
    When you run the transformation, only the specified number of records from the source table are transferred to BMC Atrium CMDB.

Importing a subset of the data

  1. Open your transformation in Atrium Integrator Spoon. For more information, see Opening Atrium Integrator job or transformation.
  2. Double-click the input step.
    The input step dialog box appears.
  3. Click Get SQL select statement.
  4. Type an appropriate query.
  5. Click OK.
    When you run the transformation, records from the source table are transferred to BMC Atrium CMDB depending on the query you specified.
Was this page helpful? Yes No Submitting... Thank you

Comments