Support for device tracking

Note

You only need to support device tracking if you are using MobiLink Listeners running on SQL Anywhere 9.0.0 or earlier. Device tracking is already supported on all other MobiLink Listeners for Windows devices.

Several system procedures are available to manually set up device tracking for 9.0.0 MobiLink Listeners. These procedures update the ml_device, ml_device_address, and ml_listening MobiLink system tables on the consolidated database.

Prerequisites

There are no prerequisites for performing this task.

Context and remarks

With manual device tracking, you can address recipients by MobiLink user name without providing network address information. However, the information cannot be automatically updated by MobiLink if it changes; you must change it manually. This method is especially useful for SMTP gateways because email addresses seldom change.

For UDP gateways, you can not rely on static entries if your IP address changes every time you reconnect. You can resolve this problem by addressing the host name instead of IP address. However, this solution slows updates to DNS server tables, and can misdirect push notifications. You can also set up system procedures to update the system tables programmatically.

 Manually set up device tracking for 9.0.0 MobiLink Listeners

  1. For each device, add a device record to the ml_device system table. For example:

    CALL ml_set_device(
    'myWindowsMobile', 
    'MobiLink Listeners for myWindowsMobile - 9.0.1',
    '1', 
    'not used', 
    'y', 
    'manually entered by administrator'
);

    The first parameter, myWindowsMobile, is a unique user-defined device name. The second parameter contains optional remarks about the MobiLink Listener version. The third parameter specifies a MobiLink Listener version; use 0 for SQL Anywhere 9.0.0 MobiLink Listeners, or 2 for post-9.0.0 MobiLink Listeners for Windows. The fourth parameter specifies optional device information. The fifth parameter specifies whether device tracking should be ignored. The final parameter contains optional remarks for this entry.

  2. For each device, add an address record to the ml_device_address system table. For example:

    CALL ml_set_device_address(
    'myWindowsMobile', 
    'ROGERS AT&T',  
    '55511234567', 
    'y', 
    'y',
    'manually entered by administrator'
);

    The first parameter, myWindowsMobile, is a user-defined unique device name. The second parameter is a network provider ID, which must match the network_provider_id carrier property. The third parameter is an IP address for UDP. The fourth parameter determines whether to activate this entry for sending push notifications. The fifth parameter specifies whether device tracking should be ignored. The final parameter contains optional remarks for this entry.

  3. For each remote database, add a recipient record to the ml_listening system table for each device you added. This maps the device to the MobiLink user name. For example: 

    CALL ml_set_listening(
    'myULDB',
    'myWindowsMobile',
    'y',
    'y',
    'manually entered by administrator'
);

    The first parameter is a MobiLink user name. The second parameter is a user-defined unique device name. The third parameter determines whether to activate this entry for device tracking addressing. The fourth parameter specifies whether device tracking should be ignored. The final parameter contains optional remarks for this entry.

Results

The specified devices are set up for device tracking.

Next

None.

 See also
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1