Specifies the configuration of the databases AgilePoint Server uses to store data. AgilePoint
Server uses two possible databases:
- Workflow database - Stores data for processes that are in current use.
- Archive database - Stores a backup of the workflow data, as well as
the data for processes that have been archived.
How to Start
- On the AgilePoint Server machine, click
Start > All Programs >
AgilePoint > AgilePoint Configuration.
- On the
AgilePoint Server Configuration Tool
window, click the
Database tab.
Fields
| Field Name |
Definition |
Main Database Tab
|
- Action:
- Specifies the connection to the AgilePoint workflow database to store the data.
|
Archive Database Tab
|
- Action:
- Specifies the connection to the Archive database
to store backup of the workflow data and archived process data.
|
Database Type
|
- Definition:
- Specifies the database technology you are using
to store AgilePoint data.
- Allowed Values:
-
- Microsoft SQL Server
- Oracle
- Default Value:
- Microsoft SQL Server
|
Encrypt Database Setting
|
- Definition:
- Specifies whether to encrypt your stored database settings.
- Allowed Values:
-
- Selected - Saves the database settings in encrypted format.
- Deselected - Saves the database settings in plain text.
- Default Value:
- Deselected
|
User
|
- Definition:
- The user name for the database account AgilePoint Server uses
to connect to the database.
- Allowed Values:
- A valid user name for the database.
- Default Value:
- sa
|
Password
|
- Definition:
- The password for the authentication account.
- Allowed Values:
- A valid password.
- Default Value:
- None
|
Integrated Security
|
- Definition:
- When integrated security is selected, the current windows account credentials are used for authentication.
- To Access This Field:
-
- In the Database Type list, select Microsoft SQL Server.
- Allowed Values:
- Selected - The windows account credentials are used for authentication automatically.
- Deselected - The user and password fields are enabled for database authentication.
- Default Value:
- Selected
|
Database Server
|
- Definition:
- Specifies the server name and domain for your database.
- Allowed Values:
- A valid database server name.
- Default Value:
- None
|
Database Name
|
- Definition:
- Specifies the name of your database.
- To Access This Field:
-
- Click Ellipses to populate the database names from the database server.
- Allowed Values:
- A valid database name.
- Default Value:
- None
|
Service Name
|
- Definition:
- Specifies the Oracle database service name.
- To Access This Field:
-
- In the Database Type list, select Oracle.
- Allowed Values:
- A valid service name.
- Default Value:
- None
|
Connection Pool Size
|
- Definition:
- Specifies the maximum number of simultaneous database connections for the workflow database.
- To Access This Field:
-
- Click the Main Database tab.
- Allowed Values:
- Any integer.
It is recommended to use a connection pool size that is >= 100, or 2 * the thread pool size.
- Default Value:
- 100
|
Archive Completed Process In
|
- Definition:
- Specifies the minimum number of days to save completed or canceled processes before archiving.
- To Access This Field:
-
- Click the Archive Database tab.
- Allowed Values:
- Any integer, representing a number of days.
If you set this value to 0, archiving does not occur.
- Default Value:
- 180
|
