To insert multiple new database records into a database table, do the
following.
Navigation
- In AgilePoint Envision, open a process template.
- Navigate to the Database stencil.
- On the Database stencil, drag the
Batch Insert AgileShape, and drop it on the process template.
- To view the entire list of properties, in the Design Tasks pane, click Show Properties.
- On the InsertXMLRepeatingDescriptor field, click the Ellipses button.
Instructions
- To set up your database connection, on the Configuration for Inserting
Database Record window, complete the following field as required.
| Field Name |
Value |
Connection String
|
- Definition:
- Specifies the connection string that is used to connect to the database.
- Click
Choose to select a connection string from the list of
shared custom attributes (defined and managed in Enterprise Manager.)
- Click Create to
create a new connection string.
- Allowed Values:
- A valid SQL connection string.
- Default Value:
- server=myserver;database=pubs;trusted_Connection=yes
- Custom Attributes:
- Yes
- Example:
- server=DataServer;database=StoreDb;trusted_Connection=yes
|
- To insert the data in a database table, do one of the following.
- To insert the data into a table:
- Select Specific Table.
- On the Table Name field, click Browse.
- Select the database table name as required.
- In the Column & Data section, click Add.
- Complete the following fields as required.
| Field Name |
Value |
Column Name
|
- Definition:
- Specifies the name of the column in the database.
- Allowed Values:
- A valid column name from the particular table in the database.
- Default Value:
- None
- Custom Attributes:
- No
- Example:
- CustomerName
|
Value
|
- Definition:
- Specifies an XPath to a single node inside the given repeating Xpath.
- Allowed Values:
- A valid XPath.
- Default Value:
- None
- Custom Attributes:
- Yes
- Example:
- ${/pd:AgilePoint/pd:Products/pd:ComponentName}
|
- To use a stored procedure:
- Select Stored Procedure.
- Complete the following field as required.
| Field Name |
Value |
Stored Procedure
|
- Definition:
- Specifies the stored procedure name and parameters to execute at runtime.
- Allowed Values:
- A valid SQL stored procedure execute statement.
- Default Value:
- None
- Custom Attributes:
- Yes
- Example:
- EXECUTE [dbo].[InsertBillItem] @ItemName
|
- Complete any additional configuration for this AgileShape according to your requirements:
