BPM5 Documentation - Writing a New Record to a Database Table

To write a new record to a database table, complete the following steps:

Check out and open the process you want to edit.
In the Toolbox pane, click Database. A list of activities is displayed.
Double-click or drag the Create Database Records activity into the process.
Link the activity appropriately with other activities.
Right-click the Create Database Records activity. A shortcut menu is displayed.
Select View Properties. The Create Database Records window is displayed.

Note:

You can also open or view the activity properties by double-clicking the activity in the process.
Click the Database and Table tab. The Database and Table to Add New Records To section is displayed.
In the Database field, click the System Resource icon. A drop-down list of the ODBC System Resources is displayed.
Select the relevant ODBC System Resource. The selected resource name is displayed in the field.

Note:

If your system resource contains a data item in the connection string property, click Configuration values and enter a valid connection string for design-time, configuration purposes.
In the Table field, select an editor and set the field to the name of the table in which you want to write a new record.

Note:

The default editor is the Table Selector Editor. This editor will display a list of tables available in the database.
Click the Data Mappings: Create Records tab. The corresponding screen is displayed.
Select either the automatic or manual option for mapping values to table columns.
Click OK. You configured the activity to write a new record to a database table.

Source
BPM Designer Topics > Overview of Activities and Activity Topics > Database Activities > Create Database Records

Last modified at 7/31/2020 12:08 PM

Writing a New Record to a Database Table // <![CDATA[ _spBodyOnLoadFunctionNames.push("setupPageDescriptionCallout"); // ]]>

Writing a New Record to a Database Table