Each MobiLink remote database can receive a subset of the data in the consolidated database. You can customize the download subset for each table.
The download subset options are:
User Choose this option to partition data by MobiLink user name, which downloads different data to different registered MobiLink users.
To use this option, each row must contain a column that contains a MobiLink user name. You choose your MobiLink user names when you deploy, so you can choose names that match existing values on your consolidated database. (The column that you use for MobiLink user names must be of a type that can hold the values you are using for the user name.) If the MobiLink user names are in a different table from the one you are subsetting, you must join to that table.
Remote ID Choose this option to partition data by remote ID, which downloads different data to different remote databases.
To use this option, each row must contain a column that holds a remote ID. Remote IDs are created as GUIDs by default, but you can set the remote IDs to match existing values on your consolidated database. (The column you use for remote IDs must be of a type that can hold the values you are using for the remote IDs.) If the remote IDs are in a different table from the one you are subsetting, you must join to that table.
It is usually better to partition by user or by authentication parameter than by remote ID, because the remote ID can change if the remote computer is reset or replaced.
Custom Choose this option to use a SQL expression that determines which rows are downloaded. Each synchronization only downloads rows where your SQL expression is true. This SQL expression is added to the WHERE clause of the generated download_cursor script. You can use MobiLink named parameters in the expression. You can also refer to other tables. If you refer to other tables, you must list the other tables in the field above the expression, and include the join condition in your expression.
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|