I am having some issues getting this working as I would like. We are on SharePoint 2010 SP1 Dec 2012CU.
I am able to get it working with a 1:1 mapping, but ultimately want to get multiple "skills" added to the user skills property.
To map the two systems, I am using an application ID that we have also store in AD. I have read that possibly using an integer for 1:many mappings doesn't work, so that could be some of my issue, as I am using that to compare to on the filter.
In the source there is a view that has all of the skills, username, and applicationID, with many rows for most users corresponding to a new skill.
I know there is no permission issues in the setup, as I'm able to get it to work using 1:1, once the filter it removed.
I am using SPD to create the BDC, if there are better alternatives, I am certainly open to them.