Connector PostgreSQL

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?

PostgreSQL is a free, open-source relational database management system (RDBMS). As a robust back-end database, PostgreSQL can be used to manage anything from a single machine up to full data warehouses and web services. PostgreSQL supports a wide variety of data types, and users can even create their own fully indexable types.

Attribute-Based Provisioning

Connecting HelloID to PostgreSQL allows you to retrieve and 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 PostgreSQL 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 PostgreSQL, HelloID can leverage a database as the “source of truth” for your identity data. If a database managed by PostgreSQL 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 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 PostgreSQL, “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.

Power Shell Source System

PowerShell may be used to connect to PostgreSQL, other RDBMS, and ODBC-compliant databases. The defined PowerShell script retrieves “Person” and “Contract” attribute data for HelloID. PowerShell’s flexibility allows you a variety of methods and configurations for connecting to any system or database as a “source” (for retrieving) attributes or a target (to send attributes to).