This is the scenatio:

I have an AD that i'm going to use when installing SP 2010 but it doesn't have a lot of meta data as in poperties its only got : Lastname, fistname and email etc.. So i would like to import the employee list from sql server.

I would like SharePoint to know about the data as i would be able to use it in the future for lists etc.. Some options here

  1. My first option is to use Visual webpart to display the data
  2. Or even use Dataview Webpart -Sharepoint Designer
  3. But there is also BCS which i can import the data to SQl but the thing is i won't be really doing any update so it won't be really beneficial unless there are advantages i don't know about and thats why i'm posting this question
  4. Since also i won't be having much content from AD i'm thinking of importing it into user profile and then using the data as an employee list.

Is this possible?


You can map User Profile properties to BCS connections as long as there is a unique identifier on your SQL data that can map to a unique property in the User Profile. Here is a blog post that can walk you through it:


| improve this answer | |
  • Thanks mate will have a good read.More ideas or resources will also be appreciated – naijacoder Oct 8 '11 at 4:51
  • Well, I believe that using BCS to extend User Profiles is your best answer. Other choices would be a) a custom SharePoint timer job to synchronize a custom SharePoint list with your SQL data, or b) a PowerShell script to synchronize the data, etc. The advantages of the BCS solution are a) the data is searchable, b) it can be accessed from any Site Collection, c) it can be viewed easily on a MySite (optional configurable) d) in terms of developing custom UI, it is easy to access through the SharePoint API. – Chris Beckett Oct 8 '11 at 21:02

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.