This tutorial shows you to mobilize an Oracle 10g database using MobiLink. It sets up synchronization between an Oracle 10g consolidated database 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 access corporate data with their laptop or handheld device, and manipulates data from the remote database.
This tutorial assumes that you have a complete install of SQL Anywhere (including MobiLink) on your local computer where you are running the tutorial. This tutorial was created using Oracle Database 10g Release 2. The tutorial may work for other versions of Oracle, but this is not guaranteed. This tutorial also assumes that you have installed Oracle Database 10g on your local computer, but you may also access it remotely.
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 in Lesson 7 when you grant permission for the V_$TRANSACTION Oracle system view. The password for the SYS user is set during installation of an Oracle database.
This tutorial shows you how to:
For an overview of MobiLink synchronization, see Introducing MobiLink synchronization.
For an overview of MobiLink models, see MobiLink models.
|Send feedback about this page via email or DocCommentXchange||Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0|