1 / 9

Extending User Profiles with Line of Business Data

Extending User Profiles with Line of Business Data. Patrick Curran, MCT. January 5, 2013. Please be sure to thank and visit our Sponsors!!. Platinum Sponsors. Gold Sponsors. Silver Sponsors. Patrick Curran. MCT, MCITP, MCTS, MCP Director, Federal Practice, Planet Technologies.

gretchen-griffin
Download Presentation

Extending User Profiles with Line of Business Data

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Extending User Profiles with Line of Business Data Patrick Curran, MCT January 5, 2013

  2. Please be sure to thank and visit our Sponsors!! Platinum Sponsors Gold Sponsors Silver Sponsors

  3. Patrick Curran • MCT, MCITP, MCTS, MCP • Director, Federal Practice, Planet Technologies. • SharePoint Architect. • Co-Author of Microsoft SharePoint 2013: Designing and Architecting Solutions. (Pre-Release Sale at Amazon) • Working with SharePoint since 2003. PCfromDC.blogspot.com @PCfromDC

  4. Describe scenario and objective. • Prerequisite. • Review farm and verify prerequisite. • Review SQL Login and Stored Procedure. • Review Secure Store Target Application. • Create External Content Type and List. • Sync SQL Data to UPS. • Verify it all works… • Conclusion.

  5. Scenario and Objectives Scenario: CIO says that we must now start tracking employee social media handles and URLs. The CIO wants the users to maintain their own information (including PII). AD team says no way to bi-directional synchronization with the UPS. HR already has a database with staff information. Objectives: • Give the CIO a database with all of the employee social and HR information. • Give the end-user the ability to securely see and update only their information. • Have the end-user information available on SharePoint for others to see and use. Let’s get started!

  6. Prerequisite and Farm Information Prerequisite: UPS is running and synchronizing without error. If you are not at this stage I recommend the following articles to get you started. http://technet.microsoft.com/en-us/library/ee721049.aspx http://www.harbar.net/articles/sp2010ups.aspx Farm Information: Let’s get started!

  7. Data Flow

  8. Conclusion Having the ability to distribute social information is very important, but having the ability for a user to modify their information without having to send an email to the AD Team is crucial to keep data updated and reliable. By following the steps that we reviewed, we can keep staff up to date with their social information and keep the OCIO happy. We can now view all user social information, and have it synchronized with the User Profile Service!

  9. Thank You!!! Email: pcurran@go-planet.com Blog: PCfromDC.blogspot.com Twitter: @PCfromDC

More Related