Native support for Oracle in Reliance SCADA

February 26, 2018

Beginning with version 4.8.0, native support for the Oracle database management system is part of the Reliance SCADA/HMI system. This support is based on the ODBC standard.

How to connect Reliance to Oracle

Installation

Download and install Oracle Database Express Edition 11g Release 2.
Download and install the Oracle SQL Developer 17.4 development environment.
Download and install ODBC Driver for Oracle.

Oracle database configuration

Start configuring the database using the shortcut (see the image below):
On the initial page, click Application Express:
Log in to the database. The system user password was defined when the Oracle database was being installed:
Create a new workspace. The user RELI_ORACLE is an administrator. The workspace is created after clicking Create Workspace:
Log in to the workspace. Click on click here and then Login:

ODBC driver configuration

Run the ODBC Data Source Administrator (32-bit). Switch to the System DSN page and click Add:
Select Devart ODBC Driver for Oracle and click Finish:
In the Devart ODBC Driver for Oracle Configuration dialog, set up the connection parameters:

Defining an SQL connection in a Reliance project

Open your project in the Reliance Design development environment.
Go to the Project Options dialog box (Project > Options > SQL) and add a new connection.
Click on the Edit Connection String button to open the Data Link Properties dialog.
On the Provider page, select Microsoft OLE DB Provider for ODBC Drivers:
On the Connection page, specify the data source (RELIANCE_ORACLE) and enter your credentials. Click on the Test Connection button to verify the connection:
Set the SQL connection's ODBC driver property to Oracle Devart: