Surfacing Your Application's LineofBusiness Data Within Microsoft Office SharePoint Server 2007 - PowerPoint PPT Presentation

Loading...

PPT – Surfacing Your Application's LineofBusiness Data Within Microsoft Office SharePoint Server 2007 PowerPoint presentation | free to view - id: 1ed6c0-ZDc1Z



Loading


The Adobe Flash plugin is needed to view this content

Get the plugin now

View by Category
About This Presentation
Title:

Surfacing Your Application's LineofBusiness Data Within Microsoft Office SharePoint Server 2007

Description:

... Line-of-Business Data Within Microsoft Office SharePoint Server 2007 ... blogs, wikis, e-mail integration, project management 'lite', Outlook integration, ... – PowerPoint PPT presentation

Number of Views:22
Avg rating:3.0/5.0
Slides: 15
Provided by: sharepoint1
Category:

less

Write a Comment
User Comments (0)
Transcript and Presenter's Notes

Title: Surfacing Your Application's LineofBusiness Data Within Microsoft Office SharePoint Server 2007


1
Surfacing Your Application's Line-of-Business
Data Within Microsoft Office SharePoint Server
2007
  • Michael Gannotti
  • Portal Technology SpecialistMicrosoft
    Corporation
  • www.mikegannotti.com

2
SharePoint Feature Areas
Docs/tasks/calendars, blogs, wikis, e-mail
integration, project management lite, Outlook
integration, offline docs/lists
Server-based Excel spreadsheets and data
visualization, Report Center, BI Web Parts,
KPIs/Dashboards
Platform Services
Rich and Web forms based front-ends, LOB actions,
pluggable SSO
Enterprise Portal template, Site Directory, My
Sites, social networking, privacy control
BusinessForms
Workspaces, Mgmt, Security, Storage, Topology,
Site Model
Content Management
Search
Enterprise scalability, contextual relevance,
rich people and business data search
Integrated document management, records
management, and Web content management with
policies and workflow
3
Customer NeedsBased on SPS 2003 feedback
  • Less integration code
  • Deep integration of data into the places users
    work
  • New application types that blend data and
    collaboration
  • Bridge portal and business application UI
  • Centrally manage security policy, auditing
    policy, connections

4
Business Data Catalog (BDC)Connects Office
servers to business data
Web Parts
Lists
Search
User Profiles
Custom Apps
Metadata
Business Data Catalog
WS Proxy
ADO.NET
Database
Web Service
SQL Server, Oracle, OLEDB, ODBC
BizTalk, SAP, Siebel, Legacy,
5
Business Data SearchSearch data, not just
documents
  • Scenario Find an account manager in Siebel
  • 2003
  • Vertical applications lack full-text search
  • Most users cant locate or access vertical apps
  • Hard to crawl business data with SharePoint
  • Today Search any database or web service
  • No need to write custom IFilters or protocol
    handlers
  • No need to create HTML representations of data
  • Highly customizable results
  • Integrated with scopes and search center

6
Full-Text Siebel Search
7
Business Data in ListsCollaborate around
business data
  • Scenarios
  • Tag a proposal with a customer
  • Track and annotate key support cases
  • Pick from the canonical list of cost centers
  • 2003
  • Text or lookup fields
  • Irregular data, duplicated lists of values
  • Today Business data column
  • One column type that stores any entity
  • One-click refresh
  • Integrates with list features workflow,
    versioning, etc.

8
Business Data in User ProfilesBusiness-specific
targeting and personalization
  • Scenarios
  • Show features owned by a Microsoft PM!
  • Show SAP employee ID
  • 2003
  • No easy way to augment user profile with
    non-Active Directory data
  • Today Join user profile store and BDC
  • Map user profile property to field of entity
  • User profile importer does the rest

9
User Profile Information
10
Business Data Web PartsSimple business apps with
no code
  • Scenario
  • 360-degree view of customer
  • 2003
  • Clipping, custom web parts, data view
  • Today Reusable biz data web parts
  • Show new data with no new code or binaries
  • Master-detail applications with no code
  • Integrated with dashboards and filters

11
Business Data Web Parts
12
Food For Thought
  • BDC data access is one method of surfacing
    business data in SharePoint
  • KPIs
  • Excel Services
  • XSLT
  • Performance Point
  • Silverlight
  • More
  • Where possible look to consolidate and simplify
    data access. You own SQL and its OLAP technology
    use it!

13
Resources
  • SharePoint Server 2007 SDK Software Development
    Kit
  • Microsoft Office SharePoint Server on Technet
  • Business Data Catalog Resource Center on MSDN

14
?
About PowerShow.com