Configure the connection to a JDBC database
You can adjust an existing or add a new connection to a JDBC database.
Use the UpdateSourceSystemConfiguration.json configuration file to adjust the settings. The file is located in the <Process Extractor installation>\conf\ directory.
The parameters are described in UpdateSourceSystemConfiguration.md file located in the same directory. The file contains a sample configuration for a JDBC connection that you can customize and use to configure the connection to your JDBC database.
Note that for the database user used to read from the database, the required access privileges are configured. For security reasons, the user should have read-only privileges for the required data.
Warning
Do not change the SourceSystemConfiguration.json file manually. The file is automatically updated with your settings by the CLI tool.
Example
{
"jdbcconfigurations" : [ {
"configurationAlias" : "some_unique_alias",
"secret" : "",
"dbURL" : "database_url",
"dbDriverClass" : "database_jdbc_driver_class",
"dbUser" : "database_user",
"dbPassword" : "password_set_with_configure_extractor",
}, {
...
}]
}