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

What is the purpose of the 1:1 option within the Custom Import Connections when selecting the BDC?

I initially thought that 1:1 was 1 record per user profile, but it is actually the set of profiles, which I think means you would essentially set a single field in all profiles to a value returned from the BDC. If that is correct then there isn't much value there.

Any input?

share|improve this question
up vote 1 down vote accepted

When you set up BDC as a secondary data source for your user profiles, you need to have a unique identifier to connect AD and database (usually initials or similar). That one field is mapped against the AD, but you can extract as many fields as you want from database.

Use 1:1 when you have an exact match (like mail or initials), use 1:many if you are mapping up against a table with more than one field per user. That btw would require you to add a filter method to your application definition.

hth Anders

share|improve this answer
That is pretty much what I thought, but I could only get it to work when it was setup 1:many. In this case I'm pulling in additional details from the HRIS system to map fields like Title and Job Function. When I contacted MS Support about the problem they asked me to use the 1:many. – Mike Oryszak Nov 23 '09 at 14:27
a typical example of a 1:1 field would be Samaccountname or even better email from AD being mapped to your database as unique id – Anders Rask Nov 23 '09 at 14:47

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.