Learn how to connect Ignition to the Oracle Express database from the Config section in the Gateway.

Video recorded using: Ignition 7.9


(open in window)

[00:00] In this lesson, we're going to take a look at how we can connect to an Oracle XE Database. As we're setting up other database connections. We are on the Connections page, under Database, in the Configure section of our Gateway webpage. To create a new database connection. We need to click on the Create New Database Connection link. We then have a choice of what type of database we want to connect to. Now you'll notice if we select the Oracle Database option and hit the Next button down below, we actually get an error letting us know that the driver is missing files. Ignition doesn't currently come with the Oracle JDBC driver. So we need to install that for this database connection to work. To install the Oracle JDBC driver, we need to go to the drivers page under Databases here.

[01:04] We can see our list of installed JDBC drivers, and you will notice that the Oracle Database option is erred, letting us know that it's missing some files. We simply need to edit this Oracle Database option and find the JAR files property, where we can choose the JAR file for our JDBC driver. I've already downloaded the Oracle JDBC JAR file here. So I'll go ahead and select that. Once we've selected that JAR file, we can scroll down and hit Save Changes. Now that we've installed the JDBC driver, I can go back to the Connections page and create my new database connection. I'll select Oracle Database again and hit next. And this time we are taken to the Configuration screen. The first thing that we need to set is the connect to URL property. The database is installed locally, just like Ignition.

[02:05] So I can leave the host as localhost. The port that my database is using is 1521 which is the default port. So I can leave that alone as well. We are connecting to an Oracle Express Database. And so the SID that I need to use here is actually just XE. Once I have that set, I can then type in my username and password. I'm going to connect to the database using the System User. And I'll type in the password for that user. Once I've entered in this information, that's all I really need to do. And I can scroll down to the bottom of the page and hit the Create New Database Connection button. You will see that we now have our new database connection with a status of Valid, indicating that we've successfully connected to the database.

[02:59] If you ever have any trouble connecting to the database, don't forget that you can always click on this link here, Database Connection Status, which will take you to the Status Page. Which should give you information about why your connection is erred.

You are editing this transcript.

Make any corrections to improve this transcript. We'll review any changes before posting them.