Preparing consolidated databases
Whether you are designing a new database or preparing an existing
one to be used as a MobiLink consolidated database, you must install the
MobiLink system tables in that database. SQL Anywhere provides setup
scripts for SAP Adaptive Server Enterprise, Oracle, Microsoft SQL Server,
and IBM DB2. A setup script is not required for SQL Anywhere
databases.
MobiLink system tables store information for MobiLink users, tables,
scripts, and script versions in the consolidated database. You will
probably not directly access these tables, but you alter them when you
perform actions such as adding synchronization scripts.
ODBC connections and drivers
To carry out synchronization, the MobiLink synchronization server
needs an ODBC connection to the consolidated database. You must have an
ODBC driver for your server and you must create an ODBC data source for
the database on the machine on which your MobiLink synchronization server
is running. For a list of supported drivers, see Recommended ODBC Drivers
for MobiLink at https://archive.sap.com/documents/docs/DOC-67711.
Writing synchronization
scripts
There are two types of events that occur during synchronization and
for which you need to write synchronization scripts:
-
Connection events that
perform global tasks required during every synchronization -
Table events that are
associated with a specific table and perform tasks related to
modifying data in that table