290 likes | 537 Views
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
E N D
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 • Data Representation in the Cloud • Technologies • Microsoft Sync Framework • SQL Data Services • Integrating non-Microsoft data sources and devices • Architecture • Demo
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)
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
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
"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
demo Sync Service Access to SQL Data Services Liam Cavanagh Sr. Program Manager Lead Microsoft Sync Framework
"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
demo Using SQL Data Services SQL Services Liam Cavanagh Sr. Program Manager Lead Microsoft Sync Framework
"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.
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
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
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
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
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
Extending To Other Data Stores And Devices • Developers can add support for non-Microsoft databases and devices • Use existing Sync Services
"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
"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
demo Sync Service Custom database support Liam Cavanagh Sr. Program Manager Lead Microsoft Sync Framework SQL Anywhere
"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
"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
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
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
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
Evals & Recordings Please fill out your evaluation for this session at: This session will be available as a recording at: www.microsoftpdc.com
Q&A Please use the microphones provided
© 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.