Attribute Sync for - JDBC Source

Identity Security Cloud (ISC) ISC Discussion and Questions
,
1

Hi All,

I am working on a jdbc source all the development is completed except 1.

There is a requirement that wherever a user’s firstname or lastname changes it should also change that at target for the user account.

I want to know how to trigger this modify scenario I created a user via delimited source and then assigned him the access to the jdbc source.

Then i updated the firstname for the user but when i went to the identity cube there was nothing happening in the evnt history.

Once ik that modify account is triggering all i need to do will be on the prov rule level which i can manage.

Can someone help me how to trigger this scenario?

2

Hi @Deepanshu07

This looks to be an attribute sync requirement. Why don’t you give that a shot?
For attribute sync to work, your create account configuration must include the attribute to be synced.

Then, just tick the checkboxes against the attributes (first and last name in your case) and that should trigger a provisioning with modify operation to the connector (i.e invoke your provisioning rule) where you can handle the update with appropriate update query.

1 Like
3

Hi @sushantkulkarni,

I have that a shot but did not invoke anything for me.

I can thinking if we have an update prov policy for the source and the policy contains the attribute which changes i.e. firstname.

In that case when the firstname changes for the identity it should trigger the update prov policy automatically but that is not happening for me

4

Also for attr sync to work to we need to make sure create account/update account prov policy attr should match the attr name in schema?

image
image1171×556 22 KB

5

Yes they should always match.

In addition to this you need to create/update the JDBC Provisioning rule to execute required SQL Query to update the database table with new values