Database Configuration screen

Synchronizes users and groups for a tenant with the user information resulting from a database query.

Figure: Database Configuration screen

Database Configuration screen

Prerequisites

  • To access this screen, you must have a multi-tenant environment.

How to Start

  1. On the AgilePoint Server machine, in Windows Explorer, right-click the file (AgilePoint Server installation folder) C:\Program Files\AgilePoint\AgilePoint Server \WCFConfigurationUtility.exe, and click Run as Administrator.
  2. On the AgilePoint Server Manager screen, in the left pane, select your AgilePoint Server instance.
  3. Click Open Server Configuration Open Server Configuration icon.
  4. On the AgilePoint Configuration screen, click the Extensions tab.
  5. On the Extensions tab, select DBSyncModule.
  6. Click Configure.
  7. On the Configuration for Database Groups/Users Synchronization screen, in the Multi-Tenant Database Information section, click Configure.

Fields

Field Name Definition

Tenant

Function:
Specifies the tenant name.
Accepted Values:
List of your enabled tenant names.
Default Value:
None

Connection String

Function:
Specifies the connection string to be used to connect to the database.
Accepted Values:
A valid connection string.
Default Value:
server=localhost;database=pubs;trusted_Connection=yes
Accepts Process Data Variables:
Yes
Example:
server=DataServer;database=StoreDb;trusted_Connection=yes
Query
Function:

The SQL query used to fetch the records from the database.

Accepted Values:

A valid SQL query.

The query must fetch the following fields, which are mandatory:
  • TITLE
  • USER_NAME
  • FULL_NAME
  • DEPARTMENT
  • EMAIL_ADDRESS
  • MANAGER
  • GROUP_NAME

Add

Function:
Creates a row where you can specify your tenant name, connection string and query.

Verify

Function:
Verifies whether the specified query and connection string are valid.

Update

Function:
Updates the selected row from the database configuration list.

Remove (-)

Function:
Deletes the selected row from the database configuration list.

Edit ()

Function:
Modifies the selected row from the database configuration list.

Delete ()

Function:
Deletes all rows from the database configuration list.