Administrator Guide
184 | Preparing W-ClearPass for LDAP and SQLAuthenticationSources Dell Networking W-ClearPass Deployment Guide
SQL Authentication Source Configuration
This section includes the following information:
l Configuring a Generic SQL Authentication Source
l Defining a Filter Query
Configuring a Generic SQL Authentication Source
Policy Manager can perform MSCHAPv2 and PAP/GTC authentication against any Open Database Connectivity
(ODBC) compliant SQL database such as Microsoft SQL Server, Oracle, MySQL, or PostgrSQL.
l You can specify a stored procedure to query the relevant tables and retrieve role-mapping attributes by
using filters.
l You can configure the primary and backup servers, session details, filter query, and role mapping attributes
to fetch the generic SQL authentication sources.
To configure a generic SQL authentication source:
1. Navigate to Configuration > Authentication > Sources.
The Authentication Sources page opens.
2. Click Add.
The Authentication Sources > General page opens.
General Page
The General page labels the authentication source and defines session details.
Figure 151 General Page: Generic SQL Authentication Database
3. Enter the information for each of the required parameters as described in Table 35.