Connector SQL

With thousands of personnel systems in existence, how do you automate identity management and provisioning processes when yours doesn’t have a ready-made connector?

HelloID’s custom PowerShell source system allows you to connect to any ODBC-compliant database system, such as Microsoft SQL Server.

Attribute-Based Provisioning

Connecting HelloID to Microsoft SQL Server or another ODBC-compliant database allows you to retrieve and synchronize various attributes for users from a given dataset. HelloID detects changes made within a source database and then updates users’ accounts and group memberships as necessary, according to your business rules.

By connecting to Microsoft SQL Server and other ODBC-compliant databases, HelloID can leverage virtually any database as a “source of truth” for identity data—even homegrown HR management systems. Based on the synced attributes, HelloID creates new accounts, adds group memberships, and assigns permissions for all appropriate and connected downstream resources.

Ongoing Management

HelloID processes changes made to existing users in the HR system to ensure everything remains up-to-date. When an employee departs, HR changes their status in the database, and HelloID automatically executes all configured offboarding processes.

By leveraging your data for every employee, automated attribute-based access control has never been as quick or easy.

Service Automation for User Self-Service

Outside of standard provisioning configurations, users may access HelloID’s Service Automation module to request access to additional resources from their dashboard. If approved by the associated “Product Owner,” HelloID processes all changes and provisioning needs.

With HelloID connected to MS SQL Server, “Product Owners” may be assigned based on their attributes synced from the HR database. Examples of these attributes would be position or contract data that specifies whether the user is a department head, manager, or team leader.

Power Shell Source System

The defined PowerShell script retrieves “Person” and “Contract” attribute data for HelloID from Microsoft SQL or another OCDB-compliant database. PowerShell’s flexibility allows you a variety of methods for connecting to any system or database as a “source” for the attributes.