Practical Office Business Application. Ronald Rajagukguk i-roraj@microsoft.com Developer Advisor. Practical Office Business Application. Andr i Yadi andri @dycode.com CEO. ”.
An Image/Link below is provided (as is) to download presentationDownload 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
Practical Office Business Application Ronald Rajagukguk i-roraj@microsoft.com Developer Advisor Practical Office Business Application AndriYadi andri@dycode.com CEO
” A major trend in software through 2010 will be the integration of business application data, functionality and processes with personal productivity applications. Users will access their business application data and processes through the interfaces of their personal productivity tools, and those tools will provide a context for actions within the applications. ” Change is Coming Gartner Research Planning for 2010: Key Issues for Business Application and Workplace Productivity Systems Integration
Examples Microsoft Dynamics CRM
Examples eBay Outlook Integration
Examples Dassault PLM Word Integration
Examples Accruent Outlook Integration Real Estate Performance Management: Creating visibility across the real estate lifecycle to deliver revenue growth, cost reduction and compliance CAPABILITY BI and Portals KEY OFFICE 2007 TECHNOLOGIES USED Excel Exchange Outlook SharePoint Server Word XML file format Virtual Earth
Examples Fractal Edge Excel Integration Fractal Maps for Office 2007: Award-winning data visualization system made readily available to all information workers for the first time CAPABILITY BI and Portals KEY OFFICE 2007 TECHNOLOGIES USED Excel Pivot tables XML file format Custom ribbon/task pane Analysis / Reporting Services
A unified solutions platform for building Office Business Applicationsthat make line-of-business systems, enterprisedata and workflows accessible and relevant to users. Fully integrated Visual Studio Tools for Office technologies enable developers to build Office Business Applications and scalable enterprise grade solutions based on Microsoft Office.
Tab Control Group Ribbon Visual Studio Tools For Office (VSTO) Extend Office Documents Ribbon Customization Outlook custom form regions Actions Pane
Automation Three Patterns of VSTO Projects Office Automation Doesn’t require VSTO installation Add-Ins Application Wide Functionality Toolbars, Menus, Etc. Document Customization Familiar “code-behind” model Functionality applies to document or template.
VSTO EDITION VSTO 2008 VSTO 2005 VSTO 2003
The Deployment Timeline VS 2005 Emulated “ClickOnce”
The Deployment Timeline VS 2008 Real ClickOnce Publish Installer Pre-reqs VS 2005 Emulated “ClickOnce”
The Deployment Timeline VS 2010 Enhanced ClickOnce Multi-project Post Deployment Actions No PIAs VS 2008 Real ClickOnce Publish Installer Pre-reqs VS 2005 Emulated “ClickOnce”
Real World Information Work Estimate custom design Unstructured Get specs from customer Validate specs with Tech Sales Cost out the solution Approve proposed response Decide discount strategy Assemble proposed response Create Opportunity Create Quote Create Lead Complete Sale Create Invoice Qualified? Closed? Retire Lead CRM ERP Structured
“Real World” Applications Word Excel Outlook InfoPath Office Business Applications Estimate custom design Estimate custom design Unstructured Unstructured Get specs from customer Validate specs with Tech Sales Office SharePoint Server Cost out the solution Decide discount strategy Assemble proposed response Approve proposed response “Classic” Enterprise Applications Create Lead Create Oppt’y Create Quote Complete Sale Create Invoice Qualified? Closed? Retire Lead Structured
Simple Scenario DEMO WCF DATA SERVICES (REST) DATABASE
Order Form
POST http://localhost/Northwind.svc/Orders Web Server WCF Data Services Data Service Context HTTP XML/JSON ThisDocument Data Layer ADO.NET Entity Framework DATABASE
Order Report
GET http://localhost/Northwind.svc/Orders Web Server WCF Data Services Data Service Context HTTP XML/JSON ThisWorkbook Data Layer ADO.NET Entity Framework DATABASE