Module 3: Microsoft Mobility Solutions

1
Module 3 Microsoft Mobility Solutions
2
Overview

• Microsoft Office Mobile
• Using Windows Mobile 5.0 with Exchange Server
  2003
• Using Windows Mobile 5.0 with Other Messaging
  Systems
• Microsoft SQL Server 2005 Mobile Edition

3
Lesson Microsoft Office Mobile

• Microsoft Office Mobile Functionality
• Microsoft Excel Mobile
• Microsoft PowerPoint Mobile
• Microsoft Word Mobile
• Windows Media Player Mobile

4
Microsoft Office Mobile Functionality

• Create, delete, or rename a folder
• Move a file or note
• Create, rename, locate, or open a file
• Create a template
• Find or replace text or data
• Automatically save files on a storage card
• Create a document or workbook by using a template
• Save a copy of a document or workbook
• Set the default template
• View files by type in the file list
• Zoom in or out

5
Microsoft Excel Mobile

• Create and edit Excel workbooks and templates on
  your mobile device
• View, edit, and create charts and graphs that can
  be embedded as objects in a worksheet or placed
  on a separate worksheet
• Enter formulas and functions, and then filter
  data to see the subset of information you want
• Split panes to view different parts of a
  worksheet at the same time

6
Microsoft PowerPoint Mobile

• Open and view slide show presentations created on
  your PC on your Windows Mobilepowered device
• Many presentation elements built into the slide
  shows, such as slide transitions and animations,
  will play back on the device
• Links to URLs supported
• Zoom in to see a portion of a slide in more
  detail and zoom out to see the entire slide again

7
Microsoft Word Mobile

• Open, view, and edit documents on the move
• Save changes to your device, e-mail them back to
  the office, or transfer them to your PC
• Word Mobile features include
• Spell-check
• Find and Replace commands
• Bulleted lists
• Text formatting
• Support for tables
• Tools for creating business and draft proposals

8
Windows Media Player Mobile

• Play digital audio and video files on Windows
  Mobile devices, including
• Pocket PC
• Smartphones
• Use the Sync feature in the desktop version of
  Windows Media Player to synchronize (copy)
  digital media files from your computer to your
  Windows Mobile device

9
Lab 3A Working with Office Mobile Applications

• Exercise 1 Calculating a Customer Discount Using
  Excel Mobile
• Exercise 2 Creating and Sending a Chart Using
  Excel Mobile
• Exercise 3 Viewing a Presentation Using
  PowerPoint Mobile
• Exercise 4 Creating and Saving a Document Using
  Word Mobile

10
Lesson Using Windows Mobile 5.0 with Exchange
Server 2003

• Overview of Using Windows Mobile 5.0 with
  Exchange Server 2003
• Exchange Server 2003 Mobility Features
• Mobility Enhancements in Exchange Server 2003 SP2

11
Overview of Using Windows Mobile 5.0 with
Exchange Server 2003

• Software requirements
• How Windows Mobile 5.0 communicates with Exchange
  Server 2003
• Forms-based authentication considerations
• Firewall considerations
• SSL certificate considerations
• Mobile carrier considerations

12
Exchange Server 2003 Mobility Features

• ActiveSync
• Exchange ActiveSync
• ActiveSync 4.1
• Pocket PC and Smartphone support
• Up-to-date notifications synchronization

13
Different ways of Accessing Exchange Information
Remotely

• Using Outlook 2003 with RPC/HTTP

Using Outlook Web Access
Microsoft Exchange 2003
Microsoft Exchange 2003
Exchange Front-End Server
Exchange Back-End Server
Exchange Back-End Server
HTTP
RPC/HTTP
14
Mobility Enhancements in Exchange Server 2003 SP2

• Exchange Direct Push technology
• Global Address List lookup
• Remotely enforced IT policies
• Local and remote device wipe
• Certificate-based authentication and S/MIME
  encryption
• Outlook Mobile data compression

15
Lab 3B Configuring and Troubleshooting Windows
Mobile 5.0 and Exchange Server

• Exercise 1 Configuring the Exchange Server for
  Direct Push
• Exercise 2 Troubleshooting ActiveSync and the
  Exchange Server

