Skip to Content
Information
This documentation supports the 20.02 version of BMC CMDB.To view an earlier version, select the version from the Product version menu.

Changing source configuration in Atrium Integrator Spoon

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


Related topics

Transferring data from external data sources to CMDB


To limit the number of rows for initial processing

  1. Open your transformation in Atrium Integrator Spoon. For more information, see Editing an 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 CMDB.
  4. Click OK.
    When you run the transformation, only the specified number of records from the source table are transferred to BMC CMDB.

Importing a subset of the data

  1. Open your transformation in Atrium Integrator Spoon. 
  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 CMDB depending on the query you specified.


 

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

BMC CMDB 20.02