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
-
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 SAP HANA and choose SAP HANA Data Provider from the drop-down menu.
- 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.
- Provide the Username and Password to the database.
- Provide the display name and the identifier.
- Select the DSI_SAPSQL_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 SAP HANA 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.
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
- In the Synchronization Editor, open the synchronization project for SAP HANA connection.
- In the configuration pane, navigate to the base object and click the wizard icon to setup a connection to the database.
- Follow the steps specified in the Creating a synchronization project for SAP HANA database to add base objects.
- 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
- 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.