16
Lab 3C Implementing Security on Mobile Devices

• Exercise 1 Configuring Password Policies for
  Mobile Devices
• Exercise 2 Performing a Remote Wipe
• Exercise 3 Testing Local Wipe

17
Lesson Using Windows Mobile 5.0 with Other
Messaging Systems

• Third-Party Enterprise Messaging Systems for
  Windows Mobile 5.0
• Using Windows Mobile 5.0 with POP, IMAP, and SMTP

18
Third-Party Enterprise Messaging Solutions Using
Windows Mobile 5.0

• Third-party mobile messaging solutions designed
  to integrate with Windows Mobile 5.0 include
• iAnywheres Extended Systems
• Good Technologys GoodLink Wireless Messaging
• Nokias Intellisync Mobile Suite 6
• JP Mobiles SureWave Mobile Office 5.0
• Smartners Duality Always-on Mail solution
• Vistos Mobile Enterprise Server

19
Using Windows Mobile 5.0 with POP3, IMAP4, and
SMTP

• Setting up POP3 or IMAP4 e-mail auto
  configuration
• Tap Start gt Messaging
• Tap Menu gt Tools gt New Account
• Enter your e-mail address, and then tap Next
• Tap Record to begin recording
• Enter your name (the name you want displayed when
  you send e-mail) and your password

20
Lesson Microsoft SQL Server 2005 Mobile Edition

• Integration with SQL Server 2005
• Synchronization Functionality
• Reliability and Performance
• Developer Productivity
• Integration with Visual Studio 2005
• Increased Device Support
• Database Upgrade Tool

21
Integration with SQL Server 2005

• SQL Workbench
• Graphical query plans
• New subscription wizard
• Integration with Data Transformation Services
  (DTS)
• Bulk copy program (BCP) file consumption
• Managed API access to synchronization business
  logic
• Support for download-only articles (tables)
• Support for partitioned (filtered) articles

22
Synchronization Functionality

• Merge replication
• Based on SQL Server 2005 merge replication
• Enables autonomous data updates on portable
  device and server
• Data on device and server can be synchronized
  later when a connection is reestablished
• Remote Data Access (RDA)
• Applications can use RDA in two ways
• A SQL DML statement is forwarded to SQL Server
  for execution
• A SQL query is submitted that returns a row set
• Message-based Internet replication
• Uses IIS authentication, authorization, and
  encryption
• Can communicate with a SQL Server system located
  behind a firewall or proxy server

23
Reliability and Performance

• Revamped storage engine
• True atomicity, consistency, isolation, and
  durability (ACID)
• Auto-shrink support
• An improved query processor
• Cost-based optimization
• Show plan and query hints

24
Developer Productivity

• Multiuser support
• Multiuser synchronization enables multiple users
  to synchronize data while using the same
  application, so the database does not have to be
  disconnected before they use merge replication or
  RDA
• Row-level locking helps to ensure a high level of
  concurrency when multiple users simultaneously
  access the same data pages
• A new SqlCeResultSet
• Substantial performance and functional
  improvements eliminate the need to use the
  dataset
• A dramatic increase in application performance,
  while reducing the amount of code required to
  accomplish the same task

25
Integration with Visual Studio 2005

• Developers can create and manage a SQL Server
  Mobile database on a desktop computer or a mobile
  device using Visual Studio 2005
• Drag and drop SQL Server Mobile tables onto
  controls on the mobile device
• SQL Server Mobile must be manually deployed to
  the device if a native application is built with
  Visual Studio 2005

26
Increased Device Support

• Microsoft Windows CE 5.0
• Microsoft Windows XP Tablet PC Edition
• Windows Mobile 2003 Software for Pocket PC
• Windows Mobile 5.0
• Future releases of the Pocket PC, SmartPhone, and
  Tablet PC

27
Database Upgrade Tool

• A command-prompt utility that upgrades a database
  created with SQL Server CE version 2.0 to the
  latest version of a SQL Server Mobile database
• The new database contains all data that was in
  the source database

28
Review

• Microsoft Office Mobile
• Using Windows Mobile 5 with Exchange Server 2003
• Using Windows Mobile 5 with Other Messaging
  Systems
• Microsoft SQL Server 2005 Mobile Edition