5.8.5

2 Define the output destination method.
You can define only one output destination method.
Option Action
Send output to a database
Set exportToCsv to false.
Send output to a CSV file
Set exportToCsv to true.
3 If you set exportToCsv to false, use the destdb properties to define the connection to the output
database.
The following example is an SQL Server output database definition.
destdbDriver = com.microsoft.sqlserver.jdbc.SQLServerDriver
destdbUrl = jdbc:sqlserver://host:port
destdbName = databasename
destdbuserName = username
destdbPassword = password
The following example is an Oracle output database definition.
destdbDriver = oracle.jdbc.driver.OracleDriver
destdbUrl = jdbc:oracle:thin:@host:port:sid
destdbuserName = username
destdbPassword = password
The following example is a Postgres output database definition.
destdbDriver = org.postgresql.Driver
destdbUrl = jdbc:postgresql://host:port
destdbName = databasename
destdbuserName = username
destdbPassword = password
4 If you set exportToCsv to true, use the csvFilePath and csvDelimiter properties to specify the location
of the CSV file.
For example:
csvFilePath = /path/filename.csv
csvDelimiter = \,
5 Save your changes and close the conf.properties file.
Configuring the Source and Destination Columns for the Repository
Adapter
If you use the Repository adapter to export data to an output database, you must use the insertCommand
statement in the conf.properties file to define where the Repository adapter puts the data that it exports.
The conf.properties file is in the vcenter-ops\tools\RepositoryAdapter\conf directory on the
vCenter Operations Manager server. In a vApp installation, edit the conf.properties file on the Analytics
virtual machine.
insertCommand Format
The insertCommand statement contains two sets of values in parentheses, for example:
insertCommand=INSERT INTO TestTable (column1; column2) values(field1; field2)
Chapter 11 Configuring the Repository Adapter
VMware, Inc. 143