topic Re: ISE capability to query SQL Database. in Network Access Control https://community.cisco.com/t5/network-access-control/ise-capability-to-query-sql-database/m-p/3487640#M536196 <HTML><HEAD></HEAD><BODY><P>Follow this guide for MS SQL - <A href="http://www.cisco.com/c/en/us/support/docs/security/identity-services-engine-21/200544-Configure-ISE-2-1-with-MS-SQL-using-ODBC.html" title="http://www.cisco.com/c/en/us/support/docs/security/identity-services-engine-21/200544-Configure-ISE-2-1-with-MS-SQL-using-ODBC.html">Configure ISE 2.1 with MS SQL using ODBC - Cisco</A></P><P>And the one for PostgreSQL -<A href="http://www.cisco.com/c/en/us/support/docs/security/identity-services-engine-21/200644-Configure-ODBC-on-ISE-2-1-with-PostgreSQ.html" title="http://www.cisco.com/c/en/us/support/docs/security/identity-services-engine-21/200644-Configure-ODBC-on-ISE-2-1-with-PostgreSQ.html">Configure ODBC on ISE 2.1 with PostgreSQL - Cisco</A></P><P></P><P>The main takeaway is that you will need to create the stored procedures that match your db tables.&nbsp; The other is that the password checking must be done in clear text.</P></BODY></HTML> Wed, 08 Feb 2017 21:06:43 GMT jgriesel 2017-02-08T21:06:43Z ISE capability to query SQL Database. https://community.cisco.com/t5/network-access-control/ise-capability-to-query-sql-database/m-p/3487639#M536194 <HTML><HEAD></HEAD><BODY><P>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?</P></BODY></HTML> Wed, 08 Feb 2017 15:14:24 GMT https://community.cisco.com/t5/network-access-control/ise-capability-to-query-sql-database/m-p/3487639#M536194 Dhanesh 2017-02-08T15:14:24Z Re: ISE capability to query SQL Database. https://community.cisco.com/t5/network-access-control/ise-capability-to-query-sql-database/m-p/3487640#M536196 <HTML><HEAD></HEAD><BODY><P>Follow this guide for MS SQL - <A href="http://www.cisco.com/c/en/us/support/docs/security/identity-services-engine-21/200544-Configure-ISE-2-1-with-MS-SQL-using-ODBC.html" title="http://www.cisco.com/c/en/us/support/docs/security/identity-services-engine-21/200544-Configure-ISE-2-1-with-MS-SQL-using-ODBC.html">Configure ISE 2.1 with MS SQL using ODBC - Cisco</A></P><P>And the one for PostgreSQL -<A href="http://www.cisco.com/c/en/us/support/docs/security/identity-services-engine-21/200644-Configure-ODBC-on-ISE-2-1-with-PostgreSQ.html" title="http://www.cisco.com/c/en/us/support/docs/security/identity-services-engine-21/200644-Configure-ODBC-on-ISE-2-1-with-PostgreSQ.html">Configure ODBC on ISE 2.1 with PostgreSQL - Cisco</A></P><P></P><P>The main takeaway is that you will need to create the stored procedures that match your db tables.&nbsp; The other is that the password checking must be done in clear text.</P></BODY></HTML> Wed, 08 Feb 2017 21:06:43 GMT https://community.cisco.com/t5/network-access-control/ise-capability-to-query-sql-database/m-p/3487640#M536196 jgriesel 2017-02-08T21:06:43Z Re: ISE capability to query SQL Database. https://community.cisco.com/t5/network-access-control/ise-capability-to-query-sql-database/m-p/3487641#M536197 <HTML><HEAD></HEAD><BODY><P>Thanks Jeffery. Appreciate your revert.</P></BODY></HTML> Fri, 10 Feb 2017 07:43:13 GMT https://community.cisco.com/t5/network-access-control/ise-capability-to-query-sql-database/m-p/3487641#M536197 Dhanesh 2017-02-10T07:43:13Z Re: ISE capability to query SQL Database. https://community.cisco.com/t5/network-access-control/ise-capability-to-query-sql-database/m-p/3487642#M536198 <HTML><HEAD></HEAD><BODY><P>Is it possible to query a MAC Address that is contained in a CMDB accessible via ODBC query.</P><P></P><P>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.</P></BODY></HTML> Fri, 10 Mar 2017 16:22:43 GMT https://community.cisco.com/t5/network-access-control/ise-capability-to-query-sql-database/m-p/3487642#M536198 nved 2017-03-10T16:22:43Z Re: ISE capability to query SQL Database. https://community.cisco.com/t5/network-access-control/ise-capability-to-query-sql-database/m-p/3487643#M536199 <HTML><HEAD></HEAD><BODY><P>Not a feature today. Please bring your use case to ISE product management team.</P></BODY></HTML> Sat, 11 Mar 2017 05:55:57 GMT https://community.cisco.com/t5/network-access-control/ise-capability-to-query-sql-database/m-p/3487643#M536199 hslai 2017-03-11T05:55:57Z