New Database Access Token

Configures a new access token for a database.



How to Start

  1. On the Organizer, do one of these:
  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 activity onto your process.
    • Change an activity:
      1. In your process, double-click your activity.
  3. Click Next.
  4. On the Database field, click Add Token .

Fields

Field Name Definition

Token Name

Function:
Specifies the unique name for your connection to the Database.
Accepted Values:
A string that can include letters, numbers, and spaces.
Default Value:
None

Description

Function:
A description for your access token.
Accepted Values:
More than one line of text.
Default Value:
None

Database Type

Function:
Specifies the database technology to store your data.
Accepted Values:
  • SQL Server
  • MySQL
  • Oracle
Default Value:
None

Database Server Name

Function:
Specifies the database server name, where your database is installed.
Accepted Values:
A valid database server name.
Default Value:
None
Accepts Process Data Variables:
No

Database Name

Function:
Specifies the name of your database.
Accepted Values:
The name of your database.

If you select the Enter Database Name check box, the Database Name list becomes unavailable to select a database name. Type a database name in the box.

Default Value:
None

Port

Function:
Specifies the port number to connect to the database server.
Accepted Values:
A valid port number.
Default Value:
None
Accepts Process Data Variables:
No

Timeout(seconds)

Function:
Specifies the maximum time to connect to the database.
Accepted Values:
An integer.
Default Value:
600

SSPI (Integrated Security)

Function:
Determines whether the SSPI integrated security is to be activated.
Accepted Values:
  • Deselected - Specifies not to activate the SSPI integrated security.
  • Selected - Specifies to activate the SSPI integrated security.
Default Value:
Deselected

Database Server User Name

Function:
Specifies the user name for database authentication.
Accepted Values:
A valid user name.
Default Value:
None
Accepts Process Data Variables:
No

Password

Function:
The password for the authentication account.
Accepted Values:
A valid password.
Default Value:
None
Accepts Process Data Variables:
No

Test Connection

Function:
Makes sure the specified database account is correct.

Encrypt

Function:
Holds the access token in the AgilePoint database as encrypted data.
Accepted Values:
  • Deselected - The access token is in plain text in the database.
  • Selected - The access token is encrypted in the database.
Default Value:
Deselected

RelatedTopics