Skip to main content

Check out Interactive Visual Stories to gain hands-on experience with the SSE product features. Click here.

Skyhigh Security

Edit Database page (Database page)

Edit Database page (Database page)

Access and manage the database configuration options used to process log data.

If you choose to use an internal database, the database requires no additional configuration.

Option definitions

Option Definition

Displays the Advanced Database Status dialog box to view more information about the currently
connected database.

NOTE: This option appears on the Edit Database dialog box and is only available to select
when the database is connected.


Choose between Default internal database or This external database to activate a database.

NOTE: If the {{csr}} and {{corpr}} {{epotm}} databases share the same SQL
Server instance, you must configure separate databases for each

If you choose to use an external database, the Database settings value box becomes active to
enter setting information such as the address, port, and logon details. A checkbox to enable SSL
connection to the database is also available.

Connection Mode

Displays whether the database connection is online or offline.

When you set the database to offline, the Advanced button is no longer available.

Execute SQL

SQL Opens a window that enables a reporting administrator to provide and execute SQL statements. Use
this function for troubleshooting when working with technical support.

Enter the username and password before using the Execute SQL option.

Refresh Updates the availability status of the connected database.
Status Displays whether the database is connected or disconnected.
Test Verifies the database configuration settings.
Update Schema Upgrades the database schema.


Advanced Database Status Dialog Box

Option Definition
Partition Schema

Provides the option to partition your schema.

NOTE: If you are not sure what partitioning is, or if you need it, do not partition your schema.


Displays this database status information:

  • Availability — Displays whether the database is connected or offline.
  • Schema version — Displays the connected report database schema version.
  • Partitioning — Displays if partitioning is supported for:
    • Microsoft SQL Server 2008
    • Microsoft SQL Server 2012
    • Microsoft SQL Server 2014
    • Microsoft SQL Server 2016
    • Microsoft SQL Server 2017
    • Microsoft SQL Server 2019

NOTE: From Microsoft SQL Server 2016 (13.x) SP1 and above Table and index partitioning is
supported across all edition and below this version, it is only supported in enterprise edition.

  • MySQL 5.5
  • MYSQL 5.6
  • MYSQL 5.7

Permissions — Displays the SQL permissions for the user specified in the Logon name field on the
Database page.


Test Status dialog box

Option Definition
Status Identifies the connection status to the report database.
Details Provides the details for the connected database.


  • Was this article helpful?