Overview

Our Microsoft SQL Server integration uses a common Java Database Connectivity (JDBC) based connector for accessing and maintaining SQL table permissions.

We use SCIM protocols to connect via our JDBC Connector.

Account in SQL Server

IDHub pulls all user account information from a targeted location.

User Account attribute we fetch is fully customizable. Some examples are as below:

• First Name
• Last Name
• Display Name
• Telephone Number
• Email-Address (As a unique identifier)
• Department
• Title
• Employee Type

Our customers can choose to fetch any other attributes apart from the above as per their individual needs. With our Attribute based Access Control (ABAC), you can decide which information will be used on new user creation and which ones on user modifications.

Entitlements in SQL Server

IDHub JDBC Connector pulls only 1 types of entitlement from SQL instance for provisioning and de-provisioning.

• Tables

Employees of your organization can request for Table access as needed.

Table

As part of JDBC connector, we establish connection with SQL instance 

All the tables pulled are considered as ‘Entitlements’

Users will be able to request for a table access from IDHub.

Upon completion of approvals based on request workflow defined by you on a particular table, the users will automatically get access to the requested tan;e by our automated fulfillment.

Support and Maintenance

IDHub provides out of the box connector issue support and timely maintenance as a standard quality guarantee for all of our customers having our Cloud solution. However, any customization made to existing connectors requires managed services support plan for support and maintenance. 

We support below SQL versions:

• Microsoft SQL Server 2022
• Microsoft SQL Server 2019
• Microsoft SQL Server 2017
• Microsoft SQL Server 2016

Other JDBC Connector Apps

Some other database applications to connect to are:

• Postgress SQL
• My SQL
• SQLite
• Mongo DB
• Redis
• Oracle DB etc.