Add New Event Service Screen > Database Insert Screen

Starts a process when a new table row is added to a database.

Figure: Add New Event Service > Database Insert screen

Add New Event Service Database Insert screen

Good to Know

  • This feature is not available for AgilePoint OnDemand.
  • The Event Service AgileConnector must be added via the AgilePoint Server Configuration utility before using the Event Service.
  • As a best practice it is recommended to use a separate database table that is used for the Database Update monitoring, this is because once the new database update process is triggered, the new database table row and records will be deleted.

How to Start

  1. In the Manage Center, click System System icon > Events Service.

    Open Event Service screen
  2. On the Events Service screen, click Add Event Service Add Event Service icon
  3. On the Add New Event Service Screen > Select Type of Event Service, select Database Insert.
  4. Click Next.
  5. On the Add New Event Service screen, complete the fields ​as necessary.
  6. Click Next.

Fields

Field NameDefinition

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 authenticate 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:
An alphanumeric string that represents a 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

Done

Function:
Saves the configuration of the database insert event.