Mobile Staging Database and SQL Server Integration Services Prerequisites

The mobile staging database is used to replicate data between the business solution and mobile devices. The mobile staging database contains a subset of tables and data that are extracted from the business solution and then replicated on mobile devices in the required format. The mobile staging database is updated using SQL Server Integration Services (SSIS). The following figure illustrates the mobile stagig database components in the mobile architecture.

Caution noteCaution

To prevent malicious users from gaining access to your business critical data, such as customers, price lists, and customer activities, you must protect this data. Ensure that the data is stored in an encrypted database on the device. However, not all data needs to be stored in an encrypted database, such as the task and appointment data of Pocket Outlook. So, consider which data must be stored in the encrypted database and which data does not. Data that is not encrypted on the device is only protected by the standard device password/PIN code security, if enabled.

For more information about the mobile staging database, see Configuring the Mobile Staging Database and SQL Server Replication.

Installation Requirements

The mobile staging database requires the following software to configure and update successfully:

Software Purpose

One of the following operating systems:

  • Microsoft Windows 2000 Server with Service Pack (SP) 4 or later.

  • Windows 2000 Professional Edition with SP 4 or later.

  • Windows XP with SP 2 or later.

  • Windows Vista.

  • Windows Server 2003 Enterprise Edition, Standard Edition, or Datacenter Edition with SP 1 or later.

  • Windows Server 2008, 32 and 64 bit

  • Windows Small Business Server 2003 with SP 1 or later.

Operating system.

Microsoft SQL Server 2005 or Microsoft SQL Server 2008, including Client Components and SQL Server Management Studio, Replication services, and Integration Services (SSIS).

Required for the configuration of the mobile staging database and subsequent updates.

Integration Services extracts a subset of the data from the business solution database and loads it to the mobile staging database.

Internet Information Services (IIS) 6.0 or Internet Information Services (IIS) 7.0 with a server certificate that enables the use of SSL

A Web server to replicate data from the mobile staging database to the mobile device.

This can be the same server that is used for Microsoft Dynamics Mobile - Server Components.

Microsoft SQL Server Compact 3.5 Service Pack 1 Server Tools

Enables mobile clients to synchronize with the server. SQL Server Compact 3.5 Server Tools must be installed on the IIS server that acts as the Web server for the mobile staging database.

See Also

Community Additions