5.7

Repository Adapter Configuration Steps
You must perform certain steps to configure the Repository adapter.
1 (Optional) If you have a vApp installation, create a Postgres database user for the Repository adapter to
use. See “Creating a Database User for the Repository Adapter,” on page 139.
2 Configure the connection to the vCenter Operations Manager relational database . See “Configure the
Source Database Connection for the Repository Adapter,” on page 139.
3 Configure the connection to the output database or CSV file. See “Configure the Output Destination for
the Repository Adapter,” on page 140.
4 (Optional) If you use the Repository adapter to export data to an output database, configure the source
and destination columns. See “Configuring the Source and Destination Columns for the Repository
Adapter,” on page 141.
5 Configure the resources and metrics for which the Repository adapter exports values. See “Configure Data
Export Values for the Repository Adapter,” on page 142.
6 (Optional) Customize Repository adapter operation. See “Customizing Repository Adapter Operation,”
on page 144.
7 Start the Repository adapter. See “Start the Repository Adapter,” on page 144.
Creating a Database User for the Repository Adapter
In a vApp installation, the relational database is the Postgres instance on the Analytics virtual machine. If you
have a Postgres instance, you should create a read-only user for the Repository adapter to use and configure
that user to have access to select tables.
For example:
su postgres
psql -d alivevm
create user repouser with password 'my_password';
grant select on aliveresource to repouser;
grant select on resourceattributekey to repouser;
grant select on attributekey to repouser;
grant select on resourcekind to repouser;
grant select on adapterkind to repouser;
grant select on resourcekindattribute to repouser;
Configure the Source Database Connection for the Repository Adapter
You must configure a connection to the vCenter Operations Manager relational database for the Repository
adapter.
Prerequisites
In a vApp installation, the relational database is the Postgres instance in the Analytics virtual machine. If your
relational database is the Postgres instance, create a read-only user for the Repository adapter to use and
configure the user to have access to select tables. See “Creating a Database User for the Repository
Adapter,” on page 139.
Chapter 11 Configuring the Repository Adapter
VMware, Inc. 139