Creating a synchronization project
Creating a synchronization project
The following procedure explains how to create and configure synchronization projects in the MySQL database.
Creating a synchronization project
-
Open the Synchronization Editor.
- On the Start page, select Start a new Synchronization Project.
- On the Choose target system page, select the Generic Database Connector check box and click Next.
- Select Create New System Connection.
- Select MySQL from the drop-down list.
- In the Server field, enter the hostname in the following format: Hostname:portnumber.
- Provide the Username and Password to the database.
- Select mysql in the drop-down list for the Database field.
- Provide the display name and the identifier.
- Select the DSI_MYSQL_Configuration.xml configuration file available at DSI/ConfigFiles in the One Identity Manager installation folder, and click Next.
- Review the preferences and click Next until the Save Configuration window is displayed. Ensure that the configuration field is empty.
- Click Next.
- Review the preferences and click Finish.
The schema loading window is displayed.
- After the schema is loaded, the Template Selection page is displayed.
- Select the MySQL template and click Next.
Follow on-screen instructions until the Provisioning Capability window is displayed.
- Select the synchronization server and click Finish.
The synchronization project is created successfully.
After the creation of the synchronization project, set the variables value in the DefaultUserPassword field.
Mapping sets and object types
Mapping sets and object types
The MySQL database template has mapping sets for the following MySQL object types:
-
User
-
All_Privileges
-
User_Privileges
NOTE: Before updating the default mapping sets, you should save the backup of the One Identity Manager database.
Mapping object types between the MySQL database and One Identity Manager tables
The following table describes the mapping object types in the MySQL database to the parameters in the UNS tables of One Identity Manager.
Table 5: Mapping table for MySQL object types
|
Mapping set name |
Object type |
One Identity Manager table |
|
UsersMapping |
Mysql.user |
UNSAccountB |
|
PrivilegesMapping |
Mysql.all_privileges |
UNSGroupB |
|
UserHasPrivilegeMapping |
Mysql.user_privileges |
UNSAccountBInUNSGroupB |
Initial synchronization
Initial synchronization
Initial synchronization is used to initialize the One Identity Manager tables with MySQL data. MySQL users, roles, user membership, and role membership are synchronized into the One Identity Manager tables.
To run the initial synchronization
- In the Synchronization Editor, open the synchronization project.
- In the Navigation section, select Start up Configurations.
- Click Execute.
-
Confirm the security prompt with Yes.
The synchronization workflow is completed successfully. The synchronized objects can be viewed in the Manager.
Provisioning workflow
Provisioning workflow
The Provisioning workflow is used to create, update, delete MySQL users, and update role membership.
