EDIT I'm sorry to have asked such a n00b question, I guess creating a rules extension in VS is the obvious answer, right? The Technet software req's listing only mentions VS2008, but I take it that VS2010 will be alright? Thanks! ------------------------------------- I have an nvarchar column in an SQL2005 db. The db is a source for user creation for an AD. I need to MD5 hash and Base64 encode the values (one per user that is to be created/updated) and put the result in an AD attribute, per user object. Actually, since I'm gonna use the value as the primary key for a lot of operations on the users, so I need it in the metaverse user objects too. I know how to MD5 hash the value with SQL, but I can't figure out a nice clean way to Base64 encode the resulting nvarbinary. (It's not impossible, but ugly.) I'm new to FIM and have no idea how to deal with this the best way. I was thinking I could write a custom function in C#, but it appears custom functions aren't supported in FIM? Any ideas would be greatly appreciated!

There is no facility for custom synchronization functions in the FIM Portal. You could create a custom workflow step and run stuff through the portal, but if your data isn't already runing through the Portal, it would be a lot of overhead. It would be trivial to do it as a management agent extension (rules extension) as you mentioned. You could also look at creating a custom SQL server function, which you can write in C#. (I haven't personally done this, but it doesn't look too hard: http://msdn.microsoft.com/en-us/library/w2kae45k%28VS.80%29.aspx)