You create an event database by adding it to an existing database server. You can then use reporting software to analyze the events in the database.

Deploy the database server for the event database on a dedicated server, so that event logging activity does not affect provisioning and other activities that are critical for Horizon 7 deployments.
Note: You do not need to create an ODBC data source for this database.

Prerequisites

  • Verify that you have a supported Microsoft SQL Server or Oracle database server on a system that a Connection Server instance has access to.

    For the most up-to-date information about supported databases, see the VMware Product Interoperability Matrixes at http://www.vmware.com/resources/compatibility/sim/interop_matrix.php. For Solution/Database Interoperability, after you select the product and version, for the Add Database step, to see a list of all supported databases, select Any and click Add.

  • Verify that you have the required database privileges to create a database and user on the database server.
  • If you are not familiar with the procedure to create databases on Microsoft SQL Server database servers, see "Add a View Composer Database to the SQL Server," in the Horizon 7 Installation document.
  • If you are not familiar with the procedure to create databases on Oracle database servers, see "Add a View Composer Database to Oracle 12c or 11g," in the Horizon 7 Installation document.

Procedure

  1. Add a database to the server and give it a descriptive name such as HorizonEvents.
    For an Oracle 12c or Oracle 11g database, also provide an Oracle System Identifier (SID), which you use when you configure the event database in Horizon Console.
  2. Add a user for this database that has permission to create tables, views, and, Oracle triggers and sequences, and permission to read from and write to these objects.
    For a Microsoft SQL Server database, do not use the Integrated Windows Authentication security model method of authentication. Verify that you use the SQL Server Authentication method of authentication.

Results

The database is created, but the schema is not installed until you configure the database in Horizon Console.

What to do next

Follow the instructions in Configure the Event Database in Horizon Console.