Actors of DB Sync
DB Sync involves three key roles: the System Administrator, who handles installation and setup; the Application Developer, who integrates DB Sync into applications to perform the synchronization processes; and the Client Application Administrator, who configures client app settings, manages permissions, and addresses sync issues without altering the database.
System Administrator
The System Administrator performs the installation and initial setup, including the integration into GAS / GIP.
Application Developer
The Application Developer implements the necessary code in the app – whether it is a server-side app or a client-side app – by using the DB Sync API.
This added code registers the SQL changes in the local database, sends synchronization requests, and handles conflicts that cause local changes to be merged with central changes, then try a new sync request.
Client Application Administrator
The Client Application Administrator sets up the DB Sync client app definitions, controls app and user permissions, and defines the data filters for App-User-Table combinations.
They may also play the role of the support engineer, answering inquiries about why a sync was rejected by looking at the DB Sync server logs. They can explain what happened but will not work around the system to make any changes in the database; the client app code must handle conflicts and merges automatically using the DB Sync API.