Configuring the Denodo Monitor¶
To start using the Denodo Monitor, follow these steps:
Go to the directory
<DENODO_HOME>/tools/monitor
.On Windows, decompress the file
denodo-monitor.zip
.On Linux, execute this:
tar -xzf denodo-monitor.tar.gz
.Edit the file
conf/ConfigurationParameters.properties
to configure it.Although usually the default configuration of the Denodo Monitor is correct, you can find a description of the main properties right after this list of steps.
To start the Denodo Monitor go to bin, in the directory of the Denodo Monitor and do this:
On Linux, execute
./denodomonitor_startup.sh
.On Windows, execute
denodomonitor_startup.bat
.
Then, change the values of all the properties jmx.host
,
jmx.port
, jmx.user
and jmx.password
. Each monitor will read
these properties to know the URI and credentials of the Server it has to
monitor.
Almost all the properties in this configuration file are self-explanatory, so we are going to review only the most important ones:
jmx.user
. User name of an administrator or a user with the rolejmxadmin
. Other users cannot connect to the JMX interface of Virtual DataPort.monitors.local
. Comma-separated list of local active “monitors”:processes
andsockets
(see section Local Monitors).monitors.remote
. Comma-separated list of the monitors you want to launch:vdp
,browserpool
,maintenance
,scheduler
orschedulerindex
.{ browserpool | maintenance | scheduler | schedulerindex | vdp }.monitors
. Properties that indicate which remote “monitors” will be active for each Server.The possible values for these properties are:
threads
resources
vdpqueries
(only forvdp
): to enable the “Virtual DataPort Queries Monitor”.vdploadcacheprocesses
(only forvdp
): to enable the “Virtual DataPort Cache Monitor”.vdpconnections
(only forvdp
): to enable the “Virtual DataPort Connections Monitor”.vdpdatasources
(only forvdp
): to enable the “Virtual DataPort Data Sources Monitor”.
{ processes | sockets | resources | threads }.interval
. Number of seconds between two JMX requests issued by that monitor.The properties
.jmx.password
store the password to connect to the Server of that property. These passwords can be stored encrypted. To do this, set the value of the property.jmx.password.encrypted
totrue
if the value of.jmx.password
is encrypted.For example, by default the Virtual DataPort password is
admin
. If you changed it and you want to store it in this configuration file encrypted, do the following:Execute the script
<DENODO_HOME>/tools/monitor/denodo-monitor/bin/encrypt_password <new password>
The output of this script is the encrypted password that you will put in the configuration file of the Denodo Monitor.
Open the file
<DENODO_HOME>/tools/monitor/denodo-monitor/conf/ConfigurationParameters.properties
Set the value of the property
vdp.jmx.password
to the encrypted password you obtained in step 1.Set the value of the property
vdp.jmx.password.encrypted
totrue
.
vdpqueries.jdbcagent.enable
andvdploadcacheprocesses.jdbcagent.enable
. Iftrue
, the information generated by the queries monitor and/or the cache monitor will be stored in a database.To use this feature, uncomment and configure the other
jdbcagent
properties.Before launching the Denodo Monitor with this option enabled, you have to do this:
Create the tables in the database that will store the information generated by the cache monitor and the queries monitor. Denodo Monitor does not create the tables, just inserts data in them.
The directory
<DENODO_HOME>/tools/monitor/denodo-monitor/sql/
contains SQL scripts to create these tables, for several vendors (MySQL, Oracle, SQL Server, etc.). If there is no script for the database you want to use, you can use one of them as a template. Denodo Monitor only executes simple INSERT statements so you should be able to use any database.Copy the JDBC driver of the database (the jar files) to the folder
<DENODO_MONITOR>/lib
.
vdpqueries.snmptrapagent.enable
andvdploadcacheprocesses.snmptrapagent.enable
. Iftrue
, the monitor sends SNMP traps with the information received by the Queries monitor or the Cache Monitor.To use it, uncomment and configure the other
snmptrapagent
properties.vdp.datasources.ping
. List of comma-separated data sources to which the Denodo Monitor will perform a ping operation. Each data source is specified by a reference like <database_name>.<data_source_type>.<data_source_name>, where data_source_type can only take one of the following values:jdbc
,odbc
,ldap
,olap
,sapbwbapi
,saperp
,salesforce
.Note that the ping is invoked periodically, every time the Virtual DataPort Data Sources Monitor registers information in the logs, which is controlled by the parameter
vdp.datasources.interval
.