Specifies where and how to insert the new database records into the database.
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.
Field Definitions
| Field Name |
Definition |
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
|
Create
|
- Opens the Following Window:
- Database Connection Configuration Window
- Purpose of this Window:
- Creates a connection string with specified information.
|
Choose
|
- Opens the Following Window:
- Browse Custom Attributes Window
- Purpose of this Window:
- Specifies a connection string from a list of shared custom attributes.
|
RepeatingXPath
|
- Definition:
- Specifies an XPath to a root of repeating element in a schema where all the data are stored.
These data will be inserted into the database during insert operation.
- Allowed Values:
- A valid XPath to a repeating xml node.
- Default Value:
- None
- Custom Attributes:
- Yes
- Example:
- /pd:myFields/pd:PersonalDetails
|
Specific Table / Stored Procedure
|
- Definition:
- Specifies whether to insert the data into a specified table, or using a
stored procedure.
- Allowed Values:
-
- Specific Table - Inserts the data into a specified database table.
- Stored Procedure - Inserts the data using a stored procedure.
- Default Value:
- Specific Table
|
Table Name
|
- Definition:
- Specifies the name of the database table where this AgileShape inserts
the record.
- Allowed Values:
- A valid database table name.
- Default Value:
- None
- Custom Attributes:
- Yes
|
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
|
Browse
|
- Function:
- Enables you to find the associated item.
- Purpose of this Window:
- Specifies a particular database table from the database.
|
Remove all old records
|
- Definition:
- Removes all the old records from the database.
- Allowed Values:
- Selected - Enables the remove all old records option.
- Deselected - Removes the record which satisfies the specified condition.
- Default Value:
- Selected
|
Before insert, remove records that meets following condition
|
- Definition:
- Removes the records from the database that satisfies the specified condition.
This remove operation is performed before insert operation.
- Allowed Values:
- A valid SQL condition after WHERE clause.
- Default Value:
- None
- Custom Attributes:
- No
|
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}
|
Add
|
- Function:
- Creates new mapping to a database table column from the schema.
|
Remove
|
- Function:
- Removes the mapping from the database table column.
|
