Augmenting User Profiles with Line of Business Data

Augmenting User Profiles with Line of Business Data Patrick Curran, MCT April 28, 2012

Patrick Curran • MCT, MCITP, MCTS, MCP • Director of Operations, Federal for Planet Technologies. • SharePoint Architect. • Working with SharePoint since 2003. • Administrator / Developer • Architect / Implementer • Troubleshooting / Branding PCfromDC.blogspot.com @PCfromDC

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.

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!

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!

Verify Users in UPS In Central Admin  Application Management  Manage Service Applications User Profile Service  Manage User Profiles

Verify Users in UPS If your names are not showing up, and you know that your User Profile Service is running correctly, you might want to check your synchronization connections to make sure the OU is part of your sources to synchronize (Central Admin  Application Management  Manage Service Applications User Profile Service  Configure Synchronization Connections). You also might have to manually start a profile synchronization (Central Admin  Application Management  Manage Service Applications User Profile Service  Start Profile Synchronization).

Create SQL Account

Quick Review of SQL… The GET stored procedure:

Let’s Get Started… • Create the Secure Store Target Applications • We are now going to create the accounts that will be used to access our data on the BI database. We are going to create a Read/Write application ID. Start off by going to Central Admin  Application Management  Manage Service Applications  Secure Store Service Application. If you get this screen, please click the Generate New Key button in the ribbon and follow the directions…

Create the Secure Store Target Applications

Create the Secure Store Target Applications Add your Application Administrator and click OK to create the SQL Read/Write Application. We now need to add the Login Name and Password to the Application:

Create the Secure Store Target Applications

Create External Content Types Warning: If you are going to create your External Content Types using Windows Authentication, you will want to run SharePoint Designer from within SharePoint’s Domain. We now are going to open up SharePoint Designer 2010 and open up our BI Site. In the Navigation Pane, you will see a Site Object call External Content Types, and select it. If everything in the Ribbon is greyed out, click inside of the External Content Type work area (somewhere near the middle of the screen) to activate the buttons. Click New External Content Type…

Create External Content Types

Set BDC Obj Permissions Central Administration  Application Management  Manage service applications  Business Data Connectivity Service

Set BDC Obj Permissions

Create External List

Sync Data to UPS Now that we have verified that our external data is making it across, and that we can update and read our data, let’s synchronize it up to our User Profile Service! Here is our UPS summary to start. Notice the Properties, there are 68.

Sync Data to UPS

Sync Data to UPS Next, we need to add our Social Information to our User Properties. Central Admin  Application Management  Manage Service Applications  User Profile Service  Manage User Properties  New Property If you want to create a new Section for the Social Information, create it now, otherwise your new properties will end up in the Custom Properties Section

Sync Data to UPS Do the same thing to import the other 3 properties…

Sync Data to UPS Now that we have our new properties added, let’s take a look at our UPS summary…

Sync Data to UPS Let’s click on Manage User Profiles and look at Fred… (Central Admin  Application Management  Manage Service Applications  User Profile Service  Manage User Profiles)

Update Data So now, let’s update Fred’s information by going to our list, and entering some Data…

Update Data The final thing we have to do, is run a Full Profile Synchronization (Central Admin  Application Management  Manage Service Applications  User Profile Service  Start Profile Synchronization  Start Full Synchronization  OK)

Verify Data Now let’s look at Fred’s MySite…

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 above, 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!

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

Augmenting User Profiles with Line of Business Data