Maintaining Update Resources

Maintaining Update Resources

In addition to Data Tanks and a Mapper, all update resources must include update properties. You can also add transaction support to define the processing of updates to multiple tables.

Defining Update Properties

The Updater defines how data from the input XML document will be updated to the Repository. When you create an update resource, and Updater is automatically included on the Data Pipe. Note that you cannot modify update properties until you have attached both a Page Data Tank and a Backend Data Tank to the Data Pipe.

To define update properties:

  1. Double-click on the Updater icon on the Data Pipe.

    The Workbench displays the Update Properties dialog.

  2. By default only the Allow creates box is checked. To allow data to be removed from the Repository, check the Allow deletes box. To allow data in the Repository to be modified by data from the input XML document, check the Allow updates box.
  3. To specify which rows to update, add columns to the Backend Column table in the Key Columns for Updating box. To add a column:
    1. Click in the first blank row.
    2. The Workbench displays a list of columns in tables included in the Backend Data Tank.
    3. Select the column you want to use.
    4. Repeat these steps to define additional columns.
    5. To confirm that the specified keys exist and are valid, click the [Check key against unique indexes] button. The dialog displays a message indicating whither the validation succeeded.
  4. To save your change, click the [OK] button.

Defining Transaction Behavrior

Transaction behavior defines how to handle updates to multiple tables. By default, each table is updated independently. In some cases, however, you may want to coordinate updates to multiple tables to ensure that data stays synchronized. To define transaction behavior you must add a Transaction Manager to the Data Pipe. To add a Transaction Manager:

  1. In the Workbench Menu bar, choose Insert > Transaction Manager.

    The Workbench adds a Transaction Manager to the resource.

  2. Drag the Transaction Manager onto the Data Pipe.
  3. Double-click on the Transaction Manager to open it,.

    The Workbench displays the Transaction Manager Properties dialog.

  4. If you need to maintain data integrity across multiple tables, but not necessarily the entire data set, select the One row at a time radio button.
  5. If you need to maintain data integrity across the complete data set, select the All rows together radio button.
  6. Click the [OK] button to save your changes.

Leave a comment