How to aggregate combination of multivalued multiple attributes

we have learning center where courseID, courseName, Status and Score are stored
each users can have multiple courses assigned.

How can we bring these multivalued attributes in DIN

In source → Account schema, select those attributes as multi-valued.

Hi @REKHASACH,

Ideal case will be to create this course as entitlement and then you can have as many course as you want to assign to user as entitlement and all the attribute that you mentioned can be part of entitlement schema.

Let me know if further clarification or help needed.

Thanks

That will create multiple , multiple valued attribute, how can I map that particular score is for particular course.

What type of connector is this, by any chance this is API based ?

Please share a sample response and how you would like to parse it. So that I provide some solutions.

Thanks
Krish

If you have a Weservice connector this resource can help you : Using WebService connector rules to streamline and accommodate “interesting” sources - Content / Video Library - SailPoint Developer Community

1 Like

Thanks Krishna,

Connector is API based, using cornerstone API’s

I have captured courseNAme and TrainingStatus as multivalued. How can I write back to another target system.

We need to depend on Transforms.

If you need to enable sync for these attributes then you need to create Identity attribute.

You need to get the format to write these values to another Target system, for example

{Course name1 : status, Course name2 : status}

We need to know If these values are going to be single-valued or multi-valued to the Target system, if it is multi-valued then we can handle that as well.

Thanks
Krish

From an connector/integration point, are you working with a web services connector or a custom connector to establish the integration between the two. I’ve also struggled with working with multiple valued groups. The only way that I have been able to get around this is adding delimiters between the separate segments. In your case it would look something like --. It’s not perfect or ideal, but gets the data visible.

I am curious to know the goal of this. Are you looking to just have the data visible or to be used in roles and other processes?

We also just implemented an integration with our Cornerstone LMS system. We opted to pull the data into an on prem database, and then use a JDBC integration between that dataset and SailPoint. We decided only to pull in completed curriculums due to the massive quantity of training items if you pull in everything. We connected the completed training items as entitlements on the account. I would not recommend that approach in your case if you are looking for score as you would need to create an entitlement for every score for every training.

Thanks,
Jeff

Thanks Jeff, as one to one mapping of course and score was not working in IDN , we used another HTTP call to get score based on course and write back to target app

This issue is resolved now

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.