Mandatory attribute for account import using Stored procedure

[Abhay_Yadav]

Hi All,

We are trying to import account and entitlements using Stored procedure. We are not getting belwo values from stored procedure.

1. Is it possible to hardcode securitysystem, endpoint,entitlementtype in the import XML itself, or is it mandatory to get these from Store procedure.

2. If it's mandatory to get these from stored procedure is there restriction on naming convention?

3. What all columns are mandatory to get the Account and Entitlement and map entitlement to account.

 'XXXXXX' AS securitysystem,
'XXXXXXXX' AS endpoint,
XXXXXXX AS accountName,
XXXXXXXXX AS FirstName,
XXXXXXXXX AS LastName,
'XXXXXXXXX' AS entitlementtype,
XXXXXXXXXX AS entitlementvalue,

Regards,

Abhay Yadav

[NM]

@Abhay_Yadav yes you can but if using stored procedure it won't work .. you need to get the value.

[Abhay_Yadav]

Hi @NM ,

Can you please help us in understanding how it can be hardcoded.

Regards

[NM]

@Abhay_Yadav as mentioned above without using stored procedure you can 

Something like 

'role' as entitlementtype.

If stored procedure is the only option then you can't.

[rushikeshvartak]

1. Is it possible to hardcode securitysystem, endpoint,entitlementtype in the import XML itself, or is it mandatory to get these from Store procedure.

Yes its mandatory to get from stored procedure and you can't hardcode in XML

2. If it's mandatory to get these from stored procedure is there restriction on naming convention?

Yes endpoint /security system name should match with saviynt application 

3. What all columns are mandatory to get the Account and Entitlement and map entitlement to account.

Same as you mentioned 

 'XXXXXX' AS securitysystem,
'XXXXXXXX' AS endpoint,
XXXXXXX AS accountName,
XXXXXXXXX AS FirstName,
XXXXXXXXX AS LastName,
'XXXXXXXXX' AS entitlementtype,
XXXXXXXXXX AS entitlementvalue,

[Abhay_Yadav]

Hi @rushikeshvartak , @NM ,

We have below output of the account Stored procedure.

And below is entitlement store procedure output.

In entitlement stored procedure there is hierarchy

 Role Name > Module Category > Module Name > Permission > Permission Setting

What modifications would be required in this to import the entitlement hierarchy and in user stored procedure so that user's entitlement access can be mapped to "Role Name"

Regards,

Abhay Yadav

[NM]

@Abhay_Yadav , output looks fine .. you can map it to role.

<mapfield saviynt

  <mapfield saviyntproperty="entitlementvalues.entitlementvalue" sourceproperty="RoleName" type="character"/>

[Abhay_Yadav]

Hi @NM ,

I meant in the entitlement store procedure do i need to get
'Rolename' as enttype1

'Module Category' as enttype2 

'Module Name' as enttype3
similarly for others

Also in the documentation it has system name and application name as two different things. Is it just a typo or are these actually 2 different things. 

Regards,

Abhay Yadav

[NM]

@Abhay_Yadav it depends you have to have them as seperate entitlement type or single(parent and child)

[Abhay_Yadav]

Hi @NM ,

As we are getting only "RoleName" information in Account Stored procedure. What would be the best way to display it in saviynt that if user has Access to "RoleName" then saviynt should display full hierarchy based on entitlement stored procedure.

Can you please help me understand how hierarchy for seperate entitlement type can be achieved and how single(parent and child ) hierarchy can be achieved.

Regards,

Abhay Yadav

[rushikeshvartak]

Above all columns are mandatory if you are bringing entitlement to entitlement mapping. Role to Privilege mapping

[rushikeshvartak]

You need to have Status as 1/2 in Account result also entitlement type, endpoint , security system is required