OneDB Explore Agent Setup

Select repository database

Repository server is the server which contains Repository database, which will be used to store all the monitoring data collected by OneDB Explore agent. Without selecting a repository database, user is not allowed to save agent setup changes. Repository database server can be any OneDB server specified in OneDB Explore User Interface.

TIP: User should create a dedicated database to store metrics to be captured by OneDB Explore agent. A new database can easily be created from Schema Manager page. Similarly metrics can be defined by adding Sensors from Motitoring page.

Following are two scenarios if repository database is not available for any reason:

1. OneDB Explore Agent is not configured yet:

   In this scenario, OneDB Explore agent configuration is not set yet by the user, probably user is setting up OneDB Explore agent for the first time. OneDB Explore agent connects with monitoring server using existing OneDB server connection properties.

   

2. OneDB Explore Agent is already configured:

   In this scenario, previously saved OneDB Explore agent configuration will be shown in read only mode. Basically, whenever user runs agent.jar, it will connect using the already saved configuration.

   

Add Connection Properties

Separate connection properties can be specified for the OneDB Explore agent. Users can specify connection properties for monitoring server and repository database server, respectively. Following are the two cases while specifying connection properties.

1. Repository database is located on monitoring Server:

   In this scenario, OneDB Explore agent will connect with monitoring server and repository database using the same connection properties.

   By default, OneDB Explore agent will use OneDB server connection properties (from OneDB server setup page) to connect with monitoring server and repository database. (When the checkbox is selected.)

   

   If needed, user can add/modify OneDB Explore agent connection properties by unchecking the checkbox as follows:

   

   This will be specifically useful for providing different SSL keystore path for OneDB Explore agent.

2. Repository database server is located on a different server:

   In this scenario, OneDB Explore agent will connect with monitoring server and repository database using different connection properties.

   By default, OneDB Explore agent will use connection properties of respective OneDB servers to connect with monitoring server and repository database, respectively. (When checkbox is checked)

   

   If needed, user can add/modify OneDB Explore agent connection properties for monitoring server and repository database separately by unchecking respective checkboxes as follows:

   

   This will be specifically useful for providing different SSL keystore path for monitoring server and repository database, respectively. See (Compatibility matrix for Java with SSL Keystore format).

   In both scenarios, if checkbox is unchecked, at least one connection property should be added to enable save button.

   

Compatibility matrix for Java with SSL Keystore format