Insert Record activity

Display Name

Function:

Specifies the activity name that shows in your process.

Accepted Values:

One line of text that can have spaces.

Default Value:

None

Accepts Process Data Variables:

No

Description

Function:

Specifies an optional description for your activity.

Accepted Values:

More than one line of text.

Default Value:

None

Accepts Process Data Variables:

No

Database Type

Function:

Specifies the type of database to be used.

Accepted Values:

• SQL Server
• Oracle

Default Value:

SQL Server

Connection Timeout (Seconds)

Function:

Specifies the number of seconds permitted to complete an action before the connection stops.

Accepted Values:

An integer that represents a number of seconds.

Default Value:

600

Accepts Process Data Variables:

No

Database

Function:

Specifies the access token that connects to your database.

Accepted Values:

A list of access tokens configured for your environment.

Default Value:

None

Accepts Process Data Variables:

No

Add Token

Opens this Screen:

New Database Access Token

Function of this Screen:

Configures a new access token for a database.

Table Name

Function:

Specifies the name of the database table where this activity puts the record.

Accepted Values:

A valid database table name.

Default Value:

None

Accepts Process Data Variables:

Yes

Example:

Column Name

Function:

Specifies the name of the database column.

Accepted Values:

A valid database column name.

Default Value:

None

Accepts Process Data Variables:

No

Example:

CustomerName

Column Value

Function:

Specifies an XPath to a single node within the given repeating XPath.

Accepted Values:

A valid XPath.

Default Value:

None

Accepts Process Data Variables:

Yes

Example:

${/pd:AgilePoint/pd:Products/pd:ComponentName}

Create

Function:

Creates a row to add a process data variable, value, and event.

Delete

Function:

Deletes the selected item.