Applications: Configuring External Databases

The following sections provide information on configuring external databases.

The Software Appliance supports the usage of external databases. By default, the Internal Database is configured.

1. Log in to your Software Appliance and open the Applications page.
   
   

In the EJBCA Software Appliance, only the Internal Database can be used with the built-in clustering.

Supported external database types for EJBCA are:

• Applications: Configuring a MariaDB Database
• Applications: Configuring an Oracle Database
• Applications: Configuring a PostgreSQL Database
• Applications: Configuring a Microsoft SQL Server

In case the database user does not have sufficient permission to create database schemas, the following link refers to the SQL script used to create the required database tables.
 
All scripts have the name of the DBMS they are intended for in their filename.

• There are scripts for table creation called "create-tables-ejbca-<dbms-name>.sql."
• and one general file that is used to create the required DB indices called "create-index-ejbca.sql."

Please refer to: EJBCA-SQL-Scripts

Configuring an external database on the Applications page will store all application data on that specific external database server.