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 blue arrow, click on Create new Database Connection....

    images/download/attachments/6046076/No_DB_Connections.png

  4. Select the Oracle JDBC Driver and click Next.

    images/download/attachments/6046076/Add_Oracle_JDBC_Driver.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/6046076/New_Oracle_DB_Connection.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/6046076/Oracle_Valid_DB_Connection_Status.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/6046076/DB_Connection_Status_Oracle.png

Similar Topics ...