Transcript Module 2: Planning for Mobility

Module 3: Microsoft
Mobility Solutions
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
Lesson: Microsoft Office Mobile
Microsoft Office Mobile Functionality
Microsoft Excel Mobile
Microsoft PowerPoint Mobile
Microsoft Word Mobile
Windows Media Player Mobile
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
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
Microsoft PowerPoint Mobile
Open and view slide show presentations created on your
PC on your Windows Mobile–powered 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
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
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
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
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
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
Exchange Server 2003 Mobility Features
ActiveSync
 Exchange ActiveSync
 ActiveSync 4.1
Pocket PC and Smartphone support
Up-to-date notifications synchronization
Different ways of Accessing Exchange
Information Remotely
Using Outlook 2003 with
RPC/HTTP
Using Outlook Web Access
Microsoft Exchange 2003
Exchange
Front-End
Exchange
Exchange Server
Back-End
Back-End
Server
Server
Microsoft Exchange 2003
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
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
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
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
Third-Party Enterprise Messaging Solutions
Using Windows Mobile 5.0
Third-party mobile messaging solutions designed to
integrate with Windows Mobile 5.0 include:
iAnywhere’s Extended Systems
Good Technology’s GoodLink™ Wireless Messaging
Nokia’s Intellisync Mobile Suite 6
JP Mobile’s SureWave® Mobile Office 5.0
Smartner’s Duality Always-on Mail® solution
Visto’s Mobile™ Enterprise Server
Using Windows Mobile 5.0 with POP3, IMAP4,
and SMTP
Setting up POP3 or IMAP4 e-mail – auto configuration
1.
Tap Start > Messaging
2.
Tap Menu > Tools > New Account
3.
Enter your e-mail address, and then tap Next
4.
Tap Record to begin recording
5.
Enter your name (the name you want displayed when you
send e-mail) and your password
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
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
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
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
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
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
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
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
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