Store telemetry data in IBM DB2, an enterprise-class relational database. Outbound targets write to the ProxusDeviceData table.
open_in_new
Official Documentation
ibm.com
Configuration Parameters
| Parameter | Required | Type | Description |
|---|---|---|---|
| Server | Yes | string | DB2 hostname or IP. |
| User | Yes | string | DB2 user. |
| Password | Yes | string | DB2 password. |
| Database | Yes | string | Database name. |
| Port | No | int | DB2 port (if required). |
Example Configuration
Server=192.168.1.100
Port=50000
Database=PROXUS
User=db2admin
Password=*****Data Schema
CREATE TABLE ProxusDeviceData (
OID BIGINT NOT NULL GENERATED ALWAYS AS IDENTITY PRIMARY KEY,
DEVICE_ID INT NOT NULL,
DEVICE_NAME VARCHAR(255),
"KEY" VARCHAR(255) NOT NULL,
"VALUE" CLOB NOT NULL,
DATA_TYPE VARCHAR(64) NOT NULL,
TIME TIMESTAMP NOT NULL
);
CREATE INDEX IDX_DEVICE_TIME ON ProxusDeviceData(DEVICE_ID, TIME);Requirements
- IBM Data Server Driver installed
- DB2 client connectivity configured