Relational Database (RMDB) as Identity Source

This guide explains how to configure a database as an identity source in IDaaS, synchronizing organizational and user data from the database into the IDaaS platform to ensure data consistency across enterprise application systems.

Prerequisites

• Currently, only PostgreSQL database recovery is supported.
• You must have database query permissions and be able to query data from organization and user tables or views via SQL.
• Administrator permissions for the IDaaS Enterprise Center.

Configure the RMDB Identity Source in IDaaS

1. Log in to the IDaaS Enterprise Center, choose Users > Identity Source Management from the top navigation bar, click Add Identity Source, and select RMDB.

   

2. Customize the identity source name, fill in the host, port, database username, database password, and other parameters as prompted, then click OK to save.

3. Enter the detail page of the newly created identity source to view or update the Basic Configuration, including connection parameters, full synchronization, and incremental synchronization configuration items.

   Connection Parameters

   

   Full Synchronization

   

   Incremental Synchronization

   

4. Switch to the Advanced Configuration tab. It is recommended to keep the default values or adjust them according to actual requirements.

   

   Parameter	Description
   Select Root Organization	The organization node into which identity source data is imported. The default is fine.
   Organization Matching Policy	Mapping relationship for importing database identity source organizations into IDaaS. The default is fine.
   Create Organization	Checked Yes by default.
   Update Organization	Checked Yes by default.
   Delete Organization	By default, organizations are retained (i.e., retained in IDaaS). You can also disable or delete organizations.
   User Matching Policy	Mapping relationship for importing database identity source users into IDaaS. The default is fine.
   Create User	Checked Yes by default.
   Update User	Checked Yes by default.
   Delete User	By default, users are disabled (i.e., when a user is deleted in the database, the user is disabled in IDaaS). You can also retain or delete users.
   Safety Threshold Adjustment	Sets the maximum threshold ratio for changes such as deleting users, deleting organizations, or changing organization hierarchy in the upstream identity source. Threshold = (Difference between platform-recovered data and this recovery / Recovered data) × 100%. If the upstream identity source disables or deletes data exceeding the threshold, the platform will not perform the disable or delete operation.

5. After configuration, switch to the Object Model tab, select Mapping Definition, set the transformation mode of username account name to Auto Transform, and the execution mode to Create. The corresponding system user attribute is Username.

   The object model supports mapping attributes of users and organizations from the database identity source to IDaaS user and organization attributes. After configuration, user and organization attributes are recovered from the database into IDaaS.

   

   • Execution Mode: Sets when the attribute needs to be mapped.
     • Do Not Map: The attribute will not be synchronized to IDaaS.
     • Create: The attribute is synchronized only during creation.
     • Update: The attribute is synchronized only during update.
     • Create and Update: The attribute is synchronized during both creation and update.
   • Transformation Mode: Sets how the attribute is mapped.
     • Auto Transform: Synchronize the value as-is from the identity source.
     • Script Transform: Use this when the value from the identity source does not meet the required format. Refer to Script Mapping Methods.

6. After configuration, click Execute Synchronization to run the synchronization immediately.

   TIP

   If the synchronization mechanism in the basic configuration is set to scheduled synchronization, there is no need to manually execute the synchronization task here.

7. After execution, switch to the Synchronization Events page to view all synchronization tasks for this identity source. Click Details under the Operation column to view the import results, or go to the Users > Users and Organizations page to view the imported data.