Composite Applications with SharePoint

1
Welcome to the Nebraska SharePoint User Group
October 3rd, 2007 Building Composite Applications
on the SharePoint Platform
Raymond Mitchell Inetium
http//www.sharepointne.com
2
User Group Goal / Objectives

• Develop and support a local community focused on
  Microsoft SharePoint Technologies
• Educate user group members about SharePoint
  Technologies
• Transfer knowledge within the community
• Communicate best practices
• Introduce new products / solutions

http//www.sharepointne.com
3
Introductions NESPUG Sponsors

• Inetium (www.inetium.com)
• Technology consulting company
• Microsoft Gold Certified Partner
• Practice area focused on SharePoint
• Gallup (www.gallup.com)
• Microsoft (www.microsoft.com)
• Im guessing youve heard of them

http//www.sharepointne.com
4
www.sharepointne.com

• Website for user group
• SharePoint resource documents
• SharePoint resource links
• RSS Feeds
• Meeting Schedule
• Past User Group Presentations
• (Also check www.sharepointmn.comfor additional
  material)

www.sharepointne.com
http//www.sharepointne.com
5
Upcoming Schedule

• Next Meeting
• November 7th 900 AM to 1130 AM
• Ongoing Schedule
• 1nd Wednesday of every month
• 830 to AM 1130 am

http//www.sharepointne.com
6
Previous Meetings and Resources

• SharePoint 2007 Overview May 2006 MNSPUG
  Presentation This presentation provides an
  overview of a number of the key features and
  capabilities that SharePoint 2007 provides.
  http//www.sharepointmn.com/User Group
  Presentations/May 2006 MNSPUG.ppt
•  
• Document Management / Records Management June
  2006 MNSPUG Presentation This presentation
  covers how documents and records are managed
  using SharePoint.  This presentation also covers
  SharePoint Content Types. http//www.sharepointmn.
  com/User Group Presentations/June 2006 MNSPUG.ppt
  
•  
• Workflow  July 2006 MNSPUG Presentation This
  presentation covers how workflow and digital
  forms work in SharePoint 2007.  http//www.sharepo
  intmn.com/User Group Presentations/July 2006
  MNSPUG.ppt
•  
• Business Intelligence  August 2006 MNSPUG
  Presentation This presentation covers many of
  the new features of SharePoint 2007 that are used
  to address Business Intelligence including
  Dashboard sites, Key Performance Indicator (KPI)
  lists, Excel Services and the filter web parts. 
  http//www.sharepointmn.com/User Group
  Presentations/August 2006 MNSPUG.ppt
•  
• Web Content Management  September 2006 MNSPUG
  Presentation This presentation focuses on the
  web content management features of SharePoint
  2007 that allow end users to publish their own
  web content (ex articles).  http//www.sharepoint
  mn.com/User Group Presentations/September 2006
  MNSPUG.ppt
•  
• Search, Business Data Catalog (BDC), and the
  Knowledge Network October 2006 MNSPUG
  Presentation This presentation focuses on the
  search capabilities of SharePoint 2007 including
  leveraging the Business Data Catalog. 
  http//www.sharepointmn.com/User Group
  Presentations/October 2006 MNSPUG.ppt

http//www.sharepointne.com
7
Agenda

• Quick Intro
• Composite Applications 101
• Out of the Box
• SharePoint Designer
• Data View and Data Form Web Parts
• Custom List Forms
• Advanced Data View Web Parts
• Advanced Composite Applications

http//www.sharepointne.com
8
Composite Applications 101
Composite Applications 101
9
What are Composite Applications ?
A Composite Application consists of
functionality drawn from several different
sources within a service oriented architecture
(SOA). wikipedia (9/30/07) Interactive
tracking, reporting, and data management
applications built using Office SharePoint
Designer 2007 no code features. - Microsoft
Office Online
Composite Applications 101
10
Composite Applications
Dashboard
Composite Applications 101
11
Composite Applications
Data Query Page
Composite Applications 101
12
Out of the Box
Out of the Box
13
What can I do Out of the Box?

