3rd party SQL integration

[ktorkels]

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?

[Craig Hyps · Accepted solution]

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

[hariholla]

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