Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » MobiLink - Getting Started » MobiLink tutorials


Tutorial: Using MobiLink with an Oracle Database 10g

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 [external link]

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.

 Required software
 Permissions and privileges
 See also

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
Cleaning up