WLC integration with ISE

[rafsanmack80]

I am trying to integrate wlc with ISE. and I want to create a local database in ISE where every users information will be stored.such as,name,I'd card number, department name,date of birth.when a user try to use internet,the captive portal will require ,user name ,id, department and date of birth.when it matches with the ise database ,then otp will generate.but if it do not match with any information then , the user will not able to use internet.is this possible in ISE?

[Colby LeMaire]

This is not possible with ISE.  While you can create users within ISE and even setup custom fields for the user information, ISE would not be able to match on these fields and then generate a guest account/password.  With the guest flow, the captive portal collects information from the user and then generates an account to be used but there is no matching against an existing database of information.

I am having a hard time understanding why you would want to handle access in this way.  ISE offers many different options for employee or guest access.  Including the ability to have someone approve their request before an account is generated.  Or allow self-registration and automatic approval as long as they use a corporate e-mail address in their registration.

[rafsanmack80]

What if I have exrarnal MySQL database where I have all these information,then is it possible to integrate with ISE?

[Anurag Sharma]

Hi @rafsanmack80 ,

ISE cannot integrate with MySQL database.

It can integrate with the following stores:

AD

LDAP

ODBC

Radius token server

RSA SecurID

SAML Id providers

Social Login

HTH

Please 'RATE' and 'MARK ACCEPTED', if applicable.

[Jason Kunst]

---

@Anurag Sharma wrote:

Hi @rafsanmack80 ,

ISE cannot integrate with MySQL database.

It can integrate with the following stores:

AD

LDAP

ODBC

Radius token server

RSA SecurID

SAML Id providers

Social Login

HTH

Please 'RATE' and 'MARK ACCEPTED', if applicable.

---

This is correct, i am the TME on ISE Guest from the BU and there is no way to match from portal page to external source or an internal database of sorts. We also don't support cross site scripting. 

Please reach out to http://cs.co/ise-feedback and reach out product managers with very detailed request and reference this thread as well

[rafsanmack80]

Hello, @Jason Kunst @Anurag Sharma @Colby LeMaire, 

Actually i am on a project where client expressed these requirement. Thanks for your prompt response. :)

[Colby LeMaire]

Technically, ODBC is what you would use to connect to MySQL or other external database systems.  But that still doesn't solve the original request.