Workflow or Extension: Update SQL column based on CRUD Operation
I am looking for some direction on the described scenario: We have an SR that that passes data from AD to a SQL table through FIM 2010, such as userName, firstName, lastName.... I have set up a SR to provision and update data successfully based on a set. The issue I have is there is a status column in the SQL table that needs updated when an operation occurs. On a Create (Provision) send "YES" to the STATUS column, which I am able to do. I set this flow rule as initial flow only. Next, when the userName, firstName or lastName changes (in AD), I would like the columns to change, as well as update the STATUS column with "ALTER". I am not sure what is the best course of action to flow the STATUS column based on the operation type. Any help or suggestions would be greatly appreciated. Thank you, sig
June 10th, 2011 3:19pm

If I were you I'd put a trigger on the SQL table and leave FIM out of the picture for this part.My Book - Active Directory, 4th Edition My Blog - www.briandesmond.com
Free Windows Admin Tool Kit Click here and download it now
June 10th, 2011 5:00pm

I too am a fan of a SQL trigger or two :) ... and in this case that would seem to be the simplest approach. If I had to do this in FIM, however, the way I would approach it would be to preceed the EAF sync rule activity with a function evaluator activity to set [//Target/Status] to your "ALTER" constant ... that way you can nominate all of your target columns and changes to any one (or more) of them will set the status value for you.Bob Bradley, www.unifysolutions.net (FIMBob?)
June 10th, 2011 11:17pm

Thank you both. I was so keyed in on FIM that I did not even think of the triggers.
Free Windows Admin Tool Kit Click here and download it now
June 13th, 2011 9:27am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics