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.

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 (name, DB source, ODI driver, etc)

  6. Validate the input.

  7. Connection to the application database is checked.

  8. If DB Sync system tables do not exist yet, the tool will create the tables. The system tables can also be created from the command line with the dbsync_setup tool.