SAP LASTLOGON data import

[karamchand]

Hi,

Referring to Saviynt documentation here - https://docs.saviyntcloud.com/bundle/SAP-v23x/page/Content/Configuring-the-Integration-for-Importing...

Can Saviynt import account attributes from SAP for LASTLOGON information? The default SAP connector doesn't have ACCOUNTIMPORTJSON. Please let me know how this can be configured. 

[Saathvik]

@karamchand : Yes based on documentation table it pulls that information. All attributes listed in table will be imported to respective EIC columns listed

[Manu269]

SAP Connector utilizes tables listed under account import.

Refer this Configuring the Integration for Importing Accounts and Access (saviyntcloud.com) section 

Account Attribute Mapping setting

[karamchand]

I do not see ACCOUNTIMPORTJSON yet in the SAP connection configuration. Could you please direct me to right location?

[rushikeshvartak]

Sap connector works on set of tables . And sequence should be correct. 
can you share your configuration for tables to import under sap connector

[karamchand]

Our current list of tables is as below

USR02,USER_ADDR,AGR_AGRS,AGR_TEXTS,AGR_USERS,USORG,AGR_1252,AGR_1251,USGRP_USER,USGRP,AGR_DEFINE,TSACT

We want to fetch two more records from SAP (we are fine with other tables as well, as long as these info can be imported from SAP into Saviynt)

1. Attribute ALIAS from table USREFUS
2. Attribute Email from any table (we tried ADR6)

[rushikeshvartak]

USREFUS & ADR6 tables are not supported for sap import

https://docs.saviyntcloud.com/bundle/SAP-v23x/page/Content/Preparing-for-Integration.htm

supported tables

Scenario List of Tables Used

Request access using the Access Request System	USR02, AGR_AGRS, AGR_TEXTS, AGR_DEFINE, AGR_USERS
Full import of account and roles	USR02, TSTC, TSTCT, AGR_AGRS, AGR_TEXTS, AGR_DEFINE, AGR_USERS, USORG, UST04, AGR_1252, AGR_1251
Full import of account and roles with lastname, firstname and department	USR02, USER_ADDR
Incremental import of account and role	USR04, USR02, TSTC, TSTCT, AGR_AGRS, AGR_TEXTS, AGR_DEFINE, AGR_TIME, AGR_USERS, USORG, UST04, AGR_1252, AGR_1251
Full import of account, role, and profile	USR02, TSTC, TSTCT, AGR_AGRS, AGR_TEXTS, AGR_DEFINE, AGR_USERS, USORG, UST04, UST10C, UST10S, UST12, AGR_1252, AGR_1251
Import of account and role along with performing SODs (Tcode usage)	USR02, TSTC, TSTCT, AGR_AGRS, AGR_TEXTS, AGR_DEFINE, AGR_USERS, USORG, UST04, AGR_1252, AGR_1251, SWNCMONIINDEX
Monitor fire fighter logs - Tcode usage	SWNCMONIINDEX
Monitor fire fighter logs - Tcode usage and change logs	SWNCMONIINDEX, CDHDR, CDPOS

[karamchand]

Thanks Rushikesh for the list. I have seen this in the Saviynt Docs portal too.  

We are planning to use SAP CUA to integrate multiple SAP products with Saviynt.

Could you guide what option do we have to import email and ALIAS from SAP to Saviynt. These are the attributes to be used for account mapping and other logical configurations in Saviynt. Is there a way this can be achieved? 

We are also open to try this directly integrating with SAP products, and not through CUA - if its supported.   

[rushikeshvartak · Accepted solution]

Currently custom mapping of accounts attributes are not supported. Only aname / alias is imported as account name in saviynt & we can’t pull email

please submit idea ticket for same