I've got my external content type and BCS all sorted and working - the list view of the external list shows 100% in the site and the external content type shows under my BCS service application.

Now I want to create a connection to this in my user profile synchronisation in order to map some additional info from this list to my user profiles (if possible using the email field as the 1-on-1 identifier). As soon as I try to do this I either get "External Content Types are not available" if I try to see what ECTs are available when adding the new synchronisation connection or the drop down for "Return items identified by this profile property" is empty if I manually enter the ECT name (and when I do the latter it finds the ECT)

Any ideas as to what I'm doing wrong?

  • Have you set correct permissions for both BCS and UPA (both connection and administrative permissions) Apr 19, 2011 at 17:51
  • Hi Anders, The connection account is the same for both and the administator for the service apps is the same on them all (ie myself).
    – TessaH
    Apr 20, 2011 at 7:11

2 Answers 2


This took me a while to figure out. Not sure if it's the same situation. For me, it was one particular DB causing the issue. Turns out the identifier in my ECT was a system.guid which sharepoint has shortcomings in. I had to change the identifier to a different field in my ECt.


Please drive through the whole process again and make sure to check whether your ECT has set object permissions "Execute" and "set permissions" in the Business Data Connectivity services service application.

  • This would make a better comment than an answer. Please make comments comments and answers answers in the future, this can affect the question openers acceptance score.
    – Hugh Wood
    Nov 20, 2012 at 10:18

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.