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 have configured the user profile syncing with my custom SQL table. i require 4 properties that are with 6 columns in the table

& the scenario is i have to concatenate the strings of the 3 columns of sql table in one property of user profile.

say sql structure is like

customer_id number(10) not null, customer_name varchar2(50) not null, address varchar2(50),
city varchar2(50),
state varchar2(25), zip_code varchar2(10),

i want to map address property of user profile with string = address + city + state

please suggest any way to achieve this .

share|improve this question

This type of conditional behaviour is not suitable for a normal BCS connector. Instead create a .NET connectivity assembly that encapsulates your SQL calls, for example in LINQ, and create the logic in C#.

More info here

share|improve this answer
Adding on by normal BCS connector Ander's means Database connector – Ram Gopinathan Oct 16 '11 at 22:08

Not sure how to do it with BCS, but with PowerShell it would be pretty easy:

In the aboce example it uses a .csv file for data, but obviously other data connections could be utilized.

share|improve this answer

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.