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

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