You can help by commenting or suggesting your edit directly into the transcript. We'll review any changes before posting them. All comments are completely anonymous. For any comments that need a reply, consider emailing training@inductiveautomation.com.
Version:
LESSON LIST
-
6:39Connecting to MySQL
-
6:33Connecting to Microsoft SQL Server Express
-
5:11Creating a SQLite Connection
Take Topic Challenge
Supplemental Videos
LESSON
Connecting to Oracle Express
Description
Learn how to connect Ignition to the Oracle Express database from the Config section in the Gateway.
Video recorded using: Ignition 8.1
Resources
Transcript
(open in window)[00:00] In this lesson, we're going to take a look at how we can connect to an Oracle Express database. I'm here on the connections page, located in the databases section of the config tab. To create a new database connection, I'll click on the create new database connection link. We then have a choice of what type of database we want to connect to. You'll notice if we select the Oracle database option and hit next an error appears letting us know that the driver is missing files. Ignition doesn't currently come with the Oracle JDBC driver. We need to install that for this database connection to work. To install the driver, we need to go to the driver's page under databases. Here we can see our list of installed JDBC drivers, and you'll notice that the Oracle database option is errored, 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.
[01:10] I've already downloaded the JAR file here, so I'll go ahead and select that below this video. I have included a link to Oracle's website where you can gather the JAR file. Once we've selected that JAR file, we can scroll down and hit save changes. Now that our JDBC driver is installed, I can go back to my connections page and create my new database connection. I'll select Oracle database again and hit next here on the configuration screen. The first thing that we need to set is the connect to URL property. My database is installed locally, so I can leave the host as local host and it's using the Port 1 5 2 1, which is the default port, so I can leave that alone as well. Since we are connecting to an Oracle Express database, the SID or system ID that I need to use here is XE. Once I have that set, I can then type in my username and password.
[02:08] 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 this information, that's all I really need to do. 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 the status of valid indicating that we've successfully connected to the database. 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. This should give you information about why your connection is errored.