Add a Database and Database User for Omnissa Horizon 8 Events in Omnissa Horizon Console

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 8 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, Oracle, or PostgreSQL database server on a system that an Omnissa Horizon Connection Server instance has access to.

  For the most up-to-date information about supported databases, see the Product Interoperability Matrixes at https://interopmatrix.omnissa.com/Interoperability. 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.

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 with the required permissions.
   
   Instead of using a highly privileged account such as sa, create a dedicated database user with the minimum required permissions on the Horizon Events database.
   The user must have permissions to:
   
   - Create tables and views
   - (Oracle) Create triggers and sequences
   - Read and write data (SELECT, INSERT, UPDATE, DELETE)
   
   

   For Microsoft SQL Server, you can assign the following:

   • Database role: db_owner (recommended for initial setup), or

   • Equivalent permissions that allow schema creation and data manipulation

     Note:

   • Do not grant unnecessary permissions on system databases such as master

   • Follow the principle of least privilege when assigning permissions
     

   For a Microsoft SQL Server database, Horizon 8 does not support the Integrated Windows Authentication security model method of authentication. Use the SQL Server Authentication method of authentication, which is the only supported method.

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.