Share via


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

E-mail

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)