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

Exporting data from AR System forms to external data stores


To export data from Remedy AR System forms to external data stores, you need to create and run the job from Atrium Integrator Spoon. You cannot run this job from Atrium Integrator console. 

To export data from AR system forms to external data stores

  1. Open a new transformation in Atrium Integrator Spoon.
  2. Add the ARInput step.
    1. Double-click the step. The ARInput dialog box appears.
    2. Click the General tab.
    3. In the Connection field, enter connection information.
    4. In the Form Name field, select the Remedy AR System form from which you want to transfer the data.
    5. Click OK.
  3. Add the Insert/Update step.
  4. Add the Add constants step between the ARInput step and Insert/Update step.
    1. Double-click the step. The Select/Rename Values dialog box appears.
    2. Click the Select & Alter tab.
    3. Verify the field mapping.
    4. Click OK.
      The following figure illustrates the transformation. 

      Transformation export data from 

      Remedy AR System

       forms to external data stores 
      Export_data from_AR_system_forms.gif

  5. Save and Run the job.
    For more information, see Running-a-transformation-job-in-Atrium-Integrator-Spoon.

 

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

BMC CMDB 20.02