Taking Office to the Cloud: Integrating Microsoft Office 2010 and Windows Azure

1. OSP319 Taking Office to the Cloud: Integrating Microsoft Office 2010 and Windows Azure Steve Fox Director, DPE Microsoft Corp. stefox@microsoft.com | http://blogs.msdn.com/steve_fox | @redmondhockey

2. summary walkthroughs background

3. Why? • Cost optimization • Cloud-based services and data • Office server-side services • Extend Office in new ways

4. Points of integration • Many Office integration options • Excel & Excel Services REST • InfoPath & Forms Services • Access & Access Services • Visio & SharePoint Designer for Workflows • Visual Studio 2010 to build Office Add-ins • Integration cuts across both Office and Office 365

5. Office 365: What is it? Word Publisher Access Excel Flexible service offering with pay-as-you-go, per-user licensing The complete Office experience with services integration in Office 365 InfoPath PowerPoint SharePoint Workspace OneNote Lync Outlook Simplified end user set-up to use online services Always the latest version of the Office apps, including Office Web Apps Familiar Office user experience to access services • Excel • OneNote • PowerPoint • Word

6. Service (Existing) • Create an Excel 2010 Doc • Use the Add-in to connect to Windows Azure Marketplace data • Create Pivot Tables • Upload document to SharePoint • Expose via Excel Services • Also use REST services to interact with Excel objects Excel Client Azure Marketplace DataMarket (DATA.gov) SPS Excel Services

7. Crime Dashboard demo

8. Service (Custom) • Create WCF Service • Deploy to Azure or locally (as proxy) • Create client-side code to consume the service • Integrate with JavaScript OM • Deploy to SharePoint (either SPS or SPO) • You can extend with SP Client Object Model • Other applications can consume the credit score service SPS or SPO-S Service Proxy GetCreditScore CEWP (JavaScript/jQuery)

9. Credit Check demo

10. Data (Table Storage) • Create Excel document-level Add-in • Create Product class • Create ProductDataContext • Create ProductDataSource • Add functionality to workbook • Manipulate Azure Table Storage data • Any Office app that you can build an add-in for can access Azure Table Storage Client Excel Add-in Table Storage

11. Mortgage Calculator demo

12. Data (Business Connectivity Services) • Create ECT • Connect to SQL Azure • Create External List • Create Word Add-in • Deploy to SharePoint as a Content Type • You can access SQL Azure directly in Add-ins • You can build document-level and application-level add-in solutions SPS Client Word Add-in Contoso Stores Azure(External List) Contoso Stores Data External Content Type

13. Purchase Orders demo

14. Security • Business Connectivity Services (BCS) • Application ID – mediates connection to SQL Azure • BCS Permissions on external list • AppFabric • ACS • Simple: Token and secret key • Complex: Service-based claims and STS endpoints • WS-Federation/WS-Trust • Claims-based authentication for web apps/WCF services • BLOB Storage • Token and secret key to access the BLOB • Shared Access Permissions • Certificates • Use trusted certificate as handshake

15. More about Office 365 • Think of Office 365 as a point of extensibility • No external service calls with Sandboxed Solutions • BUT • Silverlight & jQuery/JavaScript can act as mediators • Use SP COM to integrate with SharePoint from client • InfoPath supports data connections and service calls in the cloud • Connect and leverage WCF/Data connections in forms • Use the service bus to interact with on-premises data • You can federate authentication or leverage claims

16. SummaryLots of Possibilities • Office & SharePoint provide many opportunities to integrate with Azure in many ways • Different endpoints can provide you with varying levels of data richness and analytical capabilities

17. What’s next? • For Development • Download SharePoint VM • Channel 9 SharePoint Developer Training Kit • Channel 9 Azure Developer Training Kit • Azure and SharePoint Developer Primer • SharePoint Sideshow • For Reference • Check out Steve’s blog for code and walkthroughs • Read Developing Microsoft SharePoint Applications using Windows Azure • This Week • Come see us at the Microsoft Booth!

18. Resources • Connect. Share. Discuss. http://northamerica.msteched.com Learning • Sessions On-Demand & Community • Microsoft Certification & Training Resources www.microsoft.com/teched www.microsoft.com/learning • Resources for IT Professionals • Resources for Developers • http://microsoft.com/technet • http://microsoft.com/msdn

19. Complete an evaluation on CommNet and enter to win!

21. © 2011 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.