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
- My first option is to use Visual webpart to display the data
- Or even use Dataview Webpart -Sharepoint Designer
- 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
- 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?