User profile property data types (SharePoint Server 2010)
Applies to: SharePoint Server 2010
When you map a SharePoint Server 2010 user profile property to an element in an external system, the property and the element must have compatible data types. This article identifies Active Directory Domain Services (AD DS) data types and the .NET data types that are compatible with the data types of SharePoint Server 2010 user profile properties.
In this article:
AD DS data type compatibility
.NET data type compatibility
AD DS data type compatibility
The following table lists the AD DS data types that are compatible with each user profile data type.
| User profile service data type | AD DS data type |
|---|---|
big integer |
Large Integer, Integer |
binary |
Octet String, SID |
boolean |
Boolean |
date |
UTC Coded Time |
date no year |
UTC Coded Time |
date time |
UTC Coded Time |
Unicode String, IA5-String, Case Insensitive String |
|
float |
Unicode String |
HTML |
Unicode String, IA5-String, Case Insensitive String |
integer |
Integer |
Person |
Distinguished Name |
string (multi-value) |
Unicode String, IA5-String, Case Insensitive String |
string (single-value) |
Unicode String, IA5-String, Case Insensitive String |
time zone |
Integer |
unique identifier |
Octet String, SID |
URL |
Unicode String, IA5-String, Case Insensitive String |
Note
The AD DS attribute unicodePwd is an octet string, but SharePoint Server treats it as a Unicode string for the purpose of profile synchronization.
.NET data type compatibility
When you create an external content type in SharePoint Server 2010, you specify the .NET data type of each column of the external content type. If you map user profile properties to columns of an external content type by using a Business Data Connectivity connection, the data types must be compatible. The following table lists the user profile property data types that are compatible with each .NET data type.
.NET data type |
User Profile service data type |
System.Boolean |
Boolean |
System.String |
String (Only multi-value string is supported) |
System.DateTime |
Date/DateTime |
System.Int64 |
BigInteger |
System.Int32 |
BigInteger/Integer |
System.Int16 |
BigInteger/Integer |
System.SByte |
BigInteger/Integer |
System.UInt64 |
BigInteger |
System.UInt32 |
BigInteger/Integer |
System.UInt16 |
BigInteger/Integer |
System.Byte |
BigInteger/Integer |
System.Single |
Float |
System.Double |
Float |
Note
You cannot use a business data connectivity connection to map a binary property to a property that implements the Stream accessor method.
See Also
Concepts
Default user profile properties (SharePoint Server 2010)
Plan for profile synchronization (SharePoint Server 2010)