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 can create a new database using the Oracle Database Configuration Assistant and install the sample schemas or manually install the sample schemas into a blank database via SQL*Plus. The sample schema SQL files are available through separate Example download packages directly from Oracle. For more information about installing both sample schemas, see http://www.oracle.com/technetwork/testcontent/connection11g-088156.html.
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 to the consolidated database
Lesson 4: Connecting with MobiLink
Lesson 5: Creating a MobiLink project and synchronization model
Lesson 6: 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 the remote client
Lesson 11: Viewing the data in the remote database
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|