Skip to main content

Documentation Portal

Time series connectivity

TrendMiner supports the following timeseries connectivity options, divided into 'plug & play' connectivity providers and providers which require query definition.

Table 4. Supported 'plug & play' time series connectivity

Type / vendor / historian / IoT platform

Supported versions

Deprecated versions

TrendMiner connector required

Aveva PI 

PI OLEDB 2010, 2016+, 2017 R2, 2017 Enterprise

Yes

PI AF SDK 2010 R3+, 2017 R2 SP1, 2018, 2024

Yes

AspenTech IP21 

v7, v8, v10, v11

Yes

GE Proficy 

7.0 SP4, 8.1, 9.1, 2022 (v10), 2023 (v11)

4.5, 5.5

Yes

Yokogawa Exaquantum 

3.10, 3.15, 3.20, 3.30, 3.40, 3.50, 3.60

2.85, 3.02

Yes

Honeywell PHD 

R4.10, R4.30

R3.30, R4.00

Yes

Aveva Wonderware 

2014 R2 SP1 P02, 2017, 2020, 2023

Yes

AWS IoT SiteWise 

No

Canary 

2023

No

CSV import 

No



Table 5. Supported time series connectivity which requires query definition

Type / vendor / historian / IoT platform

Supported versions

TrendMiner connector required

ODBC (deprecated)

Generic ODBC[a]

Yes

OleDB[a]

Yes

SQLite[a]

Yes

Cumulocity[a]

ODBC connection to DataHub

Yes

Microsoft Azure Data Explorer (Kusto ADX) 

No

Amazon Timestream 

No

Generic JDBC[a]

The following JDBC drivers are supported out of the box:

  • PostgreSQL

  • MariaDB

  • SQLite

  • Microsoft SQL Server (MSSQL)

  • Databricks

  • Snowflake

Note: Additional JDBC drivers can be installed.

No

Write your own connector using the TrendMiner connector API

No

[a] Contact TrendMiner support to set up this connection.