This tutorial shows you to mobilize an Oracle Database 10g using MobiLink. It sets up synchronization between an Oracle Database 10g and a SQL Anywhere remote database. You could also set up an UltraLite remote database.
The purpose of this tutorial is to mobilize the data pertaining to a sales team. In this scenario, each salesperson is a remote synchronization client. Each salesperson has a local SQL Anywhere database that is synchronized to a corporate Oracle database at headquarters using MobiLink. Each salesperson accesses corporate data with their laptop or mobile device, and manipulates data from the remote database.
This tutorial assumes you performed a basic installation of Oracle Database 10g, which creates a starter database named orcl. The orcl database has the Order Entry (OE) and Human Relations (HR) sample schemas. Alternatively, you may manually install the sample schemas or use the Oracle Database Configuration Assistant. For more information about installing both sample schemas, see http://www.oracle.com/technology/obe/obe1013jdev/common/OBEConnection.htm.
This tutorial assumes that you can connect to Oracle as the SYS user with SYSDBA privileges. This is a requirement when you grant permission for the GV_$TRANSACTION Oracle system view. The password for the SYS user is set during installation of an Oracle database.
Lesson 1: Designing the schemas
Lesson 2: Preparing the consolidated database
Lesson 3: Adding unique keys
Lesson 4: Connecting with MobiLink
Lesson 5: Creating a MobiLink project
Lesson 6: Creating and modifying a synchronization model
Lesson 7: Deploying the synchronization model
Lesson 8: Starting the server and client
Lesson 9: Setting the remote ID
Lesson 10: Synchronizing
Lesson 11: Viewing the data in the remote database
Discuss this page in DocCommentXchange.
|Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1|