Combine parameter settings to control how data is cached in the CDB, and filtered and returned to a device application.
Parameters | Result |
---|---|
No load or synchronization parameters are defined. |
All table data is downloaded to the device. The SQL definition is: select * from sampledb.dba.customer |
The region synchronization parameter is defined, but not used as a load parameter. |
Only customers from a specific region are downloaded to the device. Typically, region is paired with a personalization key. For example, a sales representative living and working in the western region is interested only in customers from that region. The SQL definition is: select cust_id, cust_name, region from sampledb.dba.customer where region=:region |
The region parameter is defined, used as a load parameter, and as a synchronization parameter. |
Occurs if data refresh requires a region parameter and a synchronization parameter. This scenario is more likely for Web service and SAP MBOs than for database MBOs. |
Load parameters are mapped to username and password personalization keys, and a separate synchronization parameter is mapped to region. |
Refresh data only for the authenticated user, but synchronize based on the region: select cust_id, cust_name, region from sampledb.dba.customer where region=:region, for user A. |