Interface​.Info

On the Edit Interface Information dialog, you can edit information related to interfaces with external systems. For instance, this is where you would find the details about how AVEVA Production Accounting connects to the plant historian.

Open the Edit Interface Information dialog

• From the Tools menu, select Interface.Info.

  

Typical interfaces

A typical scenario might involve several interfaces similar to those shown below. The interfaces shown in red are the ones which require definitions in the table shown in the Edit Interface Information dialog box.

• Plant historian

• Movement tracking system

• Lab data

• ERP

The APA DB interface is defined on the Interface Source tab of the Option dialog box.

An administrator can define the various interfaces with the interface sources defined on the Interface Source table of the Option dialog box.

Edit Interface Information dialog

The Edit Interface Information dialog is shown in the figure below.

To perform additional actions on the Edit Interface Information window, right-click anywhere in the No column.

Multiple interfaces can have the same interface name.

Add a new interface

You can add a new interface by clicking on the New context menu item, available by right-clicking on the "No." column of the grid.

The example shows creating a new interface to connect to an Oracle database. If the interface source for the interface is an RDB type (Oracle, SQL Server, MS Access), as it is in this case, or a File type (Excel, comma separated values, text), you must next Build a SQL query by clicking the button next to the Query SQL field.

To add a new interface with pre-defined interface source

IP21 dynamic query

The IP21 interface can be configured to support the dynamic query using the following keywords in SQL Query Editor:

• @gName

• @StartDateTime

• @EndDateTime

The following procedure describes how to configure and access the IP21 interface:

1. In the Edit Interface Information dialog, select interface configuration (...).

   

   The SQL Query Editor dialog appears.

2. In the SQL Query Editor, enter the relevant query details:

   • Name

   • StartDateTime

   • EndDateTime

3. Enter a query for the IP21 interface with the relevant keywords.

   

4. Select OK.

   The IP21 interface is configured.