topic Re: 3rd party SQL integration in Network Access Control

3rd party SQL integration

ktorkels — Tue, 23 Jan 2018 19:24:08 GMT

I have a customer that has a question about ISE & 3^rd party integrations - We would not be using ISE as a repository for MAC addresses. We would use our ITAM product Ivanti. That would require ISE to access an SQL database. A feature ISE competitors do have and we are wondering if this is possible with ISE.

https://www.ivanti.com/products/asset-manager

Does anyone have any feedback or thoughts on how to approach this design?

Re: 3rd party SQL integration

Craig Hyps — Tue, 23 Jan 2018 19:44:09 GMT

Thanks for using the Community!

Yes, ISE can integrate with external SQL servers via an ODBC interface for authentication/authorization. Today we have native "connectors" for

MySQL
Oracle
PostgreSQL
Sybase
Microsoft SQL

Regards,

Craig

Re: 3rd party SQL integration

hariholla — Tue, 23 Jan 2018 19:48:42 GMT

Here are some guides to help you with the integrations:

Configure ISE 2.2 for integration with MySQL server - Cisco

Configure ISE 2.1 with MS SQL using ODBC - Cisco

Configure ODBC on ISE 2.1 with PostgreSQL - Cisco

Configure ODBC on ISE 2.3 with Oracle Database - Cisco

~Hari