• Custom Lists / columns
• Views (filtering/sorting)
• Custom Pages
• Connected Web Parts
• Form Web Part
• Navigation Management

Out of the Box
14
SharePoint Designer
SharePoint Designer
15
What is SharePoint Designer?
SharePoint Designer
16
SharePoint Designer

• Master Pages
• Workflow
• Custom ASPX Pages

SharePoint Designer
17
SharePoint Designer

• Ghosted and Un-Ghosted Pages what you need to
  know

SharePoint Designer
18
Data View and Data Form Web Parts
Data View and Data Form Web Parts
19
Data View and Data Form Web Parts

• Reading data from a List
• Format As ?Intro to XSLT
• Custom Filter/Sorting
• Conditional Formatting
• Parameters (Master/Detail Example)
• Reading data from an XML file, SQL Database, Web
  Service
• Single Sign On / Kerberos considerations

Data View and Data Form Web Parts
20
Data View and Data Form Web Parts

• Simple CRUD operations for non-SharePoint data
  (XML File)
• Custom forms with custom (workflow) actions

Data View and Data Form Web Parts
21
Break
5 10 minutes
22
Custom List Forms
Custom List Forms
23
Custom List Forms

• Custom Layout
• JavaScript Validation

Custom List Forms
24
Advanced Data View Web Parts
Advanced Data View Web Parts
25
Advanced Data View Web Parts
Cross-site DVWP Allows you to display a list
from another Web. You can also export the web
part to make it available to all webs in the site
collection.
Advanced Data View Web Parts
26
Advanced Data View Web Parts
Linked Data Sources Allows you to join multiple
data sources for complex views.
Advanced Data View Web Parts
27
Advanced Data View Web Parts
Create custom JavaScript/DHTML ?
AssessmentFramework.com
Advanced Data View Web Parts
28
Advanced Composite Applications
Advanced Composite Applications
29
Advanced Composite Applications

• SPD SharePoint Controls / ASP.NET Controls
• SPFeatures and CustomActions
• Custom Workflow Actions/Conditions
• Custom Web Parts

Advanced Composite Applications
30
References

• Wikipedia References
• Composite Applications http//en.wikipedia.org/w
  iki/Composite_applicatio
• SharePoint Designer http//en.wikipedia.org/wiki
  /Sharepoint_designer
• SharePoint Designer vs. FrontPage 2003
  http//office.microsoft.com/en-us/sharepointdesign
  er/FX101759001033.aspx
• SharePoint Designer Training Videos
  http//office.microsoft.com/en-us/help/HA102199841
  033.aspx
• SharePoint Designer _at_ Office Online
  http//office.microsoft.com/en-us/sharepointdesign
  er/FX100487631033.aspx

http//www.sharepointne.com
31
References

• Create Data Rollups with the DVWP
  http//blogs.msdn.com/sharepointdesigner/archive/2
  007/04/24/spdatasource-and-rollups-with-the-data-v
  iew.aspx
• Create custom SharePoint Designer Workflow
  Actions and Conditions http//blogs.msdn.com/shar
  epointdesigner/archive/2007/09/30/getting-to-workf
  low-information.aspx
• Configuring Kerberos for SharePoint 2007
  http//blogs.msdn.com/martinkearn/archive/2007/04/
  23/configuring-kerberos-for-sharepoint-2007-part-1
  -base-configuration-for-sharepoint.aspx

http//www.sharepointne.com
32
References

• CodePlex http//www.codeplex.com
• Inetium Blogshttp//blogs.inetium.com
• Nebraska SharePoint User Group
• http//www.sharepointne.com

http//www.sharepointne.com
33
Q A
http//www.sharepointne.com
34
Thanks for coming!
http//www.sharepointne.com