5.0

4 Define the output database.
The exportToCsv setting determines whether to use a database or CSV file for the output database. If
exportToCsv is set to true, the Repository Adapter uses the CSV file definition. If exportToCsv is set to
false, the Repository Adapter uses the destdb properties, which define a database. Define only one output
destination.
Option Action
Send output to a database
n
Set exportToCsv to false.
n
If the output database uses SQL Server, set the database driver name,
URL, database name, and the user name and pasword to connect to the
database.
n
If the output database uses Oracle, set the database driver name. Do not
include a database name.
Send output to a CSV file
n
Set exportToCsv to true.
n
Define the path to the CSV file. If the CSV does not exist, the Repository
Adapter creates it.
n
Define the delimiter to use between fields in the CSV file. The delimiter
is usually a comma.
The following example is a definition for an SQL Server output database.
#destination DB
destdbDriver=com.microsoft.sqlserver.jdbc.SQLServerDriver
destdbUrl=jdbc\Lsqlserver\://192.168.1.120\:1433
destdbName=sa
destdbuserName=testDestDB
destdbPassword=111
The following example is a definition for an Oracle output database.
#destination DB properties for Oracle
destdbDriver = oracle.jdbc.driver.OracleDriver
destdbUrl = jdbc:oracle:thin:@ server : port :orcl
The following example is a definition for a CSV output file.
exportToCSV = true
csvFilePath = C:/csv.csv
csvDelimiter = ,
5 Save your changes and close the conf.properties file.
Set the Repository Adapter Schedule
You can configure the Repository Adapter to run at a particular time each day or at specific intervals.
Prerequisites
Become familiar with the conf.properties file. See “conf.properties File,” on page 132.
Procedure
1 Open the conf.properties file in the vcenter-ops \tools\RepositoryAdapter directory.
Chapter 11 Using System Tools
VMware, Inc. 129