Show TOC

Object documentationOpen Connector Locate this document in the navigation structure

 

The Open connector browses historical data in a relational database.

You can create tag queries in the SAP Manufacturing Integration and Intelligence (SAP MII) Workbench by browsing tag names and descriptions and using time periods instead of writing SQL queries.

 

The Open Connector can support the following connector modes:

  • ModeList

  • TagList

  • GroupList

  • Current

  • History

  • HistoryEvent

  • Statistics

Structure

The required server parameters are based on the mode of your server instance. The Open Connector is a special IDBC.

You can use tokens, or variables, in your query string. The system replaces the tokens with values at runtime based on the query parameters. The tokens are listed below:

  • [TagName]

    Replaced with tag names at runtime

  • [Mask]

    Replaced with the specified mask at runtime. Allows you to use wildcard characters to perform LIKE clauses in the query filter expressions.

  • [Group]

    Replaced with the specified group at runtime. Represents a logical category that you can use to link individual tags.