# Azure DB connector **URL:** \ **Category:** IIQ Discussion and Questions\ **Tags:** identityiq\ **Created:** [July 24, 2024, 3:48pm UTC](https://developer.sailpoint.com/discuss/t/azure-db-connector/73951 "2024-07-24T15:48:35Z")\ **Posts on this page:** 14\ **Page:** 1
**Author:** ![llebrault](https://avatars.discourse-cdn.com/v4/letter/l/13edae/32.png) [@llebrault](https://developer.sailpoint.com/discuss/u/llebrault)\ **Post date:** [July 24, 2024, 3:48pm UTC](https://developer.sailpoint.com/discuss/t/azure-db-connector/73951/1 "2024-07-24T15:48:35Z")
## IIQ 8.3 Hi ! I’m looking to integrate an Azure Database to IIQ 8.3 I have a relativily simple requierement to provision users. My question would be how to best proceed to provision different tables inside the db ? I’ve one table for the user, and one different table for his right, this middle table both referencing user and the right. I want to avoid any unnecessary customisation, so I’d rather ask while I am at it, what would be the best way to deal with it. Thanks ---
**Author:** ![ajmerasunny1](https://avatars.discourse-cdn.com/v4/letter/a/3be4f8/32.png) [@ajmerasunny1](https://developer.sailpoint.com/discuss/u/ajmerasunny1)\ **Post date:** [July 24, 2024, 4:28pm UTC](https://developer.sailpoint.com/discuss/t/azure-db-connector/73951/2 "2024-07-24T16:28:36Z")
I don’t believe you need to handle that explicitly. As long as you create the account with the correct values and assign the required group, the entries should be automatically added to the tables. ---
**Author:** ![enistriminsait](https://avatars.discourse-cdn.com/v4/letter/e/58f4c7/32.png) [@enistriminsait](https://developer.sailpoint.com/discuss/u/enistriminsait)\ **Post date:** [July 24, 2024, 5:32pm UTC](https://developer.sailpoint.com/discuss/t/azure-db-connector/73951/3 "2024-07-24T17:32:14Z")
Hi @llebrault, in Azure exist different type ofr managing db, but more or less, is the same of a normal MSSQL istance on-primise. The most work is on Azure, about permission, network, firewall ecc.. ---
**Author:** ![nick01king](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/nick01king/32/13854_2.png) [@nick01king](https://developer.sailpoint.com/discuss/u/nick01king)\ **Post date:** [July 24, 2024, 5:57pm UTC](https://developer.sailpoint.com/discuss/t/azure-db-connector/73951/4 "2024-07-24T17:57:48Z")
Hi @llebrault I would suggest using the JDBC connector and configure the operations like a normal DB once the network connectivity has been allowed through any firewall or express route. ---
**Author:** ![llebrault](https://avatars.discourse-cdn.com/v4/letter/l/13edae/32.png) [@llebrault](https://developer.sailpoint.com/discuss/u/llebrault)\ **Post date:** [July 25, 2024, 1:07pm UTC](https://developer.sailpoint.com/discuss/t/azure-db-connector/73951/5 "2024-07-25T13:07:50Z")
I see, so I have to manage first table to provision, and the group table as entitlement, should be fine. Connector is obscure to me yet, because I don’t see yet where to configure the operation like in the standard connector. ---
**Author:** ![llebrault](https://avatars.discourse-cdn.com/v4/letter/l/13edae/32.png) [@llebrault](https://developer.sailpoint.com/discuss/u/llebrault)\ **Post date:** [July 25, 2024, 1:08pm UTC](https://developer.sailpoint.com/discuss/t/azure-db-connector/73951/6 "2024-07-25T13:08:22Z")
alright, I will check into it, although the configuration of operations seems different from the regular jbdc connector. ---
**Author:** ![nick01king](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/nick01king/32/13854_2.png) [@nick01king](https://developer.sailpoint.com/discuss/u/nick01king)\ **Post date:** [July 25, 2024, 1:20pm UTC](https://developer.sailpoint.com/discuss/t/azure-db-connector/73951/7 "2024-07-25T13:20:18Z")
> [@llebrault](#): > > Azure Database What type of Azure database is it? The JDBC connector allows you to specify a connection string specific to the type/driver (you will need to make sure this is put in the lib folder) for the DB and then you use SQL syntax in the operations appropriate to this. [Azure Databases - Types of Databases on Azure | Microsoft Azure](https://azure.microsoft.com/en-us/products/category/databases/) ---
**Author:** ![llebrault](https://avatars.discourse-cdn.com/v4/letter/l/13edae/32.png) [@llebrault](https://developer.sailpoint.com/discuss/u/llebrault)\ **Post date:** [July 30, 2024, 9:07am UTC](https://developer.sailpoint.com/discuss/t/azure-db-connector/73951/8 "2024-07-30T09:07:42Z")
![image](https://global.discourse-cdn.com/sailpoint/original/2X/1/19063eebd3d8bccb12f0f8b288246a84a0a11564.png) Thing is compared to the standard jbdc connector it looks like this. I’ve two questions : Where do I specifiy the calls ? How do I work on attributes ? Shall I use “Table.attribute” ? How do I do? Connector enable to specify DB, but i’m acting on one DB, two tables. ---
**Author:** ![llebrault](https://avatars.discourse-cdn.com/v4/letter/l/13edae/32.png) [@llebrault](https://developer.sailpoint.com/discuss/u/llebrault)\ **Post date:** [August 7, 2024, 2:39pm UTC](https://developer.sailpoint.com/discuss/t/azure-db-connector/73951/9 "2024-08-07T14:39:40Z")
upping the topic. Did someone already implemented that connector ? ---
**Author:** ![nick01king](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/nick01king/32/13854_2.png) [@nick01king](https://developer.sailpoint.com/discuss/u/nick01king)\ **Post date:** [August 7, 2024, 3:14pm UTC](https://developer.sailpoint.com/discuss/t/azure-db-connector/73951/10 "2024-08-07T15:14:25Z")
Hi @llebrault The connector you are using here should be the JDBC connector ---
**Author:** ![llebrault](https://avatars.discourse-cdn.com/v4/letter/l/13edae/32.png) [@llebrault](https://developer.sailpoint.com/discuss/u/llebrault)\ **Post date:** [August 7, 2024, 3:27pm UTC](https://developer.sailpoint.com/discuss/t/azure-db-connector/73951/11 "2024-08-07T15:27:30Z")
So, the azure SQL db connector is not fit to use with an Azure DB ? I can do it with JBDC alright, but I thought this was the proper one to use on this case. ---
**Author:** ![nick01king](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/nick01king/32/13854_2.png) [@nick01king](https://developer.sailpoint.com/discuss/u/nick01king)\ **Post date:** [August 7, 2024, 3:36pm UTC](https://developer.sailpoint.com/discuss/t/azure-db-connector/73951/12 "2024-08-07T15:36:29Z")
Hi @llebrault If you want to manage accounts and entitlements in the Azure SQL DB this is fine. But you want to update DB tables and this is a different type of connector for this it would be the JDBC connector. Which allows you to use SQL statements for different operations on specific tables. ---
**Author:** ![llebrault](https://avatars.discourse-cdn.com/v4/letter/l/13edae/32.png) [@llebrault](https://developer.sailpoint.com/discuss/u/llebrault)\ **Post date:** [August 7, 2024, 9:52pm UTC](https://developer.sailpoint.com/discuss/t/azure-db-connector/73951/13 "2024-08-07T21:52:44Z")
Alright, I get it, thanks ! ---
**Author:** ![system](https://global.discourse-cdn.com/sailpoint/original/2X/f/f2136700ed5e3703e0b85e02f6be799dacca7735.png) [@system](https://developer.sailpoint.com/discuss/u/system)\ **Post date:** [October 6, 2024, 9:53pm UTC](https://developer.sailpoint.com/discuss/t/azure-db-connector/73951/14 "2024-10-06T21:53:32Z")
Closed on October 6, 2024, 9:53pm UTC This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.