When attempting to pull in accounts and their entitlements, I would like to also populate the description of the entitlements as well. I have a JDBC source setup and I am querying for the account schema.
There is an additional field that I can query from the database called description. Now, I would like for that field to populate the description of each corresponding entitlement. I have it set as the attribute for the group entitlement type.
But, even when running the group query for that specific element where it it corresponds to the profile attribute of the account schema, nothing shows up when aggregating the entitlements. Am I understanding the concept of how the entitlements map from the account data to the entitlement types incorrectly?
Yes, it looks like the problem is getting the actual field from the database to populate the description of the entitlement. I am not sure if maybe it is my group query, or if I need to map in some way, the field from the account schema to the description data from my database
I do not think so. I think I have caused some confusion.
So within each row of the database there is the PROFILE value and connected to it is the DESCRIPTION value. But, if I pull in both using the account schema, it pulls in each as a separate value for the individual account. I however, am trying to pull in each PROFILE attribute as the account’s entitlement, while populating with its attached DESCRIPTION value. Now I am wondering, if this is a issue that can be solved with how I am querying the database? If so, I can spend some time looking into that. I am just wondering if there is any standard SailPoint solution for this case.
