Configure domain users and groups to work with the SQL Repository

To use users and groups from your domain with your SQL Repository, run the Configure Anaplan XL Web Edition application. Then select the SQL Repository tab. By default, the Domain box will automatically be populated with the name of the local Domain, but it supports several formats.

Domain name

For example, example.com

Load all the users and groups in the given domain

Localhost

Load all the users and groups from the host machine

A semi-colon, delimited list of LDAP queries

For example:  LDAP://OU=Development,DC=somecom,DC=com; LDAP://OU=Consultants,DC=somecom,DC=com

Allows you to load users and groups from the domain, but limits the import to the given Organization Units, etc.

A semi-colon, delimited list of global catalog queries

For example:  GC://OU=Development,DC=somecom,DC=com; GC://OU=Consultants,DC=somecom,DC=com

If your domain supports it, this may be faster than the corresponding LDAP queries

Group filtering, for example

For example:  LDAP://DC=somecom,DC=com~(cn=group)

When using LDAP or GC queries, you may also filter the groups returned by using this form, where group can be a full group name or a wildcard (e.g. Sales*)

Automatically keeping the Domain information up to date 

Once this has been configured, the Anaplan XL Scheduling Service can be used to keep the Domain information up to date regularly. To set this:

  1. Run the Configure Anaplan XL Web Edition application.
  2. Select the Scheduling tab.
  3. Select the Schedule domain update box, and enter how often you want to update the domain information.
  4. The update will occur at midnight, server time.

Note that the Anaplan XL Scheduling Service must be set up correctly in order for this to succeed.

Manually running the Domain import process 

The Scheduling Service domain import process can be triggered manually by passing an extra command line parameter:

C:\inetpub\wwwroot\AnaplanXLWeb\Scheduler\AnaplanXL.Scheduling.Service.exe /UPDATEDOMAIN

This allows it to be called manually or via an automated process, for example Task Scheduler. The user running the process must be a member of the XLCUBED_ADMIN role.

Viewing the Domain import logs 

To see the progress of an individual Domain import or to see whether errors occurred on a previous occasion, run the Configure Anaplan XL Web Edition application, then select the SQL Repository tab. Select the Administration button, then select the Admin > Logs > Active Directory menu.