Change in columns in a mapping

Question

Hi All 
 
 We have a custom table to provision to an specific database. We've implemented a custom proccess to provision that database. We have 2 problems 
 If one colum changes the process only updates the change in that column and ignore others. To not introduce in the generating condition all columns that a change should run the provision process. Is there anyway to act like AD conector that detects changes on columns affected in a mapping? We only want the proccess to launch if the columns are associated to the mapping as that table has other columns that should not lauch the proccess and thats why we could not use event update alone for that tables. 
 Is there anyway that even if one column change and the proccess launches, sync proccess compare all other columns with the database and not ignore other those? 
 
 We are using adhocprojection single for the step in the process 
 
 Regards 
 
 Leticia

Markus Weiss-Ehlers · Accepted Answer

I suggest contacting support. To make an educated guess on your issue, you would need to share too many details with the community. (Sync project configuration including details about your mapping, a trace log of the failed (or wrong) ad-hoc process step, description of your issue in more detail - why do you need all properties including unchanged ones for the sync, what database action needs to be triggered by the connector etc.).

Markus Weiss-Ehlers · Answer

The database connector works in the same way like the AD connector in regards to detecting changes. If you want to generate the process only if a specific set of columns has changed, you have to code this check in your generation condition of the process. 
 To enforce the sync of specific columns you can use the ForceSyncOf parameter of the provisioning process step.

Change in columns in a mapping

Top Replies