When it comes to custom and homegrown databases, how do you automate identity management and provisioning processes without ready-made connectors or resorting to scripting?

MySQL is a free, open-source relational database management system (RDBMS). MySQL supports a wide variety of data types and APIs and is ODBC-compliant when used with MySQL Connector/ODBC. MySQL is typically used in conjunction with other programs in order to implement applications that rely on relational databases.

Attribute-Based Provisioning

Connecting HelloID to a MySQL database allows you to synchronize various attributes for users from a given dataset. The attribute mapper allows you to configure the fields and variables to be synced from or to the MySQL database and that are used to compile a “person” in HelloID. HelloID detects changes made within a source database and then updates users’ identity data as necessary. Based on the synced attributes and your configured business rules, HelloID automatically creates, provisions, and manages accounts for each user.

By connecting to MySQL, HelloID can leverage a database as the “source of truth” for your identity data. If a database managed by MySQL is used for applications, it can be connected as a target system that HelloID will keep up-to-date based upon the data synced from your source system.

Ongoing Management

When HelloID detects new user data in your source system database, it triggers syncing and provisioning processes. HelloID also detects and processes changes made to existing users 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. All processes are automatic, logged, and consistent.

By leveraging MySQL along with 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 MySQL, “Product Owners” may be assigned based on their attributes synced from the source system database. Examples of these attributes would be position or contract data specifying whether a user is a department head, manager, or team leader.