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.
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.
-
Open the
dbsync.html
starter page in a browser:
For example:http[s]://host:port/ua/web/dbsync_setup_server_config/dbsync.html
http://toro:6394/ua/web/dbsync_setup_server_config/dbsync.html
-
Start the Server configuration application.
-
Connect as
dbsync_admin
user. -
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.
-
Enter database connection parameters (name, DB source, ODI driver, etc)
-
Validate the input.
-
Connection to the application database is checked.
-
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.