Use domain users and groups with the SQL repository

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 application. Then select the SQL Repository tab.

With a Role-based repository, Anaplan XL Web will connect to the domain controller when a user connects to the website. Then authenticates the user and retrieves the current list of groups for that user.

Roles can be created in the Configure Anaplan XL Web Reporting application on the server that contains domain users and groups. When multiple Roles apply to a user, the role with the highest permissions will take effect.

These Roles can then be assigned permissions on reports, folders, and operations such as administration, scheduling, and commenting. This can be done through the Configure Anaplan XL Web application or via the Admin menu on the website if the user has permission.

In this mode, Anaplan XL Web refers to the domain user and group information in its SQL Repository database. Updates to this domain information must be made manually through the Configure Anaplan XL Web Load Domain Information dialog.

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*)

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.