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?


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

| 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 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.