How to connect to Aspentech IP21?
Caution
The Aspen SQLplus driver is sensitive to network latency. TrendMiner strongly advises to install the TrendMiner connector on the IP21 server or at least on the same network to minimize the latency introduced by the roundtrips between the TrendMiner connector and the IP21 historian.
Additional hops or firewalls between the connector and the historian can result in malfunctioning or underperforming data visualisation in TrendMiner.
Notice
TrendMiner only supports syncing tags from records that have the IP_ARCHIVING == “ON“.
Since SQLA tags do not have set up IP_ARCHIVING this implies that TrendMiner does not support syncing IP21 SQLA tags via its IP21 provider. In case you want to sync SQLA tags from an IP21 historian TrendMiner advises to use the generic ODBC provider to connect to your IP21 historian.
Connector on a dedicated Windows server
To set up a new connection to an IP21 historian:
Install the Aspen SQLplus ODBC drivers on the connector server.
By default port 10014 between the connector and the historian needs to be open. A different port can be configured for connecting from the connector to the historian by entering <hostname>:<port> or <ip>:<port> in the host input field of the datasource.
Create one user/service account with read permissions to read data from IP21 server.
Important
In AspenOne 8 or higher, SQLplus is installed as part of the client tools. For versions lower than v10 the IIS application pool may need to run as the user account that has read-only permissions. For version v10 it is required that IIS application pool runs as the user account that has read-only permissions. The SQLplus ODBC driver no longer supports connecting as a different user in this version.
Follow the instructions on How to connect to time series data sources?
Connector on the historian server
Verify the Aspen SQLplus ODBC drivers are installed. This should be the case when you install the TrendMiner connector on the historian server.
Make sure a chosen port is open that allows communication from the Linux TrendMiner machine to the historian server (this port gets chosen during the IIS site deployment process and is usually 80, 8080, 8081, ...)
Create one user/service account with read permissions to read data from IP21 server.
Important
In AspenOne 8 or higher, SQLplus is installed as part of the client tools. For versions lower than v10 the IIS application pool may need to run as the user account that has read-only permissions. For version v10 it is required that IIS application pool runs as the user account that has read-only permissions. The SQLplus ODBC driver no longer supports connecting as a different user in this version.
Follow the instructions on How to connect to time series data sources?
Note that in this case the instructions for installing the TrendMiner connector need to be applied to the historian server.