Server configuration file

A DB Sync server configuration file is used on the server-side by DB Sync configuration tools and the DB Sync service program.

The DB Sync server configuration file includes parameters to define the DB Sync database schema and establish the SQL connection to the central database engine.

The DB Sync server configuration file must be distributed with the program files of DB Sync server tools and service program.

When using GAS/GIP, the deployment of server files is done with the dbsync_tool deploy-dbsync command. The location of the server configuration file is predefined, as described in Set up the server configuration file.

When using the direct mode, install the server configuration file manually in the location of your choice.

A template for the DB Sync server configuration file is provided in $DBSYNCDIR/etc/server_config.json.

The server-side configuration file can be edited with the [dbsync_setup server-config] tool.

Example of server-side DB Sync configuration file for PostgreSQL:
{
    "schema_file": "./mystore.json",
    "dbconn": {
        "dbname": "mystore",
        "owner": "public",
        "source": "mystore@localhost:5432",
        "driver": "dbmpgs_9",
        "uname": "pgsuser",
        "upswd": "fourjs"
    }
}
where:
  • schema_file: Defines the path to the DB Sync database schema file.
  • dbconn: Defines central SQL database connection parameters:
    • dbname: The name of the database in programs.
    • source: The database source (like fglprofile dbi.database.dbname.source)
    • driver: The database client ODI driver (like fglprofile dbi.database.dbname.driver)
    • uname: The database user login (like fglprofile dbi.database.dbname.username)
    • upswd: The database user password (like fglprofile dbi.database.dbname.password)
Important:

Consider using a database user authentication method that does not expose the login/password in clear in the server configuration file.