How to Map the value of one attribute to other attribute in Active directory with the help of AD connect

Question

Hi All,

we have 2 attribute on active directory.

1. Division = Employee1/technician (/Worker, /contingent worker etc)
2. Extensionattribute10 = No value

We want to trim the Division value like remove the characters after the slash "/" this we achieved by the below expression.

"IIF(InStr([division], "/") > 0, Left([division], InStr([division], "/") - 1), [division])"

but now we are looking to map this trimmed Division value with Extensionattribute10 attribute with the help of AAD connect.

we tried to map the Values but the values are not refecting under Extensionattribute10 attribute

can anyone help us where are missing in this.

Answer 1

Hello Prince,

To map a trimmed Division attribute value to extensionAttribute10 in Active Directory with Azure AD Connect:

• Ensure Expression: Use this transformation to trim Division:

      IIF(InStr([division], "/") > 0, Left([division], InStr([division], "/") - 1), [division])
  

• Set Up Attribute Mapping in Azure AD Connect:
  • Open Azure AD Connect > Customize synchronization options > Attribute Mapping.
  • Select extensionAttribute10, set FlowType to Expression.
  • In Source, paste the transformation expression above.
  • Set Merge Type to Update.
• Run Full Sync:
  • In Azure AD Connect Synchronization Service Manager, perform Full Import and Full Synchronization on both Active Directory and Azure AD connectors.
• Verify Results: Check in AD to confirm extensionAttribute10 is updated with the trimmed Division value.

References

• Azure AD Connect Sync: Attribute Mapping Documentation

If the information helped address your question, please Accept the answer.

Luis