Import SQL Table data into UPS

by bronyx85 at 2013-03-11 03:48:42

i have a sql table, contains columns such as email and telephone number. i would like to import this information into THAT users user profile.

How can this be achieved in sharepoint 2013?

i presume some sort of bcs connection?, does anyone have any instructions on how to do this?

thanks in advance
by AlexBrassington at 2013-03-11 04:05:03
BCS is right. I’ve never tried using BCS with powershell butbthere should be q few examples of general UPS / BCS use on Google somewhere.
by bronyx85 at 2013-03-11 08:16:46
it should be possible OOTB, I have tried created a external content type
followed these instructions … using-bcs/

but its not working !!.. aaahh!!!
by AlexBrassington at 2013-03-11 10:22:07
Is UPS working happily otherwise? Its the worst part of SharePoint and they’ve made massive improvements even after SP1 so patching might be needed. For all things UPS you should check Spence Harbar’s blog.
by bronyx85 at 2013-03-12 08:01:29
Yes, UPS is working fine.
its importing users from AD fine.

But I just need to add extra fields to some of the users , and this extra data lives in a SQL table (i.e a FBA table).