Connecting to Oracle Express

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

  3. Look for the orange arrow, click on Create new Database Connection....

    images/download/attachments/6033911/image2015-3-2_8_47_19.png

  4. Select the Oracle JDBC Driver and click Next.

    images/download/attachments/6033911/image2015-3-2_8_47_54.png

  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)

    images/download/attachments/6033911/image2015-3-2_8_48_40.png

  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.

    images/download/attachments/6033911/image2015-3-2_8_49_5.png

  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.

    images/download/attachments/6033911/image2015-3-2_8_49_38.png