ISE and Oracle DB Integration

[Joshua Turner]

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.

[Francesco Molino]

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