Database Configuration Window

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

Prerequisites

On the AgilePoint Server machine, in Windows Explorer, right-click the file [AgilePoint Server installation folder]\WCFConfigurationUtility.exe, and click Run as Administrator.
On the AgilePoint Server Manager screen, in the left pane, select your AgilePoint Server instance.
Click Open Server Configuration .
On the AgilePoint Configuration screen, click the Extensions tab.
On the Extensions tab, select DBSyncModule.
Click Configure.
On the Configuration for Database Groups/Users Synchronization screen, in the Multi-Tenant Database Information section, click Configure.

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.