5.6

n
conf.properties File on page 137
The conf.properties file contains most of the configuration information for the Repository Adapter. It
is located in the
vcenter-ops \tools\RepositoryAdapter directory.
n
Configure Database Connections for the Repository Adapter on page 139
The Repository Adapter requires connections to the vCenter Operations Manager relational database,
the FSDB, and the output database. You configure this information in the conf.properties file.
n
Set the Repository Adapter Schedule on page 140
You can configure the Repository Adapter to run at a particular time each day or at specific intervals.
n
Configure the Source and Destination Columns for the Repository Adapter on page 141
You must configure where the Repository Adapter puts exported data. The insertCommand statement in
the conf.properties file defines the columns in the output database and the source columns in the
vCenter Operations Manager database and FSDB. You can change the names of the columns in the output
database for your environment.
n
Set Operation Options for the Repository Adapter on page 141
You can set options to configure how much data the Repository Adapter retrieves from the database,
how many times the Repository Adapter tries to reconnect to the database, and the interval between
database reconnection attempts.
n
Configure Data Export Values for the Repository Adapter on page 142
You must define the resources and metrics for which the Repository Adapter exports values. Each
statement in the conditions.properties file specifies the name of one of the output columns in the
destination database and one or more values.
n
Start the Repository Adapter on page 143
On a Windows host, you start the Repository Adapter by running a batch (.bat) file. On a Linux host,
you start the Repository Adapter by running a shell script.
conf.properties File
The conf.properties file contains most of the configuration information for the Repository Adapter. It is
located in the vcenter-ops \tools\RepositoryAdapter directory.
Sample conf.properties File
The following example is a sample conf.properties file.
insertCommand=INSERT INTO TestTable (RID1; RNAME1; MID1; MNAME1; RKNAME1; MKNAME1; AKNAME1;
timestamp1; min_threshold1; value1; max_threshold1) values(alive.RID; alive.RNAME;
alive.MID; alive.MNAME; alive.RKNAME; alive.MKNAME; alive.AKNAME; fsdb.timestamp;
fsdb.min_threshold; fsdb.value; fsdb.max_threshold)
# time to run.
scheduleTime=24
#source DB
sourcedbDriver=com.microsoft.sqlserver.jdbc.SQLServerDriver
sourcedbUrl=jdbc\:sqlserver\://192.168.1.130\:1433
sourcedbName=sa
sourcedbUserName=testSourceDB
sourcedbPassword=111
#source FSDB
sourcefsdbDriver=com.integrien.fsdbjdbcdriver.FSDBJDBCDriver
sourcefsdbUrl=rmi\://192.168.1.130\:1199/DBMS
#destination DB
destdbDriver=com.microsoft.sqlserver.jdbc.SQLServerDriver
Chapter 11 Using System Tools
VMware, Inc. 137