Store telemetry data in Microsoft SQL Server, an enterprise-grade relational database. Outbound targets write to the ProxusDeviceData table.
open_in_new
Official Documentation
learn.microsoft.com
Configuration Parameters
| Parameter | Required | Type | Description |
|---|---|---|---|
| Server | Yes | string | SQL Server hostname or IP (optionally with port: server,1433). |
| User | Yes | string | SQL Server login. |
| Password | Yes | string | Login password. |
| Database | Yes | string | Database name. |
| TrustServerCertificate | No | bool | Skip certificate validation. |
| Encrypt | No | bool | Enable/disable TLS encryption. |
Example Configurations
SQL Authentication
Server=192.168.1.100,1433
Database=proxus
User=proxus
Password=*****
TrustServerCertificate=trueWindows Authentication
Server=192.168.1.100
Database=proxus
User=proxus
Password=*****Data Schema
CREATE TABLE ProxusDeviceData (
Oid INT IDENTITY(1,1) PRIMARY KEY,
DeviceId INT NOT NULL,
DeviceName NVARCHAR(255),
[Key] NVARCHAR(255) NOT NULL,
[Value] NVARCHAR(MAX) NOT NULL,
DataType NVARCHAR(64) NOT NULL,
[Time] DATETIME2(7) NOT NULL
);
CREATE INDEX idx_device_time ON ProxusDeviceData(DeviceId, [Time]);Performance Tips
- Use SQL Server 2016+ for temporal tables support
- Enable BULK INSERT for high-throughput scenarios
- Consider columnstore indexes for analytical queries