GoDB Sync Server

GoDB Sync Server performs the task of distributing data in a central server to distributed clients and consolidating data updates from the clients back to the server.

During the Sync Process, GoDB Sync server detects changes in the server tables and sends them to the client and vice versa.

Sync Server Features:

Optimal Bandwidth Usage

• Detects Changes and synchronizes only changed data.
  
  
• Optional Full Sync.
  
  
• Data is compressed before transmission.
  
  

Data Integrity

• Incase of connection failure, sync continues from where it left off.
  
  
• Transaction rollback at the client.
  
  

Security

• User and Group based Table and Field level access.
  
  
• User and Group based File access.
  
  
• User and Group based Horizontal and vertical data partitioning.
  
  
• Support for SSL and VPN for secure data transfer for synchronization.
  
  

Customization

• Each stage of the sync process can be customized with server callbacks*.
  
  
• Custom rules can be defined to change default sync behavior.
  
  
• Data transformation, manipulation and validation (Data Scrubbing) can be done on the fly.
  
  
• Custom Rules can be defined for Horizontal and vertical data partitioning.
  
  
• Tables from multiple data sources (Ex Different databases like oracle db2 etc) can be used at the same time.

• Provision for custom asp scripts / java classes to do custom synchronization of data at table / field / row level.

Conflict Resolution

• Distributed Master-Transaction tables are synchronized without primary key duplication.
  
  
• Standard Conflict resolution rules like First-Win Last-Win are built-in.
  
  
• Application specific conflict resolution rules can be coded in server callbacks.
  
  

Audit

• Complete audit trail of all login attempts and data transfers.
  
  
• Drill down reports for analyzing data sync.
  
  
• Complete log of all the data conflicts and errors for easy debugging.
  
  

Application Distribution

• As the sync server can be used to distribute files, the client applications can also be updated during the sync process.
  
  
• Application Updates, Enhancements and patches can be distributed seamlessly.
  
  

Caching Engine

• Sync server comes with a powerful caching engine, effectively reducing database overhead.
  
  
• As the data is cached, clients get good response times thereby reducing network latency.
  
  

Developer Tools

• Web based interface to map tables to users and groups and setup access rules and security policies.
  
  
• Web based interface to create server callbacks.
  
  
• Compile custom scripts on the server and obtain debugging information through extensive logging capabilities of sync server.
  
  
• Developers can simulate all the parameters of the synchronization process in real time, without actually using a device.
  
  

Editions

Standard Editions : The standard edition is based on Microsoft technologies. This edition runs on Microsoft IIS with ASP or ASP.NET. The Data source for the sync server can be MS SQL server or ORACLE Databases.

Enterprise Edition : This edition is Developed on J2ee and can run on all Unix and Linux servers that have a J2ee compliant App server. Any Database with a JDBC 1.1x complaint driver can be used to source the data for sync.