Users Guide

Table 51: Generic SQLDB (Primary Tab)
Parameter Description
Server Name Enter the hostname or IP address of the database server.
Port (Optional) Specify a port value if you want to override the default port.
Database Name Enter the name of the database to retrieve records from.
Login
Username/Password
Enter the name of the user used to log into the database. This account should
have read access to all the attributes that need to be retrieved by the specified
filters.
Enter the password for the user account entered in the field above.
Timeout Enter the time in seconds that Policy Manager waits before attempting to fail over
from primary to the backup servers (in the order in which they are configured).
ODBC Driver Select the ODBC driver (Postgres, Oracle,or MSSQL in this release) to connect to
database.
NOTE: MySQL is supported in versions 6.0 and newer. Aruba does not ship
MySQL drivers by default. If you require MySQL, contact Aruba support to get the
required patch. This patch does not persist across upgrades, so customers using
MySQL should contact support before they upgrade.
Attributes Tab
The Attributes tab defines the SQL DB query filters and the attributes to be fetched by using those filters.
Figure 80 Generic SQL DB(Attributes Tab)
Table 52: Generic SQL DB Attributes Tab (Filter List)
Tab Parameter/Description
Filter Name / Attribute Name /
Alias Name / Enabled As
Listing column descriptions:
l Filter Name: Name of the filter.
l Attribute Name: Name of the SQL DB attributes defined for this
filter.
l Alias Name: For each attribute name selected for the filter, you
can specify an alias name.
l Enabled As: Indicates whether the filter is enabled as a role or
attribute type. Note that this can also be blank.
Add More Filters Brings up the filter creation popup.
Configure Filter Popup
The Configure Filter popup defines a filter query and the related attributes to be fetched from the SQL DB store.
Dell Networking W-ClearPass Policy Manager 6.2 | User Guide 122