Creating database connections with the AR Connection module

1. Log in to Atrium Integrator Spoon Client.
2. In the View Tab, expand the Transformations folder.
3. Right-click Database connections and select New.
   The Database Connection dialog box opens.
4. In the dialog box, enter the connection name.
5. Select General > AR System and enter the remaining setting values.
6. Click OK to establish the connection.
   

Support for Client Managed Transactions

The Atrium Integrator adapter uses the AR System Client Managed Transaction feature to open a database connection instance and share that connection with all transformation steps. Transformations using ARInput, AROutput, and CMDB sources use this feature because the sources operate on objects with relationships and make modifications on multiple forms and/or tables based on data in other tables as well as results from previous steps.

For example, the adapter might receive data from an LDAP server and place it in User forms. If a problem occurs, rolling back changes is easy when the transformation runs in a single database connection.

To enable support for Client Managed Transactions

1. Log in to Atrium Integrator Spoon Client.
2. In the View Tab, expand the Transformations folder.
3. In the list of transformations, right-click the required transformation and select Settings.
   The Transformation properties dialog box is displayed.
4. In the dialog box, select Miscellaneous.
5. Select the Make the transformation database transactional check box.