The objective of ‘Data Synch’ is to achieve data uniformity between the hosted web server database and the back-office database. Through this activity, we are consolidating the data, which are spread across various systems (Synch Clients).

The main facility offered in the ‘Biz Synch’ is that it transports only the new and changed data at the client/server side.

‘Biz Synch Client’ is designed to handle large volumes of data through a data transport mechanism in batches. For example, if there are 10,000 bytes of data to be transferred, and a transfer size is set to 2000 bytes, then Biz Sync Client defines the data payload in 5 batches. In the event of disruption of connectivity while sending (say) the 3rd batch of data, the next time on reconnect, only the remaining 3 batches are uploaded.

‘Synch Server’ could run as a service or as an executable at the server side. ‘Sync Server’ is TCP based and listens on a configured data-port. ‘Synch Server’ receives data from ‘Synch Client’ in a designated format.  Based on the type of request (upload or download), ‘Synch Server’ will receive and send data to/from the Synch Client.

Server service could be either a manual startup or an automatic startup. Manual startup means each time when the user re-starts the computer, he needs to start the ‘Synch Server’ manually. But, if the user sets the service as automatic, the ‘Synch Server’ would auto-start and listen at the designated port when the machine is restarted.

This is a GUI (Graphic User Interface) tool, which will prompt a login window at the startup.  If authenticated, then a main window will get loaded with the facilities of entering Server name (IP or System Name) and the port in which server should listen. If successfully connected to the Server in the given port, then upload/download options will get enabled.     The ‘Synch Server’ only communicates in a specified format/protocol with each Sync Client request. This makes The Synch system is secure. Only the administrator has permission to run synch client application.

Synch Network Diagram: -

In real time scenario, Data Synchronizer’s workflow would be as follows:

On ‘Synch Server’ startup, a login dashboard would popup as follows. After entering user name and password, click ‘ok’ to get into the next window. This provides application level security.

Only the user who knows the user name and password can only use ‘Synch Server’ application. This is to provide application level security. If the login name or password is wrong, this will be prompted by ‘Synch Client’ application.

If server is installed as service, no window will be displayed. Otherwise, once the user is authenticated, the ‘Synch Server’ application window will be displayed as shown below.

Once the user click ‘Start Server Service’ button, ‘Synch Server’ will start running in the given port and the caption of the command button changes to ‘Stop Server Service’. At this time, the window will look like as shown below.

To stop the ‘Synch Server’, user has to either click the ‘Stop Server Service’ button or the ‘X’ button at the top right most of the window.

On ‘Biz Synch Client’ startup, a login dashboard would popup. Only the user with valid user name and password can use ‘Biz Synch Client’ application. This is to provide application level security. The upload/download buttons will be disabled till connection is acquired from the synch server.

To connect to the specified server with the given port, click ‘ok’ button. Once you click the ‘ok’ button, ‘Synch Client’ window will look like as shown below. It will take least seconds to check that connection could be established or not.

If the connection is rejected, server will intimate it to the ‘Synch Client’ application and terminate the application. ‘Synch Client’ will display the received message as shown below.

If the connection is successful, upload/download buttons will be enabled. The window will look like as shown below.

Next, user has to either click upload/download button to do its respective functionalities.  A user can either click the ‘Close’ button or click ‘X’ button at the top right most to close the ‘Synch Client’ application.  If the user clicks upload button, first ‘Synch Client’ check each table and calculate number of batches to be uploaded to the server based on the transfer size user sets.

Once each table is verified, the upload details like total number of batches, transfer size, and total size of data to be uploaded would be displayed in the window. Then, ‘Synch Client’ will start reading data from the database and upload data to server. ‘Synch Client’ window will look as shown below at that time.

Once, the full data is uploaded to server, ‘Synch Client’ will then check for log details like outdated data, error information, deletion information etc. The synch client window would be look like as shown below at that time.

 If there is log details available, that window will be popup as shown below. For deletion confirmation of local records, user has to ‘check’ the check boxes. Synch client would not delete the records, which is unchecked.

We are through with upload functionalities of ‘Synch Client’. If the user wants to download data from the server, click the ‘download’ button. Once, the user click ‘download’ button, all other buttons will get disabled immediately. At download startup, the window will look like as shown below.

The same way in upload, for download also, synch client will check each table and calculate the number of batches to be downloaded from server based on the transfer size user sets.

Once calculation of batch size is over, if data is present at the server to download, synch client will start downloading data from the server.

Once the download is over, confirmation windows will be popup. For deletion, user has to select the records from the list given in the window to intimate that can ‘Synch Client’ can delete a record or not.  At the time of execution, upload and download button would be disabled. After the completion of the execution, these two buttons will get enabled.

This tool will be installed at the server as well as at the client side. Server and client will have records with the various flag value, which would be usually replaced by synch tool if the synch activity finished properly. If the system got crashed or some untoward thing happened while synch activity is on, you cannot upload or download data after you re-started system or application at the respective end. But, once you run this recovery tool, it would replace these flag values with appropriate value.

Although functionalities are same, client and server applications are two different executables because server will have ‘N’ number of domains. So for server recovery tool, you have to select domain which user want to recover.

To start recovery, click on ‘Recover’ button. It will check for ‘new data’, ’modified data’ and ‘deleted data’ to restore data.

Once recovery is on, the window will look like as shown below. To close recovery application, click on ‘X’ button at the top right most.

Server Recovery Tool Workflow Diagram

To start recovery, first select the domain and click ‘Recover’ button. It will check for ‘new data’, ’modified data’ and ‘deleted data’ to restore data.

Once recovery is on, the window will look like as shown below. To close recovery application, click on ‘X’ button at the top right most.