Updates
About normal updates
The Normal Update function is a continuous synchronization process. As records change in the application physical file, the corresponding database table on the database server is uploaded.
The following actions occur when you use the Normal Update process.
-
The enterprise or Mobile Enterprise Platform program changes, adds, or deletes records in an application data file for which a physical file trigger has been added. The operating system detects the change and calls the Universal Trigger program (UT).
-
The UT program receives images of the affected physical file records and adds the records to the Trigger Results files (1).
-
The SocketSync Server job selects records based on user-defined selection criteria and sends them, one by one, to the TranConnect Synchronization Agent (2).
-
The TranConnect Synchronization Agent receives the next available record from the SocketSync Server job (3) and writes it to the applicable corresponding database tables on the database server (4).
-
The Purge Server job deletes the records in the Trigger Results files based on the number of days specified in the UDC table SS/01 (retention days).
The following diagram shows the normal update process for synchronizing records.
About the full update function
The Full Update function replaces all records in the database table with the records in the corresponding logical file. The database table is cleared of all records and becomes an exact image of the logical file.
Run the Full Update process when doing the following actions:
-
Synchronizing the database table for the first time
-
Making a change in your business operations that might affect the filtering of records
-
Troubleshooting a problem with the synchronized records
The following actions occur when you use the Full Update process:.
-
The SocketSync Server job receives a request from the TranConnect Synchronization Agent for a full update. The SocketSync Server job retrieves the records, one by one, based on user-defined selection criteria. The program only selects the records that match the selection criteria (1).
-
The TranConnect Synchronization Agent receives the records directly from the application logical file (2) and writes them to the applicable corresponding database table on the database server (3).
The following diagram shows the full update process for synchronizing records.
Loading...
There was a problem loading this topic