Put More than One Record into a Database Table

Batch Insert > Specific Table Screen

Good to Know

• In most text fields, you can use process data variables as an alternative to literal data values.

How to Start

1. On the Organizer, do one of these:
   • Open a process.
   • Create a process.
2. Do one of these:
   • Add an activity:
     1. In the Process Builder, go to the Activity Library, and open the Database tab.
     2. On the Database tab, drag the Batch Insert activity onto your process.
   • Change an activity:
     1. In your process, double-click your activity.
3. Click Batch Insert .

Procedure

1. To put the data in a database table, do one of these.
   • To put the data into a specified table:
     1. On the Batch Insert screen, in the Specific Table tab, in the Database list, select your database access token.

        To create a new access token, click Add Token . For more information, refer to New Database Access Token.

     2. In the Repeating Node field,enter an Xpath that specifies the root of a repeating element in a schema where all the data is stored.
     3. In the Table Name list, select your database table.
     4. (Optional) Complete these fields as necessary:

        Field Name	Definition
        Remove All Old Records	Function: Removes all the old records from the database. Accepted Values: Selected - Enables the remove all old records option. Deselected - Removes the record that satisfy the specified condition. Default Value: Deselected
        Before insert, remove records that meets following conditions	Function: Removes the records from the database that satisfies the specified condition. This remove operation is performed before the insert operation. Accepted Values: A valid SQL condition after WHERE clause. Default Value: None Accepts Process Data Variables: No

     5. In the Column Name field, enter the name of the column to put the data.
     6. In the Value field, enter your value, or drag a process data variable from the Process Data screen.
     7. (Optional) Click Create to add a new row to add a variable or value.
   • To insert the data with a stored procedure:
     1. On the Batch Insert screen, click Stored Procedure tab.
     2. On the Stored Procedure tab in the Database list, select your database access token.

        To create a new access token, click Add Token . For more information, refer to New Database Access Token.

     3. In the Repeating Node field,enter an Xpath that specifies the root of a repeating element in a schema where all the data is stored.
     4. In the Stored Procedure field, select your stored procedure.
     5. In the Value/Attr. Name field, enter the value of the stored procedure parameter, or drag a process data variable from the Process Data screen.
     6. To specify the input and output options for the stored procedure, complete this field as necessary.

        Field Name

        Definition

        in/out.

        Function: Specifies the in/out parameters for the stored procedure. Accepted Values: Input - Specifies that the parameter is an input value for the stored procedure. Output - Specifies that the parameter is an output value for the stored procedure. InputOuput - Specifies that the parameter can be input/output value for the stored procedure. ReturnValue - Specifies that the parameter is a return value for the stored procedure. Default Value: None Accepts Process Data Variables: No

     7. In the Data Type list, select the data type of the stored procedure parameter.
     8. In the Size field, enter the size of the input parameter for the stored procedure.