Overview of the different data synchronization methods available for Oracle Lite
by Edmund Tan
.NET Compact Framework 3.5 Data-Driven Applications
- .NET Compact Framework 3.5 Data-Driven Applications
- .NET Compact Framework 3.5 Data-Driven Applications
- Credits
- About the Author
- About the Reviewer
- Preface
- 1. CRMLive.NET: An Overview
- Tomorrow Inc.
- Deciding on the type of mobile application
- Defining the mobile sales force application
- Defining the mobile dashboard application
- Defining the mobile support case application
- Summary
- 2. Building the Data Tier
- Designing the data tier
- Connecting the Windows Mobile emulator to ActiveSync
- Setting up SQL Server Compact 3.5
- Setting up Oracle Lite 10g
- Building the data tier
- Building the CRMLiveFramework project
- Building the Plugin Manager UI
- Building the database plugins
- Summary
- 3. Building the Mobile Sales Force Module
- A brief walkthrough of what you will be building
- Building a form navigation class
- Building the main menu
- Creating the business objects to encapsulate your DataSets
- Building the AccountViewer form
- Building the Tasks list
- Handling file attachments
- Custom formatting and display in list controls
- Building the ProductList control
- Building a paged listing of accounts
- Summary
- 4. Building Search Functionality
- A brief walk-through of parameterized search
- Building the parameterized search feature
- A brief walk-through of full-text search
- Building the full-text search feature
- Creating the Keyword Extractor classes
- A sample keyword extractor—the HTML Keyword Extractor
- Indexing the file
- Creating the full-text search query for SQL Server CE
- Creating the full-text search query for Oracle Lite
- Encapsulating the retrieved dataset using business objects
- Creating the full-text search forms
- Trying out the full-text search
- Improving the full-text search engine
- Summary
- 5. Building Integrated Services
- Sending SMS and e-mail from your application
- Intercepting incoming SMS
- Placing phone calls from your application
- Detecting incoming phone calls
- Populating the History tab in the sales force application
- Synchronizing with Windows Mobile Contacts
- Synchronizing with Windows Mobile Tasks
- Sharing an account between two devices
- Capturing handwritten input using the Smart Device Framework
- Summary
- 6. Data Synchronization
- Overview of the different data synchronization methods available for Microsoft SQL Server CE
- Overview of the different data synchronization methods available for Oracle Lite
- A quick comparison between the various Synchronization frameworks
- Using Microsoft Synchronization Services
- Using Oracle Mobile Server
- Installing Oracle Database Enterprise 11g and Oracle Mobile Server
- Creating an Oracle Mobile repository
- Creating the CRMLive server tables
- Creating a new publication using the Mobile Database Workbench
- Publishing the mobile application to the mobile server
- Setting up application users using the WebToGo portal
- Registering the mobile device with the mobile server
- Synchronizing with the mobile server
- Synchronizing files with the server
- Creating network-aware synchronization modules
- Summary
- 7. Optimizing for Performance
- 8. Securing the Application
- 9. Globalization
- 10. Building the Dashboard
- 11. Building the Support Case System
- 12. Testing and Debugging
- 13. Packaging and Deployment
The Oracle Lite suite provides synchronization services through the Oracle Mobile Server. Let's take a look at how this software works in the following section.
The Oracle Lite Mobile Server provides synchronization services between the Oracle Lite database on the mobile device and an Oracle database at the backend server. In fact, the Mobile Server does much more than that. It handles the management of all aspects of mobile application deployment, including user management for each application.
Tip
The WebToGo portal
The web-based WebToGo portal is used to manage the deployment of your mobile applications. This portal is included in the Oracle Mobile Server installation.
The Oracle Lite installation on the mobile device provides the Oracle MSync tool, which can be used to initiate a sync with the Oracle Mobile Server. The following diagram shows how these various components are connected to each other:
The great thing about using Oracle Mobile Server is that you can set up a sync without writing a single line of code. Most of the configuration work is done using the Mobile Database Workbench, a tool that allows you to define how the data and tables are synced down.
-
No Comment