Sync framework enterprise data in the cloud and on devices
1 / 29

Sync Framework: Enterprise Data In The Cloud And On Devices - PowerPoint PPT Presentation

  • Uploaded on

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

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
Download Presentation

PowerPoint Slideshow about 'Sync Framework: Enterprise Data In The Cloud And On Devices' - hagen

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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
Sync framework enterprise data in the cloud and on devices l.jpg


Sync Framework: Enterprise Data In The Cloud And On Devices

Liam Cavanagh

Sr. Program Manager

Microsoft Corporation

[email protected]

Agenda l.jpg

  • 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 l.jpg
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 l.jpg
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 l.jpg
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 l.jpg
"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



Data Services

  • A solution for enabling sharing of desktop and device databases with business partners, mobile users and other desktops.



Access to sql data services l.jpg


Sync Service

Access to SQL Data Services

 Liam Cavanagh

Sr. Program Manager Lead

Microsoft Sync Framework

Huron data consolidation l.jpg
"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


Data Services

Sync Service




  • A purely off-premises solution enabling easy, low-cost mobilization and management of mobile applications.



Using sql data services l.jpg


Using SQL Data Services

SQL Services

 Liam Cavanagh

Sr. Program Manager Lead

Microsoft Sync Framework

Huron edge t o cloud services l.jpg
"Huron" – Edge To Cloud Services


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






  • Leverages enterprise and cloud assets by enabling data flow from the enterprise to the cloud.

Data representation in the cloud l.jpg
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


Full Online Access

Analytics& Reporting

Store &

Forward Sync

Data Access




Microsoft sync framework enabled l.jpg
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 l.jpg
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

Slide14 l.jpg

Azure™ Services Platform

Sql services extending the sql server data platform to the cloud l.jpg
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


Data Sync


Data Mining



What is microsoft providing l.jpg
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 l.jpg
Extending To Other Data Stores And Devices

  • Developers can add support for non-Microsoft databases and devices

  • Use existing Sync Services

Layered approach l.jpg

  • 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

Customize client data provider l.jpg

  • 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

Custom database support l.jpg


Sync Service

Custom database support

 Liam Cavanagh

Sr. Program Manager Lead

Microsoft Sync Framework

SQL Anywhere

Non microsoft devices and data stores l.jpg

  • 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 l.jpg
"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 - [email protected])


  • 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 l.jpg
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 l.jpg
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 l.jpg

  • Sync Developer Center –

    • SDK (including documentation)

    • Whitepapers

    • Samples (including several end-to-end)

  • SQL Services Labs –

    • “Cutting edge prototypes and pre-release functionality”

  • Sync Blog –

    • 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 l.jpg
Evals & Recordings

Please fill out your evaluation for this session at:

This session will be available as a recording at:

Please use the microphones provided l.jpg


Please use the microphones provided

Slide28 l.jpg

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