Set up the server configuration file

The DB Sync server programs need the configuration file to provide central database connection information and database schema file specification.

Important:

The tasks described in this section will create the DB Sync server configuration file in the "conf" sub-directory of the DB Sync deployment directory of the GAS. Before un-deploying the DB Sync system and removing the deployed files from the GAS, you may want to keep a copy of the configuration file.

Set up the DB Sync server configuration parameter file.

Tip:

In the context of GAS upgrade, you might just want to copy the files form the previous GAS installation.

This step will create a dbsync_config.json file in the conf directory, under the GAS deployment directory of DB Sync configuration apps.
  1. Open the dbsync.html starter page in a browser: 
    http[s]://host:port/ua/web/dbsync_setup_server_config/dbsync.html
    For example:
    http://toro:6394/ua/web/dbsync_setup_server_config/dbsync.html

  2. Start the Server configuration application.

  3. Connect as dbsync_admin user.

  4. Provide the file path to the DB Sync database schema file for your application database. This step is just to provide the schema filename. The schema file can be created later, if it does not yet exist.

  5. Enter database connection parameters: DB name, DB source, ODI driver, DB user login and password. For DB user password encryption:

    In order to encrypt the DB user password, create an RSA private key PEM file as described in Server configuration file, then proceed as follows:

    1. Enter the full path to your your .pem file in the PEM field.

    2. Click on the Password Input button.

    3. Enter the DB user password in the prompt and accept the input with OK button: The encrypted password is written to the password field.

  6. Click the OK button to check the DB connection and save the settings.

  7. Connection to the application database is checked.

  8. If DB Sync system tables do not exist yet, the tool will create the tables. See also Create DB Sync system tables.