› Workflow › Business processes › Design a basic process › Add an activity › Activity types › Common activities › Data access activity › Add records to a database table

Add records to a database table

Create a database query to add records to a database table.

Before you begin
To use the Data access activity, you must create a process variable to hold the database connection string. For example, create a process variable, with the following settings:
  • ID = DBConnectionString
  • Type = String
  • Value = DSN=TotalAgility

Procedure
  1. On the properties panel of the Data access activity, select Configure.
    The Data access configuration - <Activity name> dialog box is displayed.
  2. You can select one of the following for Database connection.
    • Local (Default): Select the process or server variable to specify the database connection string that holds the details of the relational database.
    • External: To use the database connection from external storage, enter the secret name for the connection secret stored in the configured external storage.

    A list of schema that the database user has permission to access is displayed.

  3. On the Schema list, select a database schema to use for retrieving database objects.

    If no schema is selected, the system uses the default schema for the database user (typically dbo for SQL Server).

  4. On the Tables list, select the table to add records for. All columns within the selected table appear under Available columns.
  5. On the Record list, select Add.
  6. On the Available columns list, select the columns to add records to and select .
  7. Provide static or dynamic values for the selected columns.
  8. To insert multiple records in a table at runtime:

    In the Properties panel of the Table control > General tab, ensure the Multi-select and Add and modify properties are selected.

    1. On the Database query page, select the Perform multiple inserts option.
    2. Select either option:

      • Insert all rows: Inserts all rows for the selected columns.

      • Insert selected rows: Inserts selected rows for the selected columns.

      Multiple selection of rows is available only if you create a DB query action on forms.
    3. For information on selection criteria and the DB query outcome, see Insert multiple records into a database.
  9. On the Return rows affected to list, select the variable.
  10. Select OK.