Customer Database Requirements

Historian/Database Requirements

The Info360 Insight Data Connector supports the following database connections:

Database	Minimum Required Version
MSSQL	2014
Oracle	12.1
MySQL	5.7.21
MariaDB (via MySQL drivers)	10.2.44
Geo SCADA (formerly ClearSCADA)	Tested against: Geo SCADA Expert 2022
OSI PI	Tested against: 2018 SP3 (3.4.445.688)
GE Proficy (formerly iHistorian)	Tested against: 2023 (server version 11.0.6093.0)
Redshift	Tested against: PostgreSQL 8.0.2, Redshift 1.0.163480 (w/ drivers 1.06.01.1000)

Database/Table Requirements:

The schema for the SCADA data table should include columns similar to the following:

Field/Column	ANSI SQL Data Type
sensorID	Varchar (and partial support for References and Integers)
datetime	Datetime
value	Double Precision (or SmallInt, Integer, Float, Decimal, Numeric)

Note: The system architecture expects the SCADA data from all (or at least multiple) sensors to be included within a single table, and that each record/row represents a sample from one sensor ID.