I’ve put together a screencast that shows how to use your data from an external source such as a SQL Server database and combine it with your user profiles.
The screencast shows how to:
- Import the application definition to setup the BDC application
- Setup a custom import connection of type business data catalog and how to set the key between active directory account and BDC data
- Setting up custom profile property section (the example is cricket statistics)
- Setting up custom profile properties that import data from the BDC data source
- Start a full import
- Perform a search which returns the user and show the new data that is displayed in the users profile page.
A good quality version of the screen cast can be found here (4 mins).
Or the low quality youtube version: