SharePoint 2010 Composites & RAD

SharePoint 2010 Composites & RAD Part I Olaf Feldkamp Development Platform Advisor Developer & Platform Group Microsoft Schweiz GmbH

Agenda • IntroductiontoSharePoint 2010 Composites • Business User Perspective • Developer Perspective • Potential Challenges • SharePoint Online • Sandboxed Solutions • Overviewnew SharePoint Service Applications • Word Automation Services • Access Services

Microsoft (MSDN 2006) “A composite application is a collection of softwareassets that have been assembled to provide a business capability.These assets are artifacts that can be deployed independently, enable composition, and leverage specific platform capabilities.” WhatareComposites? Wikipedia (2010) • “Composite application expresses a perspective of software engineering that defines an application built by combining multiple existing functions into a new application.The technical concept can be compared to mashups. However, composite applications use business sources of information, while mashups usually rely on web-based, and often free, sources.”

SharePoint EvolutionTheBusiness Collaboration Platformfor the Enterprise and the Web Composites& RAD End UserApplication Sites Composites Communities On Premise Cloud Insights Content IntranetOriented InternetFacing Search

SharePoint Server 2010 Template Based Solution SharePoint Workspace, SharePoint Mobile Office Client and Office Web App Integration Ribbon UI, Standards Support Business Connectivity Services External Lists Workflow SharePoint Designer Visual Studio 2010 API Enhancements REST/ATOM/RSS InfoPath Form Services Word Automation Services Access Services Blogs and Wikis Tagging, Tag cloud, Ratings Social Bookmarking My Sites Activity Feeds Profiles and Expertise Organization Browser Sites Communities Composites Excel Services PerformancePoint Services Chart Web Parts Visio Services Web Analytics SQL Server Integration PowerPivot Remote Blob Storage Versioning List Enhancements Enterprise Content Types Metadata and Navigation Document Sets Multistage Disposition Audio and Video Content Types Insights Content Search Social Relevance Phonetic Search Navigation FAST Integration Enhanced Pipeline

Business Users – without code Use out-of-the-box features and configure in the browser or customize with SharePoint Designer, InfoPath, Visio Developers – with code Web parts (ASP.NET 3.5, Silverlight), line-of-business data integration, list event receivers, workflows, workflow activities, application pages, … or even Business Collaboration Applications with Visual Studio Operations – reliability and agility Sandboxed solution or Silverlight web part (which may even contain business logic) SharePoint Composite Solutions

«Manual filingandsearchingofprojectrelated Emails in SharePoint» Classification Possible Solution Create a new SharePoint listof type «discussionboard» Connect thelistto Outlook Drag & drop relevant Emails/Email-Threads tothenewlist (in Outlook) Sample Business Requirement #1

Creating a specific SP listandconnectingitto Outlook demo

«Emergency accesstoinformation: provide a subsetofourinternalcustomeraddressbookwithin SharePoint byreadingdatafrom SQL Server» Classification Possible Solution Create an externalcontent type with SharePoint Designer Create an externallistwith SharePoint Designer Connect externallistwith Outlook or SharePoint Workspace Sample Business Requirement#2

Business Connectivity Services (BCS) Office Client SharePoint Server 2010 Office Integration SharePoint Site VSTO Package External List External Business Parts Custom Code Search, Workflow, Web Parts Secure Store Service Business Connectivity Services Business Connectivity Services Cache BCS Client Runtime External Content Types Server Runtime External Data ADO.NET Web ServiceWCF Service .NET AssemblyConnector

Creating an externallistandenabling offline access demo

«I wanttodisplayvectorsbetweentheoriginsandthedestinations. Additionally, thevectorsshouldappear ina different color, dependent on the type oftransport» Classification Possible Solution Export datafrom Excel into a new SharePoint list Develop a Silverlight Web Part usingthe Bing Maps Silverlight control Write codewhichreadsdatafromthe SharePoint listanddrawsvectorsintothe Bing MapsControlusingthe Bing Maps API Sample Business Requirement#3

Developer Investments in SharePoint 2010 • Visual Studio 2010 Tools for SharePoint • Application Lifecycle Management • Developer Dashboard shows Page Performance • Install on Windows Vista SP1 or Windows 7 • SharePoint Designer 2010 Developer Productivity • User Interface: Silverlight, XSLTListViewWebPart • Data Foundation: Relationships, Lookups • Programmability: Client and REST API, LINQ, Events, Workflow • Data Integration: Business Connectivity Services Rich Platform Services • Standardized WSP Package Deployment • Sandboxed Solutions • On-Premises or SharePoint Online Flexible Deployment

SharePoint Installation Options Install on Windows Server 2008 SP2 x64 (or Windows Server 2008 R2 x64) Use Microsoft Hyper-V and install on a virtual machine running a Windows Server 2008 SP2 x64 (or Windows Server 2008 R2 x64) guest operating system Install on Windows 7 x64, Windows Vista SP1 x64, or Windows Vista SP2 x64 Use Microsoft Hyper-V and install on a virtual machine running a Windows 7 x64, Windows Vista SP1 x64, or Windows Vista SP2 x64 guest operating system With Windows 7, you can create a VHD on which SharePoint is installed in Windows Hyper-V, and then configure Windows 7 with BDCEdit.exe so that it boots directly to the OS on the VHD SharePoint 2010 Development Environment

SharePoint 2010 Development Environment (2)

Hardware (minimumrequirements) Developer andevaluation: 64-bit CPU, 4 cores, 4 GB RAM Production: 8 GB in a single server or multiple server farm Software (all 64-bit) Server Windows Server 2008 Service Pack 2 (or Windows Server 2008 R2) SQL Server 2005/2008/R2 (incl. Service Packs) .NET Framework 3.5 SP1 … Client Office 2010 SharePoint Workspace 2010 Silverlight 3 More Information Setting up the Development Environment for SharePoint (MSDN article) Hardware and software requirements (TechNet article) SharePoint 2010 Setup

Overview SharePoint APIs WindowsRich Client Browser Other Platforms Toolkits for WCF Data Services Client Object Model (SL, AJAX) .NET Client OM Internet REST ASP.NET Web Services WCF SharePoint Object Model

Importingdatato SP anddeveloping a Silverlight web part demo

«I need an easy touse CRM system. All informationincludingdocumentsandsurveys must bestored in theexisting SharePoint instanceandthecode must runwithin SharePoint. Also graphicalreportsandalertsarerequired.» Classification Possible Solution Configureschemabased on SharePoint lists (referentialintegrity, …) (Browser) Configure Views, Forms, Web Parts, … (SharePoint Designer) Create a SharePoint (sandboxed) solution (.wsp) anddevelopartifactslike Web Parts, Event Receivers, Workflows, Custom Fields, Reports, … (Visual Studio) Sample Business Requirement#4

Relational lists now enforce referential integrity! Lookup columns must be indexed (automatic) Joins can be implemented using the API, LINQ to SharePoint, CAML, or SharePoint Designer 2010 New properties on SPQuery SPQuery.Join SPQuery.ProjectedFields Relational Lists and Joins

Reference: BPA Solutions SARL, NeuchâtelCustomers: various, Productbased on SharePoint Foundation 2010 • Partner Quote: • “Customer projects are 100% customizable with no code: we can reduce implementation time by 10 or more because everything can be customized in the browser with no development needed…” • Dr. Boris Lutz, Managing Director, BPA Solutions SARL

Agenda • IntroductiontoSharePoint 2010 Composites • Business User Perspective • Developer Perspective • Potential Challenges • SharePoint Online • Sandboxed Solutions • OverviewnewSharePoint Service Applications • Word Automation Services • Access Services

Before SharePoint 2010: CAML was usedforlistqueries Used in SPQuery()andSPSiteDataQuery() LINQ to SharePoint is similar to e.g. LINQ to Entities Entity classes are strongly-typed, compile-time check Intellisense helps query construction New Assembly: Microsoft.SharePoint.Linq.dll CAML for Queries?  LINQ to SharePoint <Where> <Gt> <FieldRef Name='EndDate'/> <Value Type='DateTime'> <Today OffsetDays=\"-1\"/> </Value> </Gt> </Where>

Create EntityClasses Add this new output file to Visual Studio Project Support for List joins, join on lookup fields Join multiple lists (A  B  C) Project any field from joined list in a query Fullsupportonlyin the SharePoint objectmodel (server-side) LINQ to SharePoint • SPMETAL.EXE /web:http://sp/sites/technical /code:technical.cs • var query = from o in data.Orders where o.Customer.City.Name == “Basel“ select o;

Replaces ListView-, ListForm-, DataViewWebPart Web 2.0 View Framework Data: replaces CAML for Views  new Default: XSLT-based Views CAML still used for Queries List Schema XSL Easier edit in SharePoint Designer Better User Interface E.g. Inline editing CAML in Web Parts?  New XsltListViewWebPart

XsltListViewWebPart in Action

Business User vs. Developer Customization Business CollaborationSolution Workflow Ribbon UI 10 Web Part Event Receiver Time tobuild Solution External List Branding 1 No-code WF InfoPath Form Custom List Complexityof Solution

Custom Solution vs. SharePoint Composites •  Additional advantages • Consistentandfamiliaruserinterface • Onlyoneplatformto manage (knowhow, backups, …) • Things yougetforfree e.g. Office integration, offline support, easy and quick deployment (no IT involved), indexing, … • Choice between SharePoint on-premiseand SharePoint Online •  Potential challenges • SharePoint knowhow not available • User expectationsvs. «the SharePoint way» • Building on SharePoint takesmore time thanbuilding a customsolution •  Carefullybalancebetweentheseoptions, building on SharePoint is not alwaysthebestsolution! Develop-ment (.NET, otherframeworks) Potential time saving Develop-ment Time tobuild Solution Configu-ration (SP)

