System architecture

The following diagram shows a typical architecture of a PI Integrator for Business Analytics system.

PI Integrator for Business Analytics System Architecture

The following describes the components that are required for the data warehouse targets. PI Integrator Framework, PI Integrator Worker Nodes, and PI Integrator Sync processes all reside on the same computer.

• PI Integrator Framework

  The PI Integrator Framework performs the following functions:

  • Provides the web application through which views are created, published, and managed.

  • Schedules jobs to be published.

  • Distributes jobs among PI Integrator Worker Nodes to balance the publishing of views amongst the nodes. In this diagram, there is only one worker node.

  • Tracks and manages the output streams used in views.

  • Records view statistics including time to publish the view, number of rows written, number of rows filtered, and error count.

• PI Integrator Sync

  PI Integrator Sync monitors the following data:

  • View shape and data changes of scheduled asset views and scheduled streaming views

  • View shape changes of key-value-triggered streaming views

• PI Integrator Worker Node

  PI Integrator Worker Node publishes jobs to its destination targets. Additional worker nodes can be installed to improve performance.

• PI Asset Framework (PI AF)

  PI Integrator for Business Analytics retrieves and updates view definitions stored in the PI AF configuration database.

• SQL Server

  Metadata tables, logs, and statistics are stored in SQL Server.