Chat now with support
Chat with Support

Identity Manager 9.2 - Administration Guide for Connecting to Native Databases through Database Systems Integration Module

Database Systems Integration Module Installing DSI Working with Oracle Database Working with MSSQL Working with SAP HANA Working with the MySQL database template User scenario Troubleshooting

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

  1. Open the Synchronization Editor.

  2. On the Start page, select Start a new Synchronization Project.
  3. On the Choose target system page, select the Generic Database Connector check box and click Next.
  4. Select Create New System Connection.
  5. Select MySQL from the drop-down list.
  6. In the Server field, enter the hostname in the following format: Hostname:portnumber.
  7. Provide the Username and Password to the database.
  8. Select mysql in the drop-down list for the Database field.
  9. Provide the display name and the identifier.
  10. Select the DSI_MYSQL_Configuration.xml configuration file available at DSI/ConfigFiles in the DSI Module folder, and click Next.
  11. Review the preferences and click Next until the Save Configuration window is displayed. Ensure that the configuration field is empty.
  12. Click Next.
  13. Review the preferences and click Finish.

    The schema loading window is displayed.

  14. After the schema is loaded, the Template Selection page is displayed.
  15. Select the MySQL template and click Next.

    Follow on-screen instructions until the Provisioning Capability window is displayed.

  16. 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

  1. In the Synchronization Editor, open the synchronization project.
  2. In the Navigation section, select Start up Configurations.
  3. Click Execute.
  4. 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.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating