Skip to main content

Documentation Portal

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.

Connector on a dedicated Windows server

To set up a new connection to an IP21 historian:

  1. Install the Aspen SQLplus ODBC drivers on the connector server.

  2. 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.

  3. 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.

  4. Follow the instructions on How to connect to time series data sources?

Connector on the historian server

  1. Verify the Aspen SQLplus ODBC drivers are installed. This should be the case when you install the TrendMiner connector on the historian server.

  2. 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, ...)

  3. 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.

  4. 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.

In this section: