1 / 29

Sync Framework: Enterprise Data In The Cloud And On Devices

BB40. Sync Framework: Enterprise Data In The Cloud And On Devices. Liam Cavanagh Sr. Program Manager Microsoft Corporation liam.cavanagh@microsoft.com. Agenda. Business data hubs in the cloud What are they and why create one? Business Data Sharing Scenarios Demo

hagen
Download Presentation

Sync Framework: Enterprise Data In The Cloud And On Devices

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. BB40 Sync Framework: Enterprise Data In The Cloud And On Devices Liam Cavanagh Sr. Program Manager Microsoft Corporation liam.cavanagh@microsoft.com

  2. Agenda • Business data hubs in the cloud • What are they and why create one? • Business Data Sharing • Scenarios • Demo • Data Representation in the Cloud • Technologies • Microsoft Sync Framework • SQL Data Services • Integrating non-Microsoft data sources and devices • Architecture • Demo

  3. What Is A Business Data Hub? • Consolidation of business data from multiple sources including • Enterprise databases • Mobile Workers • Business Partners • Remote Offices • Includes sharing between these sources (through bi-directional synchronization)

  4. Why Create A Data Hub? • Enterprise data can be accessed outside of the enterprise • Data can be shared between mobile users, remote offices and business partners • Leverage cloud-computing to dramatically reduce investment in infrastructure and ongoing administration normally associated with enabling data access to the field • Is an always-available, highly scalable endpoint

  5. Desktop Database Sharing • Enables information to be moved from one users desktop database to another • E.g., Scaling a Microsoft Access database once it reaches its user limit • Different users could use different database engines

  6. "Huron" – Desktop Database Sharing SQL Services • Consolidate business data in the cloud and enabled sharing to other desktops and mobile users • Synchronize when network is available • Enables database scaling with out upgrading the database or hardware resources • Each user does not have to be connected to the one database • Out-of-the-box publication of Microsoft databases • Database template sharing • Solves the rendezvous problem Sync Service Data Services • A solution for enabling sharing of desktop and device databases with business partners, mobile users and other desktops. "Huron" Client

  7. demo Sync Service Access to SQL Data Services  Liam Cavanagh Sr. Program Manager Lead Microsoft Sync Framework

  8. "Huron" – Data Consolidation Online Applications SQL Services • Online access to data hub and propagation of changes to data endpoints • Low Cost of Administration & Deployment of Mid-Tier • Low Cost, High Availability • Data Security • Reporting, Analytical, Mgmt, etc… Online Access Reporting Data Services Sync Service GSM, CDMA, etc • A purely off-premises solution enabling easy, low-cost mobilization and management of mobile applications. "Huron" Client

  9. demo Using SQL Data Services SQL Services  Liam Cavanagh Sr. Program Manager Lead Microsoft Sync Framework

  10. "Huron" – Edge To Cloud Services Organization SQL Services • Offload business resources to the cloud • Take advantage of cloud services • Enables scenarios like Business Intelligence, Reporting and Data Backup • Provides availability and scalability BI, ERP & Relational "Huron" Gateway DMZ • Leverages enterprise and cloud assets by enabling data flow from the enterprise to the cloud.

  11. Data Representation In The Cloud • Data hubs can supports several levels of trust: • Defined by the amount of trust in our Cloud • The more trust, the more functionality • Data access configuration on a table by table basis Functionality Full Online Access Analytics& Reporting Store & Forward Sync Data Access Encrypted Read Full

  12. Microsoft Sync Framework Enabled • Access to your data on any PC, device or service across disparate applications • Microsoft Sync Framework unlocks your data, enabling • Offline and cached-mode capabilities for your application • Roaming and collaboration of your data across disparate endpoints

  13. Microsoft Sync Framework • Solves hard sync problems so you don’t have to • Conflict detection and resolution • Connection and storage errors • Numerous corner cases • Capable of operating in unforgiving environments, e.g. • From one-way, hub-and-spoke, to peer-to-peer • Unreliable networks • Supports arbitrary data stores, data types and protocols • Ease to extend to support your own data store • Most protocols can be easily extended to support the necessary metadata • Built-in support for FeedSync

  14. Azure™ Services Platform

  15. SQL ServicesExtending the SQL Server Data Platform to the Cloud • Database: Relational processing for structured/unstructured data • Data Sync: Synchronization for occasionally connected clients • Reporting: Self-service authoring and report sharing • Data Mining: Self-service data trending & analysis • ETL: Data transformation & cleansing across on/off premise • Reference Data: Broad variety of reference data sets Database Data Sync Reporting Data Mining ETL ReferenceData

  16. What Is Microsoft Providing? • “Huron” Sync Experience featuring out-of-the-box support for building business data hubs with • Microsoft Access • SQL Server (Express, Workgroup, Enterprise, etc) • SQL Server Compact • Custom Providers using Sync Framework • Customization of new devices and databases • Uses existing “Huron” client functionality through the Sync Service • Desktop, Professional and Enterprise editions • Pricing and packaging still to be determined

  17. Extending To Other Data Stores And Devices • Developers can add support for non-Microsoft databases and devices • Use existing Sync Services

  18. "Huron" Client • Sync Service Layered Approach • Sync Service handles scalability and management of remote and mobile endpoints • "Huron" Client includes • Sync Framework Runtime • Sync Service Proxy • Client Database Provider Sync Framework SDS Provider Sync Framework Sync Service Proxy Client Data Provider

  19. "Huron" Client • Sync Service Customize Client Data Provider • Use to plug-in custom data stores on a Windows based desktop or device • Re-use existing “Huron” client and plug in custom Client Data Provider Sync Framework SDS Provider Sync Framework Sync Service Proxy Client Data Provider

  20. demo Sync Service Custom database support  Liam Cavanagh Sr. Program Manager Lead Microsoft Sync Framework SQL Anywhere

  21. "Huron" Client • Sync Service Non-Microsoft Devices And Data Stores • Use when you want • Support of non-Microsoft devices • Use documented Sync Service interfaces • GetChanges • ApplyChanges • Implement change tracking mechanism in client db provider Sync Framework SDS Provider Client Data Provider Client Data Proxy

  22. "Huron" – Futures • Now – Microsoft Sync Framework v2 • Phase 1 – 4Q08 • Desktop sharing early adopter program for Access, SQL Server and SQL Server Compact • Watch Sync Blog (or email me - liam.cavanagh@microsoft.com) • http://blogs.msdn.com/sync • Phase 2 – 1H09 • Access, SQL Server, SQL Server Compact Desktop Sharing CTP • Client SDK CTP • Phase 3 – 18-24 months • Access, SQL Server, SQL Server Compact Desktop Sharing Target Release • "Huron" Client SDK

  23. Business Data Hub – Summary Seamlessly share businesses data with mobile workers, business partners and cloud services. • Synchronization of business data to a cloud • based data hub enabling • Workgroup, enterprise and desktop database sharing with field workers and mobile users • Enterprise to Cloud • Business to Business data sharing • Eases authentication, firewall, scalabilityand availability complexities • Powered by Microsoft Sync Framework and SQL Data Services • Open with out-of-the-box support for SQL Server, SQL Server Compact and Microsoft Access

  24. Related Sessions • Microsoft Sync Framework • TL30 - Microsoft Sync Framework Advances • PC44 - Windows 7: Programming Sync Providers That Work Great with Windows • SQL Data Services • BB14 – SQL Data Services: Futures • BB23 – SQL Data Services : A Lap Around • Offline Services using ADO.NET Data Services • TL08 - Offline-Enabled Data Services and Desktop Applications • SQL Server Compact • PC40 - SQL Server Compact: Embedding in Desktop and Device Applications

  25. Resources • Sync Developer Center – msdn.microsoft.com/sync • SDK (including documentation) • Whitepapers • Samples (including several end-to-end) • SQL Services Labs – www.sqlserviceslabs.com • “Cutting edge prototypes and pre-release functionality” • Sync Blog – blogs.msdn.com/sync • Announcements • Tips and Tricks • Come visit us afterwards • Discuss Sync in more detail at our Booth • “Ask the Experts” session • Discuss your scenarios for synchronization

  26. Evals & Recordings Please fill out your evaluation for this session at: This session will be available as a recording at: www.microsoftpdc.com

  27. Q&A Please use the microphones provided

  28. © 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.

More Related