Defining Database Insert Adapters

Defining this object instructs Clarify which database, tables, records, and columns to insert data into.

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 an Insert interaction. Click the Add button.
  5. Select the new Interaction, choose Insert 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:
    Insert Adapters allow you to configure the following behavior:
    • Settings - transaction boundaries (i,e. commit and rollback), selection mode.
  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. Auto Truncate (Version 1 only): check to enable; uncheck to disable.
      If the length of data for a column is longer than the column' maximum length, you can instruct the Adapter to truncate the data before the insert. For example, suppose you have a text column that is 50 characters long. If you are attempting to insert 60 characters of data for that column, you can have the Adapter truncate the data to 50 characters. If you do not enable AutoTruncate, the Adapter will fail to insert the record.
      Note: To truncate means to cut off an ending portion of the data. In the example above, if 60 characters are truncated to 50, the first 50 characters will be preserved; the last 10 will be cut off and not processed.
  10. Click Save to complete this task.