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 SAP HANA 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 SAP HANA and choose SAP HANA Data Provider from the drop-down menu.
  6. In the Server field, enter the hostname and the portname to the database created on SAP HANA in the following format: Hostname:portnumber. For example, <hostname>:39013 to connect to SYSTEMDB and <hostname>:39015 to connect to HXE default database.
  7. Provide the Username and Password to the database.
  8. Provide the display name and the identifier.
  9. Select the DSI_SAPSQL_Configuration.xml configuration file available at DSI/ConfigFiles in DSI Module folder, and click Next.
  10. Review the preferences and click Next until the Save Configuration window is displayed. Ensure that the configuration field is empty.
  11. Click Next.
  12. Review the preferences and click Finish.

    The schema loading window is displayed.

  13. After the schema is loaded, the Template Selection page is displayed.
  14. Select the SAP HANA template and click Next.

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

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

Connecting to multiple databases through a single synchronization project

Connecting to multiple databases through a single synchronization project

The Database Systems Integration (DSI) module provides an additional template for the SAP HANA database that allows you to connect to multiple databases through a single synchronization project in SAP HANA.

The ability to connect to multiple databases through a single synchronization project simplifies the process of maintaining multiple databases connections, as the databases share a single set of configurations including mappings, workflows, and data operations.

To create connections to multiple databases through a single synchronization project

  1. In the Synchronization Editor, open the synchronization project for SAP HANA connection.
  2. In the configuration pane, navigate to the base object and click the wizard icon to setup a connection to the database.
  3. Follow the steps specified in the Creating a synchronization project for SAP HANA database to add base objects.
  4. Commit the changes to the database.

    A new startup configuration is created for the base object connection.

Mapping sets and object types

Mapping sets and object types

The SAP HANA database template has mapping sets for the following SAP HANA object types:

  • User

  • Roles

  • Granted Roles

    NOTE:Before updating the default mapping sets, you should save the backup of the One Identity Manager database.

Mapping object types between the SAP HANA database and One Identity Manager tables

The following table describes the mapping object types in the SAP HANA database to the parameters in the UNS tables of One Identity Manager.

Table 4: Mapping table for SAP HANA object types

Mapping set name

Object type One Identity Manager table

UsersMapping

SYS.USERS UNSAccountB

RolesMapping

SYS.ROLES UNSGroupB

UserHasRoleMapping

SYS.GRANTED_ROLES UNSAccountBInUNSGroupB

RoleHasRoleMapping

SYS.GRANTED_ROLES

UNSGroupBInUNSGroupB

Initial synchronization

Initial synchronization

Initial synchronization is used to initialize the One Identity Manager tables with SAP HANA data. SAP HANA users, roles, user role 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.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating