1 / 31

Drill Down of OBA Technologies

David Gristwood Application Architect Developer & Platform Group Microsoft Limited blogs.msdn.com/ David_Gristwood. Drill Down of OBA Technologies . Office Business Applications (OBA).

venus
Download Presentation

Drill Down of OBA Technologies

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. David Gristwood Application Architect Developer & Platform Group Microsoft Limited blogs.msdn.com/David_Gristwood Drill Down of OBA Technologies

  2. Office Business Applications (OBA) • New Breed of Applications, using the Microsoft Office System to find and surface Line of Business Information • Office and SharePoint become the composition point for the “Software + Services” vision • Offers users additional ways to interact with those systems, giving them the information they need, where they need it • Reduces user learning curve, provides wider access to enterprise information, greater user adoption, increased policy compliance, improved decision making, and saves time and money

  3. The 2007 Microsoft Office System • Critical Mass as a Solutions Platform Dynamics Duet ISV OBAs Custom OBAs Office Business Applications Business Intelligence 2007 Office system clients Microsoft Office System Office SharePoint Server 2007 Unified Communication & Collaboration Tools SharePoint Designer Visual Stuidio Tools for Office Office Communications Server 2007 Exchange Server 2007 Content Management Workflow Search Business Data Catalog Website & Security Framework Extensible User Interface Open XML File Formats LOB Apps, data warehouse, trading partners, etc LOB Siebel SAP Dynamics

  4. Surface Points Office Launch / Sync / S+S SharePoint Ribbon UI Custom Task Pane Outlook Forms Regions Web Parts

  5. Architecture and Services SharePoint Document Libraries & Forms KPI, Metrics, Reports, Dashboards Workflow Business Data Catalog Excel Services Data via web services, ADO.NET, XML, RSS, etc

  6. Office

  7. Office as a platform 1989?

  8. Office as a platform2007

  9. Visual Studio Tools for the Office system 3.0 • Question – the importance of development tools? • Document-level solutions • Application-level Add-ins • Highly streamlined developer experience RAD design experiencefor building Office-based apps Utilize key 2007 Office system UI features

  10. Word Content Controls • New experience for developing structured documents in Word 2007 • New UI for developers to access Word Content Controls • Programmable through Word Object Model Toolbox Controls

  11. Group Ribbon Ribbon Extensibility Tab Control Ribbon Control Toolbox Property Grid Design Surface

  12. Custom Task Panes • Create custom task panes • Project, Excel, InfoPath, Outlook, PowerPoint, Word • Main application window or Outlook inspectors • Build with Winform controls • Can be triggered from Ribbon

  13. Outlook Form Regions

  14. Demo Office 2007

  15. SharePoint

  16. Web Parts • Web Part control set part of ASP.NET 2.0 • SharePoint Services 3.0 builds on this, including MOSS 2007 • SharePoint Services Web Part manager, Web Part zones, etc. • MOSS, SharePoint, Data, Custom, filters, connections, etc

  17. Adding Web Parts

  18. SharePoint Developer Platform • Rich object model • Programmatic access to data and documents • Content Types with associated behaviors such as workflow • Events on lists and libraries • Features combine resource handlers, web part , etc

  19. Excel Services • Excel has great calculation and charting engine • Server-side Excel calculation engine for browser based spreadsheet viewing & interactivity • Excel Web Part to build dashboards • Web Service programmatic access to Excel Services • Can reuse logic & business models built in Excel • Eliminate “multiple versions of the truth” caused by distributing copies of spreadsheets • Control access to spreadsheets for regulatory concerns or to protect proprietary information • Offload long-running calculations from desktop

  20. Excel Services

  21. High quality web rending Zero-footprint Interactive: Set parameters, sort, filter, explore Browser Excel 2007 View and Interact Publish Spreadsheets Design and author Export/Snapshot into Excel Excel 2007 Programmatic Access Open in Excel for rich exploration and analysis Open snapshots SharePoint platform and Excel services Spreadsheets stored in doc libraries Spreadsheet calculation and rendering External data retrieval and caching 100% calculation fidelity Customapplications Set values, perform calculations, get updated values via web services Retrieve full workbook file Excel Services Architecture

  22. MetadataDatabase Business Data Catalog • Not all data resides in SharePoint • Surface business data from backend applications without coding • Bridges gap between the portal and business applications • Turn backend data into “entities” using XML definition • Define custom actions for entities • Use SQL connection strings and queries BDCWebPart SharePoint Lists Search User Profile Importer Custom Solutions Business Data Catalog ADO.Net Web Service Proxy Database Web Service

  23. Surfacing Data via BDC Business Data List with Query Custom List with Business Data Business Data List with Custom Action

  24. Windows Workflow Architecture • Single workflow technology for Windows • Redefining workflow • Take workflow mainstream • Programming model, engine and tools for building workflow enabled applications

  25. Workflow in Office

  26. Office Live • Get small business (people < 10) a web presence quickly and easily • Build on SharePoint architecture

  27. Office Live Architecture R: 187 G: 224 B: 227 List Views Public Web Site Workspaces Web Parts Web Services Workspaces, BCM, Sales, Project Manager, Time Manager, Document Manager, … Client-side JavaScript R: 255 G: 124 B: 128 Dashboards Web page Modules OL Business Applications & Workspaces Web page Templates Custom Applications e-mail R: 255 G: 204 B: 0 Business Rules Workflows Alerts Auth. Data Sharing Lists Libraries Data R: 0 G: 153 B: 255 Office Live Page Editor Storage Security Mgmt Topology Site Model APIs Admin. Office Live Site Designer Office Live Web Infrastructure (WSS 3)

  28. Demo SharePoint & MOSS

  29. Open XML File Format: Architecture User view: Single Office “file” Developer view: Modular File System • Container • Can add, extract and modify individual parts using any Zip implementation • Corruption or absence of any part would not prohibit the file from being opened • Document Parts • Most parts are XML • Each XML part is a discreet, compressed component

  30. © 2007 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.

More Related