Skip to main content

Documentation Portal

TrendMiner connectivity
Time series connectivity

TrendMiner supports the following options to get your time series data available in TrendMiner:

Table 3. Supported time series connectivity

Type / vendor / historian / IoT platform

Supported versions

TrendMiner connector required

Aveva PI

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

Yes

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

Yes

AspenTech IP21

v7, v8, v10, v11

Yes

GE Proficy

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

Yes

Yokogawa Exaquantum

2.85, 3.02, 3.10, 3.15

Yes

Honeywell PHD

R3.30, R4.00, R4.10

Yes

Aveva Wonderware

2014 R2 SP1 P02, 2017, 2020, 2023

Yes

ODBC (deprecated)

Generic ODBC

Yes

OleDB

Yes

SQLite

Yes

Cumulocity

ODBC connection to DataHub

Yes

Microsoft Azure Data Explorer (Kusto ADX)

No

AWS IoT SiteWise

No

Amazon Timestream

No

Generic JDBC

postgres (42.5.5)

mariadb (3.3.2)

sqlite (3.45.3.0)

mssql (12.6.3.jre11)

(Additional drivers can be installed)

No

CSV import

No

Write your own connector using the TrendMiner connector API

No



Context connectivity

TrendMiner supports the following options to get your context data available in TrendMiner:

Table 4. Supported context connectivity

Type / vendor / historian / IoT platform

Supported versions

TrendMiner connector required

Aveva PI 

PI AF SDK 2017 R2 SP1 or higher

Yes

AspenTech APRM (Aspen Production Record Manager) 

12.2, 14

Yes

AWS IoT SiteWise 

No

JDBC (Context SQL Sync) (deprecated)

Generic JDBC 

postgres, mariadb, sqlite, mssql

(Additional drivers can be installed)

No

Generic ODBC 

Yes

CSV import 

No

Shiftconnector 

7.15 to 7.19

No



Asset connectivity

TrendMiner supports the following options to get your asset data available in TrendMiner:

Table 5. Supported asset connectivity

Type / vendor / historian / IoT platform

Supported versions

TrendMiner connector required

Aveva PI 

PI AF SDK 2017 R2 SP1 or higher

Yes

AspenTech APRM (Aspen Production Record Manager) 

12.2, 14

Yes

AWS IoT SiteWise 

No

Generic JDBC 

postgres, mariadb, sqlite, mssql

(Additional drivers can be installed)

No

Generic ODBC 

Yes

Shiftconnector 

7.15 to 7.19

No

CSV import 

No

Set up an Asset Framework directly via the Digital Twin Manager 

No