Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

User profile property data types in SharePoint Server 2013

Published: October 23, 2012

Summary: Learn about user profile property data types for the User Profile service in SharePoint Server 2013.

Applies to:  SharePoint Server 2013 

When you map a SharePoint Server 2013 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 2013 user profile properties.

In this article:

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 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 2013, 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 Note:

You cannot use a business data connectivity connection to map a binary property to a property that implements the Stream accessor method.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.