Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

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?

share|improve this question
add comment

1 Answer

up vote 3 down vote accepted

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:

http://www.kowalski.ms/2010/07/20/sharepoint-server-2010-supplementing-user-profile-imports-using-bcs/

share|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
    
thanks Chris for the additional info –  naijacoder Oct 10 '11 at 7:38
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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