Connecting to Oracle Express

Connecting to Oracle Express

Watch the video

Overview

This page details how to configure a connection to an Oracle database. Note that in some cases you may need to update your JDBC driver, so it is a good idea to consult the table of supported databases.

To Connect Ignition to the Oracle Express Database

1. From the Gateway, go to the Configure section.
2. From the menu on the left, select Databases > Connections.
   The Database Connections page will be displayed.
3. Look for the blue arrow, click on Create new Database Connection....

4. Select the Oracle JDBC Driver and click Next.

5. Enter the following information:
   Name: Oracle
   Connect URL: jdbc:oracle:thin:@localhost:1521:XE (XE is the System ID in Oracle)
   username: SYSTEM
   password: oracle (password is what you entered in during the Oracle server installation, in this example, the password is oracle)

6. Click Create New Database Connection at the bottom of the form.
   The Database Connections page is displayed showing the Status of your connection as Valid.

7. 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.