Store telemetry data in Oracle Database, an enterprise-class relational database. Outbound targets write to the ProxusDeviceData table.
open_in_new
Official Documentation
docs.oracle.com
Configuration Parameters
| Parameter | Required | Type | Description |
|---|---|---|---|
| Server | Yes | string | Oracle data source (TNS name or Easy Connect string). |
| User | Yes | string | Oracle user. |
| Password | Yes | string | Oracle password. |
Example Configurations
Easy Connect
Server=//192.168.1.100:1521/ORCL
User=proxus
Password=*****TNS Name
Server=PROD_DB
User=proxus
Password=*****Data Schema
CREATE TABLE ProxusDeviceData (
Oid NUMBER GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY,
DeviceId NUMBER NOT NULL,
DeviceName VARCHAR2(255),
"KEY" VARCHAR2(255) NOT NULL,
"VALUE" CLOB NOT NULL,
DataType VARCHAR2(64) NOT NULL,
"TIME" TIMESTAMP WITH TIME ZONE NOT NULL
);
CREATE INDEX idx_device_time ON ProxusDeviceData(DeviceId, "TIME");Requirements
- Oracle Client installed on the Gateway
- Or use Oracle Managed Data Access (ODP.NET Core)