cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Announcements
Announcements
Choose one of the topics below to view our ISE Resources to help you on your journey with ISE

This community is for technical, feature, configuration and deployment questions.
For production deployment issues, please contact the TAC! We will not comment or assist with your TAC case in these forums.
Please see How to Ask the Community for Help for other best practices.

244
Views
1
Helpful
4
Replies
Beginner

External DB integration push the parameter to ISE

Can I Assign VLAN to the user using external DB, What I wish to do, there will be an APP who will store user ID and the required VLAN in DB, which will be changed based user assigned to the project or to share the resource scenario, he can choose the project allocation. The app DB will interact with ISE to push the VLAN id/name to appropriate port.Any help is it possible.

Everyone's tags (4)
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Beginner

Re: External DB integration push the parameter to ISE

Thanks Howon, this is helpful. let me try with ISE 2.1

View solution in original post

4 REPLIES 4
Highlighted
Cisco Employee

Re: External DB integration push the parameter to ISE

Yes, here is an example using AD attribute:

Dynamic Attribute with ISE: VLAN Assignment

Highlighted
Beginner

Re: External DB integration push the parameter to ISE

Thanks Howon for your response. However, I have an application who decides the VLAN dynamically and it has the DB. I Wish to sync the VLAN field from this database instead of Active directory attribute. SO the above solution is not to my help. Is there anyway I Can federate my application or DB with ISE that will influence the VLAN attribute for the user.

Highlighted
Cisco Employee

Re: External DB integration push the parameter to ISE

Mahesh, ISE 2.1+ also supports SQL DB as identity source and you can do the same outlined in the link above for SQL as well. You can reference following document for creating DB and stored procedures for ISE/SQL integration:

Configure ISE 2.1 with MS SQL using ODBC - Cisco

Highlighted
Beginner

Re: External DB integration push the parameter to ISE

Thanks Howon, this is helpful. let me try with ISE 2.1

View solution in original post