Enabling the Extension

To enable the AgilePoint Server extension:

1. Open the AgilePoint Server Configuration utility and go to the Extension window.
2. Click the Ellipses button next to the Assembly field and add the following assembly:

   …\AgilePointServer\bin\DBSyncModule.dll

3. Leave the Impersonator field blank.
4. Click OK. Now you will need to configure the module to schedule the synchronization.
5. Click the Configure button, and specify the desired configuration settings.

   In the configuration interface, specify the following information:

   • Connection - Provide a valid database connection string.
   • Query - Provide the SQL query to fetch records from a table. The query must fetch the following fields, which are mandatory:
     • TITLE
     • USER_NAME
     • FULL_NAME
     • DEPARTMENT
     • EMAIL_ADDRESS
     • MANAGER
     • GROUP_NAME

     To check that the query was set up correctly, click Verify Query.

   • Schedule - Specify the synchronization with the frequency of every day, week, or month and at a particular time of day starting with the day you set the schedule.
   • Option - This section provides an option to select what action needs to be taken when a database member is not an AgilePoint user. Either one can select to register user to AgilePoint automatically or send a notification to AgilePoint System user.