Commercial Cloud Services • 40M paid Online seats • More than 500 government entities • 10’000 Windows Azure customers • Over 50% of the Fortune 500 • 70% switching from Notes • 12’000 partners • PRODUCTIVITY • COLLABORATION • BUSINESS APPS • MANAGEMENT • STORAGE • PLATFORM • COMMUNICATIONS

Your Choice: On-Premises or Online On-Premises Deployments SharePoint Online Standard SharePoint Online Dedicated • Self-hosted and managed • Direct access to physical machines • Central admin access • Hosted within own data centers • Entire environment customizable • All accounts, machines, and data within a single AD Forest • Available to companies of any size • Multi-tenant hosting • Shared Hardware • Outsourced IT management • Hosted within MS data centers • Sandboxed solutions(vNext) • Support for SharePoint Designer based customizations • Certificate authentication or Forms based authentication (vNext) • Available for companies with 5+ seats • Dedicated Hosting • Dedicated Hardware • Outsourced IT management • Hosted within MS data centers • Most of the environment is customizable (Full Trust and Partial Trust Code Support) • Machine and Process accounts in a different AD Forest • NTLM Authentication • Available for companies with 5000+ seats

SharePoint Online, Office Web Applications demo

Developer • Designs, builds, and testscustomizations Custom Solutions with SharePoint 2007 • Administrators can only secure solutions with Code Access Security • OftensettoFullorassembliesaredeployedto GAC • Hard to control what is being done in custom code • Custom code is biggest cause of SharePoint support cases Administrator • Installs and monitors customizations Site Collection Owner • Activates and uses customizations

Developer • Designs, builds, and tests customizations SharePoint 2010 Approach • Sandboxed Solutions • Automatic triggers turn off custom solutions in a site collection that are too expensive on the server Administrator • Establishes Resource Quotas • Monitors customizations Site Collection Owner • Deploys, activates and uses customizations

A separate process/server where the solution runs Scale out Exposes a subset of Microsoft.SharePoint Code Access Security policy limits functionality AspNetHostingPermission.Level = Minimal Site Collection Solution Gallery for deployment Central Administration for managing and monitoring solutions Restrictedtolimited resources Code CPU Time, SQL Executing Time, NumberofException, … The Sandbox

A subset of existing solution model Web/Site scoped features Many XML constructs: <Lists>, <ContentTypes>, <Modules>, … Code components Web parts Event receivers Feature activation receivers Workflow activities (for reuse with SharePoint Designer) InfoPath Forms with code-behind SharePoint API set is limited to Microsoft.SharePoint (with specific limitations) Supported Features

Visual Studio 2010SharePoint Tools demo

Download in Visual Studio Gallery Visual Studio 2010 SharePoint Power Tools

Word, Excel, Access, and Visio Services

Word Automation Services = server-ready version of Word without User Interface 100% fidelity server-side rendering High volume throughput with scalability Printing on server through PDF/XPS Word Automation Services provides Layout File | Save As on the server Export to formats supported by Word (docx, doc, pdf, xps, …) File conversion Complex field calculation Word Automation Services

The SDK and Word Automation Services are designed to be complimentary SDK for file manipulation Word Automation Services for layout, file conversion, and field calculations Word Automation Services & Open XML SDK Open XML SDK 2.0 Print Template Docu-ments Data PDF Word Automation Services

Word Automation Services and Open XML demo

Microsoft Access 2010 • Microsoft Access 2010 • Provides a rich platform for developing databasemanagement solutions with easy-to-use customization tools • Lessneedfor VBA code • UI Macros • E.g. OnButtonClick() • Data Macros («datalayer») • On tablelevel reuse • Before Change, After Insert, …

«Publishto Access Services» ACCDB  SharePoint Site ( web app with central db) Access Tables  SharePoint lists (read & write) Access Forms  ASPX Pages Access Reports Reports RDL (SQL Server Reporting Reports) UI Macros Javascript Data Macros  SharePoint Workflows VBA Code  No  Best suitedforquick developmentofdepartmentalsolutions Access Services

Access Services demo

What’s the User and Business Value? Help IT departments manage Access databases ( central DB) Provide business users a manageable solution to create, share and collaborateon team databases Extend a richclientapplicationto a web applicationwith a centraldatabase No Desktop installationneeded Onlyavailable in SharePoint 2010 Enterprise Access Services

SharePoint 2010 Composites allow to configure and develop Composite Applications in an agile way Great Tool Support SharePoint Designer 2010 Visual Studio 2010 provides a 1st class developer experience for SharePoint 2010 Start developing sandboxed Solutions New powerful SharePoint Services Applications Word Automation Services (Word conversion and layout engine server-side) Access Services extend Microsoft Access 2010 to SharePoint Summary

Thank you for your Attention! • For more Information please contact • Olaf Feldkamp • Development Platform Advisor • Olaf.Feldkamp(at)microsoft.com • Phone (UC): +41 (43) 456 63 87 • Microsoft Schweiz GmbH • Richtistrasse 3 • 8304 Wallisellen

SharePoint 2010 Composites & RAD