Cisco Cisco Identity Services Engine 2.1 Manuel Technique

ISE authentication to ODBC uses stored procedures. It is possible to select type of procedures. In
this example we use parameters as return. For other procedures, refer to 

Tip: It is possible to return named parameters instead of resultset. It is just a different type of
output, functionality is the same.

1. Create the table. Make sure you set the identity settings on the primary key

2. Run this query to insert one user

Or

And learn and store generated UUID of a new user with this query

3. Create a procedure for plain text password authentication (used for PAP, EAP-GTC inner
method, TACACS)

4. Create a procedure for plain text password fetching (used for CHAP, MSCHAPv1/v2, EAP-MD5,
LEAP, EAP-MSCHAPv2 inner method, TACACS)

5. Create a procedure for check username or machine exists (used for MAB, fast reconnect of
PEAP, EAP-FAST and EAP-TTLS)

6. Configure procedures on ISE and save

7. Create a simple authentication rule using ODBC and test it