DB Sync implementation tasks

The section gives an overview of the tasks to achieve database synchronization between a central database and remote databases used by nomad apps.

To illustrate the configuration steps, this documentation is using a "library" demo database and client app that can be found in DBSYNCDIR/demo/book. Adapt the steps referring to the "library" demo to your own application database and client app(s).

The setup steps described in this documentation apply to a single database entity. If you want to share the data from multiple central database entities, contact your local support center for help.

In order to implement database synchronization with the DB Sync system, you must:

  1. Have a server hosting the central database with a running SQL engine.

  2. Have FGLGWS and GAS products installed on the database server, and FGLGWS tools installed on a development computer: Software Requirements.

  3. Install the DB Sync software package: Package installation.

  4. Decide which application and database locale you want to use: Locale settings.

  5. Configure the GAS and SSO/GIP for the DB Sync system: Set up DB Sync with GAS/GIP. For testing purpose, you can use the direct mode: Set up DB Sync in direct mode.

  6. Define a database schema of the central database, with information about SQL table columns, relations between tables, auto-incremented columns: Database schema reference.

  7. Use the DB Sync client apps console, to declare apps with associated SQL tables and data filters: Apps definition console.

  8. Implement DB Sync into your client apps code, using the DB Sync client API: Implementing a DB Sync client app.

  9. If server-side client apps directly update the SQL tables in the central database, implement DB Sync into these server-side client apps: Implementing a DB Sync server-side app.