---
title: "Connecting to Oracle Express"
description: "This page documents how to configure a database connection to an Oracle Express instance. "
---

# Connecting to Oracle Express

> This page documents how to configure a database connection to an Oracle Express instance. 

## Oracle User Grants

When using an Oracle Express database connection, it is required to provide user credentials that have grants for "CREATE TRIGGER" and "CREATE SEQUENCE". Some of Ignition's subsystems, such as the [Tag Historian](ignition-modules\tag-historian\tag-historian.md) and [Audit Log and Profiles](platform/audit-log-and-profiles/audit-log-and-profiles.md), will fail to work properly if the user defined in the database connection does not have these grants. In addition, any manual queries (for example, those called by [system.db.runNamedQuery](appendix\scripting-functions\system-db\system-db-runNamedQuery.md)) that need to insert records or create sequences may fail if the gateway does not have the grants. 

## Connect Ignition to the Oracle Express Database 

1. On the Gateway Webpage, go to the **Config** section.

2. Scroll down to **Databases > Connections**.

    ![" "](oracle-Databases-Connections.png)
  
3. The Database Connections page is displayed. Click on **Create new Database Connection....**

    ![" "](oracle-create-new-database-connection.png)

4. Select the **Oracle JDBC Driver** and click **Next**.

    ![" "](oracle-driver.png)

5. Enter the following information:

    - **Name**: The name of the database connection. Other features in Ignition will reference this connection by the name specified here.
    
    - **Connect URL**: A URL that describes where on the network the database is, as well as information about which schema to connect to. The initial value should look something like the following: `jdbc:oracle:thin:@localhost:1521:XE`
    However, you may need to make some changes. If we examine the key pieces of the URL, it would look like this: `jdbc:oracle:thin://1:2:3`
    Where:
      * 1 = The IP Address or hostname of the computer/sever that the database is installed on.
      * 2 = The port that the database is running on. The default is 1521, but this could have been changed during installation, or sometime afterwards. When in doubt, ask the person that installed the database.
      * 3 = The System ID for the database. More information on the System ID can be found in Oracle's documentation.

    - **Username**:	The username that the Gateway will use to connect to the database.
    
    - **Password**:	The password for the user specified under the Username property.

    For our example, we entered information relevant to our installation. The values seen below may differ from each installation. 

    ![" "](oracle-main-props.png)

6. Click **Create New Database Connection** at the bottom of the form.

7. The Database Connections page is displayed showing the **Status** of your connection as **Valid**.

    ![" "](oracle-connection-created.png)

8. To display the details about the status of your database connection, see the **Note** on the above window and click on the **Database Connection** Status link.

![" "](oracle-connection-status.png)

## JDBC Drivers and Translators

In some cases, you may need to add your own JDBC Driver, or configure a Translator. More information on configuring these can be found on the [JDBC Drivers and Translators](platform\database-connections\connecting-to-databases\jdbc-drivers-and-translators\jdbc-drivers-and-translators.md) page.