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


Lesson 5: Creating a MobiLink project and synchronization model

In this lesson, you connect to the consolidated database by creating a new MobiLink project. A synchronization model is created automatically when you create a project.


This lesson assumes you have completed all preceding lessons. See Lesson 1: Designing the schemas.

This lesson assumes you have the roles and privileges listed in the Permissions and privileges section at the start of this tutorial: Tutorial: Using MobiLink with an Oracle Database 10g.

  1. Click Start » Programs » SQL Anywhere 16 » Administration Tools » Sybase Central.

  2. Click Tools » MobiLink 16 » New Project.

    The Create Project Wizard appears.

  3. In the What do you want to name the new project field, type oracle_project.

  4. In the Where do you want to save the new project field, type C:\mlora, and click Next.

  5. In the Database display name field, type oracle_cons.

  6. Click Edit.

  7. Perform the following tasks in the Connect To A Generic ODBC Database page:

    1. In the User ID field, type OE.

    2. In the Password field, type the password for the sql account.

    3. In the ODBC Data Source name field, click Browse, and choose oracle_cons.

    4. Click OK, and click Save.

  8. Select the Remember the password option, and click Next.

  9. In the Consolidated Schema Owners window, select Only load the database schema for selected owners and check OE user.

  10. On the New Remote Database Schema page, in the Which consolidated database tables and columns do you want to have in your remote database list, choose the following tables and then click Next:

    • ORDERS
  11. Choose the Add a remote schema name to the project option.

  12. Type oracle_remote_schema for the remote schema name, and then click Next.

  13. Select the SQL Anywhere option, and then click Finish.

    If this is the first time the consolidated database has been used by MobiLink, a message appears asking you to install the MobiLink system setup. Installing the MobiLink system setup adds MobiLink system tables and procedures. Click Yes, and then click OK.


A MobiLink project and synchronization model are created.