Database user and organization data synchronous plug -in

Features

1. ServerThe mode implements the user and organization in the database server through the standard SCIM interface
2. ClientThe mode is implemented. Users and organizations in Server, Synchronous to the client database
3. This plugin only supports MySQL and SQLServer for the time being

Configure two MYSQL database database synchronization

Create two databases and tables

• Create a Server database that provides synchronous data，Establishsync_users, sync_groupssurface， And the intermediate table of the Groups of usersync_users_groups_rel,
  sync_users_groups_relUser in the middle table_ID key associated SYNC_users(id)， group_ID key associated SYNC_groups(id)

  Hint

  In this example, the relationship between the User and Group is the relationship between Manytomany, If the user belongs to only one group，allowablesync_usersDefinition group in the table_id，Outer key associated SYNC_groups(id)

• Create a client database，Used to synchronize the data provided by the server database to the Client database

  Notice

  Convenient for demonstration，The table definition in the client database is the same as the Server database,The actual production environment may be different

Configuration Mysql Source database

OpenSCIM data synchronizationpage，Click to createConfiguration form parameterConfigure user attribute mappingConfiguration tissue attribute mapping

Hint

If the user and group are more paired，Need to be filled inUser table group outer key field
If the user and group are more to the relationship，Need to be filled inUsers and organizations are more to multi -relationship tables， User Organic Relationship Table User outer key field， User Organic Relationship Form Group outer key field
groupThe fields associated between superiors need to be set upOrganization table Parent outer key field
Targets must exist in user and organizational attribute mapping lists_ATTR is a mapping of ID, The ID of the user and group in the SCIM protocol here

Configure from the source database synchronous data to the client database

OpenSCIM data synchronizationpage, Click to createConfiguration Mysql Synchronous client

Hint

If the user and group are more paired，Need to be filled inUser table group outer key field
If the user and group are more to the relationship，Need to be filled inUsers and organizations are more to multi -relationship tables， User Organic Relationship Table User outer key field， User Organic Relationship Form Group outer key field
groupThe fields associated between superiors need to be set upOrganization table Parent outer key field
Source must exist in the user and organizational attribute mapping list_ATTR is a mapping of ID，Used to match the data in the Server and Client database, Determine whether the data has been synchronized

View server database table data

View source database GroupsView source database usersView source database users and groups relationship data

View the client database table data

Check the client database GroupsCheck the client database usersCheck the relationship data of the CLIENT database users and groups

评论