This documentation supports the 20.02 version of Remedy with Smart IT.

To view an earlier version, select the version from the Product version menu.

Creating the database

Remedy with Smart IT (Smart IT) installer will create the database automatically. However, if you have database access restrictions and cannot allow the Smart IT installer to create a database, you can create a pre-existing database.

When you create a database, you create database users and assign required roles to them. 

Before you begin

This topic is part of Preparing for installation of Smart IT. Complete the previous steps, described in the following topics:

Required database schemas

Smart IT requires the following database schemas:

schemaName_businessStores business data
  • Certificates
  • Configuration
  • Customizations
  • Images
schemaName_systemStores system data
  • Provider Info
  • Tenant
  • Plugin
openfire(Required only if you are using chat in Smart IT) Stores chat data

Best practice

You can replace schemaName with SmartIT or any other identifier that you prefer. We recommend that you keep "_business" and "_system" as part of these schema names so that you can easily identify the data in the tables. You can specify these schemas during installation.

Databases you can create

Depending on the database you are using, follow the instructions in the corresponding topic:

Where to go from here

Requirements for a non-root user to run the installer

Was this page helpful? Yes No Submitting... Thank you