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
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.
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…
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.
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.
alright, I will check into it, although the configuration of operations seems different from the regular jbdc connector.
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
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.
upping the topic.
Did someone already implemented that connector ?
Hi @llebrault
The connector you are using here should be the JDBC connector
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.
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.
Alright, I get it, thanks !
This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.
