About device database table definitions
Device database table definitions are created for tables that are used on the mobile device, for example, tables for item or customer information.
Defining a device database table definition provides the structure for device data replication when created for the purpose of data replication to devices.
When planning to replicate data to devices, a device database table definition is associated with a registered table from the enterprise system. In this case, the ID of a device database table definition must match the name of the registered table. This match sets up the association between the registered table and the device database table definition for the purpose of device data replication.
Device database table definitions are specific to an environment, just as registered tables are specific to an environment. Device database tables are implemented in SQLite.
When a device database table definition is created with an ID that matches a registered table, a corresponding entry automatically appears on the Device Data Replication Rules page in Admin > Configuration > Device Data Replication. The replication rules for the table can then be edited on this page. For example, rules are defined that replicate data for only certain devices, device groups, users, or roles.
Also, from the Device Database Replication page, full data replication can be forced, and replication rules can be uploaded and downloaded. Partial data replication (as opposed to full) includes only differences since the last replication. The replication rule for a given table must be enabled in order for device data replication to take place for that table. The columns in a device database table do not have to match all columns in the registered table.
Mobile Client users are also able to initiate device data replication from their devices. They can choose to perform a partial replication that includes only differences since the last replication, or they can choose the Force full database download option for a full replication. System administrators can also Force a full replication for specified or all devices.
Device Database Tables must be licensed to use them in app development. The Device DB Tables icon is disabled if this component is not licensed, as are operations performed with device database tables in System Monitor, Mobile Client, and source elements in Application Studio (for example the Replicate Local DB source element). In Mobile Client, the application list is filtered to exclude apps with local database operations.
Define a device database table
By creating device database table definitions, the structure for device data replication is created. Fields are considered placeholders for the data added to the table definition.
To define a device database table, complete one of the following procedures in Advanced Inventory Platform Manager.
-
To configure a device table with no middle tier table, Complete Device Only configuration.
-
To configure a middle tier table that can be managed from Mobile Enterprise Platform, Complete DSI Managed Middle Tier configuration.
-
To configure a middle tier table that will be managed outside of Mobile Enterprise Platform, Complete Unmanaged Middle Tier configuration.
Loading...
There was a problem loading this topic