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

SQL Anywhere 17 » MobiLink - Getting Started » MobiLink synchronization

Parts of a MobiLink application

In MobiLink synchronization, many clients synchronize through the MobiLink server to central data sources.


The MobiLink architecture, showing the MobiLink clients, the network, the MobiLink server, an ODBC connection to the consolidated database, and an optional connection to an alternate data source.
  • MobiLink clients

    The client can be installed on an Android device, a server, or desktop computer. Two types of clients are supported: UltraLite and SQL Anywhere databases. Either or both can be used in a MobiLink installation.

  • Network

    The connection between the MobiLink server and the MobiLink client can use several protocols. See:

    • MobiLink server: -x mlsrv17 option
    • UltraLite and SQL Anywhere clients: MobiLink client network protocol options
  • MobiLink server

    This server manages the synchronization process and provides the interface between all MobiLink clients and the consolidated database server.

  • Consolidated database

    This database typically contains the central copy of your application information in the synchronization system. It also typically holds system tables and procedures that are required by MobiLink synchronization, and state information needed to synchronize.

  • State information

    The MobiLink server typically maintains synchronization information in system tables in the consolidated database. It does this over an ODBC connection.

    You can also choose to store your state information in a separate database.

  • SQL row handling

    If you provide the MobiLink server with SQL scripts, it uses these scripts to transfer rows to and from the consolidated database over an ODBC connection.

  • Direct row handling

    In addition to a consolidated database, you can optionally synchronize with other data sources using MobiLink direct row handling.

  • Synchronization scripts

    You write synchronization scripts for each table in the remote database and you save these scripts in MobiLink system tables in the consolidated database. These scripts determine what is done with the uploaded data, and what data to download. There are two types of script: table scripts and connection-level scripts.