topic Re: External DB integration push the parameter to ISE in Network Access Control https://community.cisco.com/t5/network-access-control/external-db-integration-push-the-parameter-to-ise/m-p/3526388#M526661 <HTML><HEAD></HEAD><BODY><P>Yes, here is an example using AD attribute:</P><P><A href="https://community.cisco.com/docs/DOC-74212">Dynamic Attribute with ISE: VLAN Assignment</A></P></BODY></HTML> Fri, 15 Sep 2017 23:22:29 GMT howon 2017-09-15T23:22:29Z External DB integration push the parameter to ISE https://community.cisco.com/t5/network-access-control/external-db-integration-push-the-parameter-to-ise/m-p/3526387#M526659 <HTML><HEAD></HEAD><BODY><P>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.</P></BODY></HTML> Fri, 15 Sep 2017 06:03:40 GMT https://community.cisco.com/t5/network-access-control/external-db-integration-push-the-parameter-to-ise/m-p/3526387#M526659 maheshpathak 2017-09-15T06:03:40Z Re: External DB integration push the parameter to ISE https://community.cisco.com/t5/network-access-control/external-db-integration-push-the-parameter-to-ise/m-p/3526388#M526661 <HTML><HEAD></HEAD><BODY><P>Yes, here is an example using AD attribute:</P><P><A href="https://community.cisco.com/docs/DOC-74212">Dynamic Attribute with ISE: VLAN Assignment</A></P></BODY></HTML> Fri, 15 Sep 2017 23:22:29 GMT https://community.cisco.com/t5/network-access-control/external-db-integration-push-the-parameter-to-ise/m-p/3526388#M526661 howon 2017-09-15T23:22:29Z Re: External DB integration push the parameter to ISE https://community.cisco.com/t5/network-access-control/external-db-integration-push-the-parameter-to-ise/m-p/3526389#M526664 <HTML><HEAD></HEAD><BODY><P>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. </P></BODY></HTML> Tue, 19 Sep 2017 05:56:17 GMT https://community.cisco.com/t5/network-access-control/external-db-integration-push-the-parameter-to-ise/m-p/3526389#M526664 maheshpathak 2017-09-19T05:56:17Z Re: External DB integration push the parameter to ISE https://community.cisco.com/t5/network-access-control/external-db-integration-push-the-parameter-to-ise/m-p/3526390#M526669 <HTML><HEAD></HEAD><BODY><P>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:</P><P><A href="https://www.cisco.com/c/en/us/support/docs/security/identity-services-engine-21/200544-Configure-ISE-2-1-with-MS-SQL-using-ODBC.html" title="https://www.cisco.com/c/en/us/support/docs/security/identity-services-engine-21/200544-Configure-ISE-2-1-with-MS-SQL-using-ODBC.html">Configure ISE 2.1 with MS SQL using ODBC - Cisco</A></P></BODY></HTML> Tue, 19 Sep 2017 17:09:31 GMT https://community.cisco.com/t5/network-access-control/external-db-integration-push-the-parameter-to-ise/m-p/3526390#M526669 howon 2017-09-19T17:09:31Z Re: External DB integration push the parameter to ISE https://community.cisco.com/t5/network-access-control/external-db-integration-push-the-parameter-to-ise/m-p/3526391#M526676 <HTML><HEAD></HEAD><BODY><P>Thanks Howon, this is helpful. let me try with ISE 2.1 </P></BODY></HTML> Thu, 21 Sep 2017 03:48:13 GMT https://community.cisco.com/t5/network-access-control/external-db-integration-push-the-parameter-to-ise/m-p/3526391#M526676 maheshpathak 2017-09-21T03:48:13Z