Users Guide

123 Dell Networking W-ClearPass Policy Manager 6.2 | User Guide
Figure 81 Generic SQL DB Filter Configure Popup
Table 53: Generic SQL DBConfigure Filter Popup
Parameter Description
Filter Name Name of the filter
Filter Query A SQL query to fetch the attributes from the user or device record in DB
Name / Alias
Name / Data
Type/ Enabled
As
Name: This is the name of the attribute
Alias Name: A friendly name for the attribute. By default, this is the same as the
attribute name.
Data Type: Specify the data type for this attribute, such as String, Integer, Boolean,
etc.
Enabled As: Specify whether this value is to be used directly as a role or attribute in
an Enforcement Policy. This bypasses the step of having to assign a role in Policy
Manager through a Role Mapping Policy.
HTTP
The HTTP authentication source relies on the GET method to retrieve information. The client submits a request, and
then the server returns a response. All request parameters are included in the URL. For example:
URL: https//hostname/webservice/…/%{Auth:Username}?param1=%{…}&param2=value2
HTTP relies on the assumption that the connection between the client and server computers is secure and can be
trusted.
You configure primary and backup servers, session details, and the filter query and role mapping attributes to fetch of
Generic SQL authentication sources on the following tab:
l General Tab
l Primary Tab
l Attributes Tab
General Tab
The General tab labels the authentication source and defines session details, authorization sources, and backup server
details.