cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
1265
Views
0
Helpful
1
Replies

ISE and Oracle DB Integration

Joshua Turner
Cisco Employee
Cisco Employee

I have a customer who has an inventory control system that is based on Oracle DB. In this DB, there is a list of MAC addresses that are approved for access to their network.  What they want is a script that will pull the MAC addresses and push those into ISE internal users and also have the script or ISE do a diff to see if there has been any change such as add or remove of MAC addresses. We have this somewhat working. The issue is that they want the script to reside on ISE and not on the Oracle DB or another stand alone VM. Is there another way to accomplish this task via PXgrid maybe? Thanks for any support or guidance.

1 Reply 1

Francesco Molino
VIP Alumni
VIP Alumni
Hi

You'll need to do a script using ise APIs and it has to be stored on a dedicated machine.
Just for my information.
You have a database that has all information, why would you want to import them into a endpoint group within ise?
I mean you can do odbc integration from ise to oracle db and you can use this info to authenticate the devices.
You have some examples with oracle and MySQL on Cisco you can use and adapt:
https://www.cisco.com/c/en/us/support/docs/security/identity-services-engine/211581-Configure-ODBC-on-ISE-2-3-with-Oracle-Da.html

https://www.cisco.com/c/en/us/support/docs/security/identity-services-engine-22/210521-Configure-ISE-2-2-for-integration-with-M.html

Thanks
Francesco
PS: Please don't forget to rate and select as validated answer if this answered your question