Database integration

The Database integration component enables an external database to provide data into an AVEVA™ Production Management reporting point. Microsoft SQL Server is the supported database type.

The Database connector is most commonly used to:

• Insert records into AVEVA Production Management from an external database.

• Update existing records in AVEVA Production Management based upon updates in an external database.

A common case for this is to bring in data results from a laboratory information management system (LIMS). The results from a LIMS can come days or weeks after the original sample was taken, and the results can be updated based upon further tests.

Integration design

Create and implement the following into the integration design:

• Check that a record in the external database was processed by this integration, including the frequency to check.

• Common practices include an IsProcessed column that is later updated.

  Select * from Example1 where IsProcessed = 0

• An alternative practice is to have a table that holds the last time the integration was executed.

  Select * from Example1 where LastUpdated > last executed

Related topics

• Database integration workflow diagram

• Add and configure a Database integration

• Integration Diagnostics web server

• Plant2Business