Users Guide
222 | Authentication Methods and Sources Dell Networking W-ClearPass Policy Manager 6.6 | User Guide
Generic SQL DB
Configure the primary and backup servers, session details, filter query, and role-mapping attributes to fetch the
Generic SQL authentication sources on the following tabs:
l General Tab on page 222
l Primary Tab on page 224
l Attributes Tab on page 225
l Summary Tab on page 227
W-ClearPass 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.
Specify a stored procedure to query the relevant tables and retrieve role-mapping attributes by using filters.
General Tab
Navigate to the Configuration > Authentication > Sources, then click Add.
The General tab labels the authentication source and defines session details, authorization sources, and
backup server details.
Figure 179: Add Generic SQLDB > General Tab