1. Home
  2. Installation and Set-up
  3. How To Use Oracle DB for Audit Database

How To Use Oracle DB for Audit Database

In Diplomat MFT Enterprise edition, you can specify an external relational database for auditing. There are two built-in options for external database: MS SQL or MySQL.

You can, however, use any JDBC-compliant database server that you wish, including Oracle Database. This article describes how to configure Diplomat MFT to use an Oracle DB for auditing.

Download the Oracle Thin Driver

You must download the appropriate Oracle JDBC driver for Java 1.8 — we recommend the Oracle JDBC Thin driver.  Put that driver JAR file into “C:\Program Files\Coviant Software\Diplomat-j\tomcatWebserver\webapps\diplomat\WEB-INF\lib,” and restart the service so that Diplomat MFT reads in that driver file.

You can download Oracle JDBC Drivers from Oracle, or locate them in the Maven Repository.

Configure Diplomat MFT Audit Settings

Now you can connect Diplomat MFT’s Audit to the Oracle DB by launching the Diplomat Client. Choose “Settings > Audit…” and choose an “Audit Trail Type” of “SQL”. For the “SQL DB Type,” choose “custom JDBC”. Type in the appropriate values for your Oracle DB server in the “SQL DB Name”, “Username”, “Password”, “Host”, and “Port” fields.

The “Custom Driver” field for Oracle will be: oracle.jdbc.driver.OracleDriver

The “Custom URL” field would look something like this, which uses a TNS name for connection:


When Diplomat MFT parses this string, it replaces <HOST>, <PORT>, and <DBNAME> with the values you supplied in the corresponding fields in the dialog box. You are welcome to supply the actual values, instead of these replacement variables, if you wish.

Alternatively, you can supply a Oracle Thin driver connection URL that looks like this:



Below is a screenshot describing the configuration for Oracle DB using the Oracle JDBC Thin Driver.

Audit Trail Settings Screenshot for Oracle DB

Table Creation

When Diplomat MFT connects to the Oracle database, it will automatically create all necessary tables for auditing, unless you check the box labeled “Do not attempt table creation.” Be sure that the Oracle user account that you are using has permissions to create the tables and indexes required for auditing if you select this option.

If you choose to create the database tables yourself before connecting Diplomat MFT to Oracle DB for auditing, refer to the version-specific Diplomat MFT documentation for information on the table schema.

Updated on April 21, 2022

Was this article helpful?

Related Articles