User Profile Service Application is used to synchronize the data from Active Directory to SharePoint. User Profile data is maintained by the Profile Database in SharePoint. the profile Database is used to store and manage users' information. In some scenarios you may require getting the data for the user profile from an external system. Here you will see how to get the data for the user profile from a SQL database using Business Data Connectivity services. Here I will be creating some custom user properties and map those user properties to the columns in the SQL database so that those user properties will get the values from the external system SQL database using BCS. SQL Server Database Details I will be using a SQL Server database as an external data source from where the data will be imported for the user profiles in SharePoint 2010. A database named "BCS Database" is created in SQL Server which contains the following tables. Figure : BCS Database in SQL Server EmployeeDetails table: EmployeeDetails table contains the following columns
Figure : EmployeeDetails table column names and data types EmployeeDetails table contains the following rows Figure : EmployeeDetails table rows Create New User Properties
Configure Synchronization Connection
Add Mapping to User Property
Edit the user profile
Start Full Synchronization
In this article we have seen how to import the data from external system like SQL database to SharePoint User Profiles using BCS.
You need to be a premium member to use this feature. To access it, you'll have to upgrade your membership.
Become a sharper developer and jumpstart your career.
$0
$
. 00
monthly
For Basic members:
$20
For Premium members:
$45
For Elite members: