SAP HANA DB
The SAP HANA DB data import uses a template collector that can extract data from SAP HANA databases. The collector is based on our SQL Query Collector and therefore it utilizes an OLEDB provider, which is part of the Omada Identity Cloud infrastructure. To use it in the on-premises deployment, install the SAP HANA client on your local machine. See Download and Install the SAP HANAClient for details.
important
The minimum required version of the SAP HANA client version is 2.17.22.0.
Supported objects and operations
The SAP HANA DB connectivity allows you to perform the following operations on the access rights objects:
| Resource | Possible operations |
|---|---|
| Accounts | Create (POST), Read (GET), update (PUT), delete (DELETE) |
| Resources - User groups | Create (POST), read (GET), update (PUT), delete (DELETE) |
| Resources - Database roles | Create (POST), read (GET), update (PUT), delete (DELETE) |
| Resource Assignments - User group assignments | Create (POST), read (GET), update (PUT), delete (DELETE) |
| Resource Assignments - Database role assignments | Create (POST), read (GET), update (PUT), delete (DELETE) |
Minimum required permissions
You must be a database service user with sufficient rights to configure the SAP HANA.
Implementation notes
None.
Network requirements
None.
Prerequisites
To configure the target system, follow the SAP HANA guidelines.