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

SQL Anywhere 17 » MobiLink - Server Administration

MobiLink consolidated databases

Your consolidated database holds system objects that are required by MobiLink. Usually, it also holds your application data, but you can hold all or part of your application data in other forms as well.

MobiLink supports consolidated databases for Windows and Linux. Your consolidated database can be one of the following ODBC-compliant RDBMSs:

  • Adaptive Server Enterprise
  • Microsoft SQL Server
  • MySQL
  • Oracle
  • SAP IQ

Your SQL Anywhere installation includes a MobiLink setup script for each type of RDBMS. You must run the appropriate setup script to use that RDBMS with MobiLink. The setup script adds tables and stored procedures that are required by MobiLink.

Synchronizing to other data sources

Your MobiLink environment must have a database that has been set up as a consolidated database. However, you can use direct row handling to synchronize data sources other than the consolidated database. The other data sources can be almost anything: a text file, web service, non-relational database, spreadsheet, and so on. You can:

  • Synchronize to only a consolidated database.

  • Synchronize to only another data source.

  • Create a hybrid application in which you synchronize to both a consolidated database and some other data source.

Restrictions on modifying your consolidated database

Some users have limited ability to change the schema of their consolidated database. For these situations, MobiLink provides solutions, where possible, to keep changes to the consolidated database to a minimum. For example, MobiLink offers a variety of solutions for maintaining unique primary keys across the synchronization system, some of which have minimal impact on the consolidated database schema.

In addition, you can avoid almost all impact on your consolidated database by putting your MobiLink system objects in a separate database.