SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm currently working on a SharePoint Standard 2010 project.

I would have preferred to use the User Profile Service to sync with AD to populate employee details, but our AD doesn't have much information.

But we have the employee list stored in a SQL Server table so I'm thinking of using BCS.

My question is if I use BCS to populate the employee list will users be able to search employee details if I use the "Basic Search Center Template" or will I have to use "SharePoint Enterprise Search in SharePoint Server 2010"

Thanks in advance

share|improve this question
up vote 0 down vote accepted

You can write custom bcs synchronization connection, that consume data from sql table and map it to user profile properties. This procedure involves creating bcs solution, adding Business DataCatalog Connection to synchronization connections, and setting up mapping between bcs rows and user profile properties. If you map it to standard properties, they should appear in any search.

share|improve this answer
Thanks Kai. If i create ECTs(External Content Types) in sharepoint designer and then use it to populate a list.Will this appear in search? – naijacoder May 16 '12 at 12:20
I am not 100%, but it should. Give it a try. – Kai May 16 '12 at 12:38
ok one more question here. Is there a way i can use User Profile service to use data from external source like from Sql server tables? Cheers and thanks alot – naijacoder May 17 '12 at 7:31
Yes, you can. You should create bcs model, and then add new synchronization connection under user profile service application. Next step is to setup mappings between your bcs elements (such as Name, Job title, location, etc) and profile properties. Take a look at this article, it describes some basic concepts. – Kai May 17 '12 at 10:27
Thanks the article was about BDC not BCS i'm on SP 2010 – naijacoder May 18 '12 at 1:20

Your Answer


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.