02-08-2017 07:14 AM
I understand ISE 2.1 onwards we have capability to query external SQL Database of customer to fetch registered device information. Can some one please point me to corresponding document to share with the customer?
Solved! Go to Solution.
02-08-2017 01:06 PM
Follow this guide for MS SQL - Configure ISE 2.1 with MS SQL using ODBC - Cisco
And the one for PostgreSQL -Configure ODBC on ISE 2.1 with PostgreSQL - Cisco
The main takeaway is that you will need to create the stored procedures that match your db tables. The other is that the password checking must be done in clear text.
02-08-2017 01:06 PM
Follow this guide for MS SQL - Configure ISE 2.1 with MS SQL using ODBC - Cisco
And the one for PostgreSQL -Configure ODBC on ISE 2.1 with PostgreSQL - Cisco
The main takeaway is that you will need to create the stored procedures that match your db tables. The other is that the password checking must be done in clear text.
02-09-2017 11:43 PM
Thanks Jeffery. Appreciate your revert.
03-10-2017 08:22 AM
Is it possible to query a MAC Address that is contained in a CMDB accessible via ODBC query.
We did not find a way to pass MAC Address (Calling Station ID) received in Radius Packet to the stored procedure. Does this capability provide the generic ability to compare Radius Attributes from an authentication request.
03-10-2017 09:55 PM
Not a feature today. Please bring your use case to ISE product management team.
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide