Omicron Development16 Union StreetMedford, NJ 08055

Leveraging SharePoint User Profiles

to Enhance Effectiveness and Efficiency

Gary ClaytonPh: 609-678-0110

609-678-0110Omicron Development LLC

Corporate View:Homogeneous but Severable

609-678-0110Omicron Development LLC

Operations ViewLimits on Accessibility and Quality

609-678-0110Omicron Development LLC

609-678-0110Omicron Development LLC

Edit User Profile Property:- Allows only One Source

609-678-0110Omicron Development LLC

Data Cache DB

Data Consolidation Approach

Other DBs

Buffer

Extended UserProfiles

609-678-0110Omicron Development LLC

Five Step Method

1. Update data from External Lists to Data Cache

2. Replicate Data from 3rd Party Systems (i.e., Payroll/HR) to the Data Cache

3. Merge/Manipulate Data into common formats

4. Data Cache Merge

5. User Profile Synchronization

609-678-0110Omicron Development LLC

1SharePoint External Lists update DataCache buffer tables

SW Package

DBs

External Lists

DataCache

DB

Create Common Data Formats

Profile Merge Routine

Extended UserProfiles

609-678-0110Omicron Development LLC

2SQL Server Integration Services copies data from packages to DataCache buffer tables

DataCache

DB

Create Common Data Formats

Profile Merge Routine

SW Package

DBs

External Lists

Extended UserProfiles

609-678-0110Omicron Development LLC

3Merge/Manipulate buffer tables into common data column formats

DataCache

DB

Create Common Data Formats

Profile Merge Routine

SW Package

DBs

External Lists

Extended UserProfiles

609-678-0110Omicron Development LLC

4sp_MergeAllColumns consolidates all data sources based on priority

DataCache

DB

Create Common Data Formats

Profile Merge Routine

SW Package

DBs

External Lists

Extended UserProfiles

609-678-0110Omicron Development LLC

SharePoint User Profile Sync can now access a single source

609-678-0110Omicron Development LLC

Finale:SharePoint User Profile Sync brings in A/D and DataCache

DataCache

DB

Create Common Data Formats

Profile Merge Routine

SW Package

DBs

External Lists

Extended UserProfiles

609-678-0110Omicron Development LLC

People Search Refinement Panel

- Add Categories in Display Order- Set Parameters

Max is 500 => Use It!

Set Larger as Needed

Uncheck box

609-678-0110Omicron Development LLC

People Refinement PanelAdd Categories in Display Order

<Category Title="spshjobtitle" Description="Use this filter to restrict results to a specific job title" Type="Microsoft.Office.Server.Search.WebControls.TaxonomyFilterGenerator" MetadataThreshold="3" NumberOfFiltersToDisplay="10" MaxNumberOfFilters="50" ShowMoreLink="True" MappedProperty="ows_MetadataFacetInfo" MoreLinkText="show more" LessLinkText="show

fewer“/>

609-678-0110Omicron Development LLC

People Refinement PanelAdjust Category Properties

<Category Title="Managed Metadata Columns" Description="Managed metadata of the documents" Type="Microsoft.Office.Server.Search.WebControls.TaxonomyFilterGenerator"

MetadataThreshold=“1" NumberOfFiltersToDisplay="10" MaxNumberOfFilters="50" ShowMoreLink="True" MappedProperty="ows_MetadataFacetInfo" MoreLinkText="show more" LessLinkText="show fewer“

/>

609-678-0110Omicron Development LLC

Presented by:Gary Clayton