Defining Database Delete Adapters

Defining this object instructs Clarify of the database, tables, records, and columns to delete data from.

If you have not already created this object, see Creating Database Adapters.

The following steps take place in the Database Adapter editor, which has these sections: Settings, Interactions, and Data Bindings

  1. Under the Settings section's Clarify Database Schema field, select the Database Schema.
    The Database Schema represents the list and structure of the tables and fields that will be selected from the Database. After selecting the Schema, a list of tables in the schema appears in the Data Bindings section. The tables in the schema may be organized hierarchically, but the Data Bindings section displays them as a flat list. You can expand each table to view its fields.
  2. In the Data Source field, select the Data Source.
    The Data Source represents the connection to the Database.
  3. The Data Bindings section is where associations between the tables in the Database Schema and the tables in the DataSource are created/maintained. For each table in the Schema, click Click to set Data Source Table. Select the appropriate table from the list of tables.
    Typically the name of the table in Schema is identical to the table in the Data Source. In some cases, however, a table with a different name will have an identical list of columns. As long as columns match between two tables, the Adapter will function successfully and select the data from the specified table.
  4. Under the Interactions section, define a Delete interaction. Click the Add button.
  5. Select the new Interaction, choose Delete from the interaction drop-down, and type a name for the interaction.
  6. Select and drag the desired tables from the Data Bindings section and drop them on the Interaction.
    Note: If you are not selecting all tables in the schema, you must ensure that when selecting a child table you also select the parent table.
    Note: If any of the entries in the Data Bindings section display Click to set Data Source Table, they will not be able to be dropped onto the Interaction.
  7. The Properties view displays and allows for specifying additional details.For the interaction itself:.
    1. Transaction Level
      • None: no commit or roll-back boundaries will be deployed
      • Full: all commit and roll-back boundaries will be deployed
    2. Select Mode
      • All records: Selects all the records in the table, filtered by Selection Criteria (i.e. Where clause information)
      • Related Records: For hierarchical Schemas, this selects only those records where the child records are joined to the parent records
  8. For a table within the Interaction:
    Delete Adapters allow you to configure the following behavior:
    • Settings: transaction boundaries (i.e. commit and rollback), selection mode.
    • Matches: defines the 'where' clause of an SQL statement (Delete x where y = ?)
  9. In the Settings tab:
    1. Transaction Level
      • None: no commit or roll-back boundaries will be deployed
      • Full: all commit and roll-back boundaries will be deployed
    2. Select Mode
      • All records: Selects all the records in the table, filtered by Selection Criteria (i.e. Where clause information)
      • Related Records: For hierarchical Schemas, this selects only those records where the child records are joined to the parent records
  10. Use the Matches tab to configure where the delete should occur. (Delete x where y = ?)
  11. Click Save to complete this task.