Edit Event Service Screen > Configuration Tab > Database Insert Screen

Changes the configuration for a database insert event service.



Good to Know

How to Start

  1. In the Manage Center, click System > Events Service.
  2. On the Events Service Screen, click Expand for your event service.
  3. Click Edit .
  4. Click the Configuration tab.

Fields

Field Name Definition

Database Type

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

Connection String

Function:
Specifies the connection string to connect to the database.
Accepted Values:
  • Choose an existing Connection String - Specifies a current database connection string.
  • New Connection String - Specifies the a new database connection string.
Default Value:
New Connection String

Build Connection String

Function:
Creates a connection string to connect AgilePoint event services and a database.

Data Source

Function:
Specifies the database server name, where SQL Server has been installed.
To Open this Field:
  1. Click Build Connection String button.
Accepted Values:
A valid database server name.
Default Value:
None

User ID

Function:
Specifies the user name for database authentication.
To Open this Field:
  1. Click Build Connection String button.
Accepted Values:
A valid user name.
Default Value:
None

Password

Function:
The password for the authentication account.
To Open this Field:
  1. Click Build Connection String button.
Accepted Values:
A valid password.
Default Value:
None

Port

Function:
Specifies the port number to connect to the database server.
To Open this Field:
  1. Click Build Connection String button.
Accepted Values:
  • A valid port number.
Default Value:
None

SSPI (Integrated Security)

Function:
Determines whether the SSPI integrated security is to be activated.
To Open this Field:
  1. Click Build Connection String button.
Accepted Values:
  • Deselected - Specifies not to activate the SSPI integrated security.
  • Selected - Specifies to activate the SSPI integrated security.

Name

Function:
Specifies the name of the your database.
To Open this Field:
  1. Click Build Connection String button.
Accepted Values:
The name of your database.
Default Value:
None

Cancel

Function:
Cancels the configuration of database connection string.
To Open this Field:
  1. Click Build Connection String button.

Table Name

Function:
Specifies the name of the your database table.
Accepted Values:
The name of your table.
Default Value:
None

Primary Key

Function:
Specifies the primary key for the database table.
Accepted Values:
The name of your primary key.
Default Value:
None

Query Frequency

Function:
Specifies the query frequency in minutes.
Accepted Values:
An integer.
Default Value:
None

Column Name

Function:
Specifies the name of the database column.
Accepted Values:
A valid database column name.
Default Value:
None

Enable Database Insert Event

Function:
Determines whether the database insert trigger is to be activated.
Accepted Values:
  • Deselected - Deactivates the database insert trigger.
  • Selected - Activates the database insert trigger.
Default Value:
Deselected

Update

Function:
Changes the information of database insert event.