Issue with table mapping for SAP HANA Database

[VinayAlgam]

Hi Team,

I have onboarded SAP HANA Database application in our platform by using HANA connector. After this I ran the import job I could see most of the accounts and Entitlements are reconned but the accounts are not mapped to Entitlements. When I ran the import job also I couldn't see accounts are not getting updated  i.e. Updated Date for Accounts are not changing.

So I have checked the documentation they have mentioned the mapping for EIC Object and SAP Hana Object, but they also mentioned an example to use the below ones in Tables attribute in connection details :

Tables : Accounts, Roles, Privileges, Schema, Table, View, AnalyticalPrivileges, RolePriv, and AccountPriv

In the mapping they said to use "ANALYTICAL_PRIVILEGE" but in the example they mentioned in a wrong format. In the similar way I feel this issue is something related to table mapping.

Could someone help me in getting the correct details about mapping.

Thanks,

Vinay Kumar

[sai_sp]

@VinayAlgam 

are you using this same order?

Tables : Accounts, Roles, Privileges, Schema, Table, View, AnalyticalPrivileges, RolePriv, and AccountPriv

[sai_sp]

Accounts, Roles, Privileges, Schema, Table, View, AnalyticalPrivileges, UserRole, RoleRole, RolePriv, AccountPriv

[VinayAlgam]

Hi Sai,
I have used the above order and removed the spaces in it, it worked fine. But the issue is the system is getting complete entitlements, we only want user accounts, roles and roles mapping to users. Do you have any suggestion for that.

And also from the above order could you please tell me what are all the EIC objects are mapped to HANA objects.

Thanks,

Vinay

[sai_sp]

@VinayAlgam Please try importing Accounts,Roles,UserRole,RoleRole,RolePriv,AccountPriv 

The first 4 tables should give you the data you need. The last 2 tables will give you privileges.

[VinayAlgam]

Hi Sai,

I tried by keeping only those 4 tables but still I could see many entitlements after recon job.

Let me explain the below account for our endpoint has the below entitlements. But when you expand it you get to see lot many entitlements.

But we only want to have just the initial displayed entitlements i.e. ZSecurityRoles.ZBasis-Sec_Roles::Y_S4H_HANA_SECURITY_ADMINISTRATOR, PUBLIC, ztest which is like the below screenshot.

Thanks,

Vinay Kumar

[rushikeshvartak]

Accounts,Roles,UserRole,RoleRole

[sai_sp]

Please try with Accounts,Roles,UserRole only. Create a new endpoint and see if it works.