Solved

SharePoint 2007 profile - Add attribute not in AD

Posted on 2010-11-29
1
430 Views
Last Modified: 2012-05-10
We have our SSP set up to populate many attributes from AD to SharePoint.  Some are custom attributes in AD and everything works fine.
Now I've been asked to include information NOT in AD.  The information is available in a SQL database and there is a common demoninator (Employee ID).
How can I add this additional information into the user profiles?
Thanks
Ron
0
Comment
Question by:Capt_Ron
1 Comment
 
LVL 7

Accepted Solution

by:
arduk earned 500 total points
ID: 34233646
A couple of options spring to mind that may help you to solve this:
1. Use the BDC - there is an article on populating user profiles from the BDC here: http://statto1974.wordpress.com/2007/11/02/using-the-bdc-to-populate-user-profiles-from-a-sql-server-database-part-two/ 
2. If the BDC solution is not going to work, then I would consider adding the information into AD (this may involved a schema change to AD, or you may be able to use an existing unused field), and then mapping it through using the standard mapping. You would then need to setup some sort of script to update the AD field from your SQL DB as required.

I haven't actually tried either of these, but that is where I would start investigating....

Hope this helps...
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
sharepoint 2013 calendar change like sharepoing blog formate day above month 1 22
Date Differences SSRS 3 59
SharePoint 2010 Versioning 2 30
sharepoint online 3 35
Summary In SharePoint 2010 it is easy to create custom color themes to jazz up a site. Theme colors can also be created in PowerPoint 2010 with a few clicks. But how do the chosen colors actually look in the SharePoint site? The attached PowerPoint…
I thought I'd write this up for anyone who has a request to create an anonymous whistle-blower-type submission form created using SharePoint 2010 (this would probably work the same for 2013). It's not 100% fool-proof but it's as close as you can get…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now