the complete office experience with services integration in office 365 always the latest version of...
TRANSCRIPT
Office 2010 and Windows Azure
Speaker Name
Office & the Cloud
ServicesDataSocial
The complete Office experience with services integration in Office 365
Always the latest version of the Office apps, including Office Web Apps
Familiar Office user experience to access services
Flexible service offering with pay-as-you-go, per-user licensing
Simplified end user set-up to use online services
• Excel• OneNote
• PowerPoint• Word
PublisherWord
Excel
PowerPoint
OneNote
Outlook
Access
InfoPath
Lync
SharePoint
Workspace
There are a number of Office integration options
Excel & Excel Services RESTInfoPath & Forms ServicesAccess & Access ServicesVisio & SharePoint Designer for WorkflowsVisual Studio 2010 to build Office Add-ins
Consuming Azure Table Service Data in Excel 2010
demo
Demo Summary
Client
Table Storage
Create Excel document-level Add-in Create Product classCreate ProductDataContextCreate ProductDataSourceAdd functionality to workbookManipulate Azure Table Storage data
Any Office app that you can build an add-in for can access Azure Table Storage
Excel Add-in
Consuming Azure WCF Data in Excel 2010 using UDF
demo
Demo Summary
Client
Table Storage
Create WCF ServiceCreate class library Access WCF serviceAdd COM add-in to Excel
Can deploy User-Defined Functions to both client and Excel Services
Excel COM Add-in
SaleObservation Service
Executive Package
demo
Client
Office 365
Office Server-Side Services
Use server-side servicesPublish Access databases and create data-centric siteUse Excel Services web part and REST APIsCreate InfoPath forms and solutionsCreate data-bound Visio web parts
Leverage JavaScript in cloud for Excel Services Web Part customization/integration
On-premises
JS/jQuery
Excel/Visio/Access/InfoPath
Office Server-Side Services (Excel JSOM)Updating In-Browser Excel Web Access Web Part<script type="text/javascript" src="http://blueyonderdemo/SiteAssets/SiteAssets/jquery-1.3.2.min.js"></script> <script language="javascript" type="text/javascript">
var ewa = null;var Q1;var Q2 = "5.5";var Q3 = "6";var Q4 = "7";
var soapEnv = "<soap:Envelope xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' \ xmlns:xsd='http://www.w3.org/2001/XMLSchema' \ xmlns:soap='http://schemas.xmlsoap.org/soap/envelope/'> \ <soap:Body> \ <GetRate xmlns='http://tempuri.org/' /> \ </soap:Body> \ </soap:Envelope>";
… function btnGetData_onclick() { jQuery.ajax({ url: "http://blueyonderdemo:8744/AzureGetRate.asmx", type: "POST", dataType: "xml", data: soapEnv, success: processResult, contentType: "text/xml; charset=\"utf-8\"" }); return false; }
Points of IntegrationLots 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
Cloud Integration Description
BCS Model data from cloud and/or build external list to extend to the client.
Extensible UI (CTP, Backstage, etc.)
Create UI that integrates with cloud services or data.
Content Types Custom document template that is bound to/calls Azure.
Office Add-ins Consume data directly from cloud or BCS list exposing Azure data.
Open XML Manage data into a document.
Office Server Services Integrate with Office server-side services & jQuery/JavaScript.
Excel REST Use Excel Services REST URI in documents in SharePoint.
InfoPath Build forms-based applications that leverage data or services.
Summary
You can integrate Office with the cloud in many waysDifferent cloud services and endpoints can provide you with varying levels of data richness and analytical capabilities
ResourcesDownload SharePoint VM
http://www.microsoft.com/downloads/details.aspx?familyid=751FA0D1-356C-4002-9C60-D539896C66CE&displaylang=en
Channel 9 Office Developer Training KitCheck out Donovan's blogAzure Developer Center
http://msdn.microsoft.com/en-us/azure/default.aspx
© 2008 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.
Microsoft Confidential - NDA Only