Show TOC

Object documentationIP21 and IP21OLEDB Connectors Locate this document in the navigation structure

 

The IP21 Connectors connect SAP Manufacturing Integration and Intelligence (SAP MII) to AspenTech InfoPlus.21® (IP21) data sources.

 

You must install the IP21 ODBC driver and EasySoft JDBC/ODBC bridge before you configure the IP21 connector. When you configure the server, make sure the connection URL and ODBC client configuration use the same data source name. You can also use SQL Plus with the connector. You can use the IDBC connector to link to IP21, which allows you to issue any query that can be constructed in SQL Plus.

The IP2OLEDB connector uses the OLE DB UDC connection instead of a JDBC connection. For more information, see Universal Data Connector.

Structure

The IP21 and IP21OLEDB connectors support Current, HistoryEvent, History, and Statistics modes. You can also browse the IP21 namespace. The connectors can provide the following historical data retrieval:

  • History

    Provides interpolated data retrieval.

  • HistoryEvent

    Provides raw data values with time stamps from IP21.

    If you there is no Method parameter value, the system uses the HistoryEvent parameter values to determine the tables and columns for the query. If the Method parameter value is Compressed, the system uses the CompressedHistoryEvent parameter values to determine the tables and columns for the query.

When you use the EasySoft JDBC/ODBC bridge, the format for the JDBCDriver parameter is easysoft.sql.jobDriver, and the format for the URL parameter is jdbc:easysoft://SERVER:8831/DSN, where SERVER is the name of the machine running the EasySoft NT service and DSN is the system data source name. If the bridge is running on the same machine as the Web server, you can use localhost as the SERVER name.

Note Note

In the advanced settings of the ODBC administrator, deselect all indicators except the read-only indicator.

End of the note.