Chapter 3. Synchronizing with DB2 databases 247
3.10.2 Upload subscription
The upload subscription process, as the name suggests, is one way only. It
allows the client to insert rows into the source database, but not the other way
around. There is no mirror database involved in the upload subscription process,
which is illustrated in Figure 3-46 on page 247. In this sample scenario, a DB2
back-end database is used as the source database.
Figure 3-46 Upload subscription - Sample scenario
To create an upload subscription:
1. Open the Mobile Devices Administration Center by clicking Start ->
Programs -> IBM DB2 Everyplace -> Start Mobile Device Administration
Center.
2. In the Mobile Devices Administration Center, select Subscription -> Create
-> Table Subscription -> Upload subscription.
LDAP
Directory
Services
IBM HTTP Server
mka6brhl.itso.ral.ibm.com
Port 80
Basic Authentication
SSL (optional)
DB2e Sync
Everyplace Client
DB2e Database
DB2
Everyplace
Mobile Devices
Administration
Center
(MDAC)
Users and
Groups
Subscription
Set and
Subscriptions
DB2 Database
(LDAP Data)
Source
Database
(DB2)
IBM WebSphere Everyplace
Access
DB2e Sync Server
(Servlet)
Synchronization
Upload Subscription
No Mirror Database
No Replication Required
JDBC
248 IBM WebSphere Everyplace Access V5 Handbook for Developers and Administrators Volume III: E-Mail and Database Synchronization
Figure 3-47 Create upload subscription
3. The Create Upload Subscription wizard opens. On the Identification tab, type
in a name for this subscription, for example, MedicalRecord. Optionally, enter
a description for this subscription.
Figure 3-48 Name the subscription
Chapter 3. Synchronizing with DB2 databases 249
4. Click the Source tab. Choose the suitable database driver by clicking the
down arrow next to the Driver field.
Figure 3-49 Setup source database
5. In the same window, enter the user ID and password that can access the
source database.
6. Click the Subscription sets tab. Select the subscription sets this subscription
will belong to and click > or >> to bring them to the Selected subscription sets
pane. You can also click Create to create a new subscription set.
250 IBM WebSphere Everyplace Access V5 Handbook for Developers and Administrators Volume III: E-Mail and Database Synchronization
Figure 3-50 Select subscription set
7. Click the Identification tab again. Click the Define subscription button. The
Define Upload Subscription wizard opens.
Figure 3-51 Define Upload Subscription wizard
8. Click the Add button to open the Add window.
9. Select the table into which rows will be inserted from the client. Change the
Target schema and Target table name if they are different from the defaults.
Click Add. Repeat for more tables. Click Close when done.

Get IBM WebSphere Everyplace Access V5 Handbook for Developers and Administrators Volume III: E-Mail and Database Synchronization now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.