AVEVA BI Gateway

AVEVA BI Gateway is an enterprise manufacturing intelligence solution that automates the extraction, transformation, and storage of operational KPIs, metrics, and related contexts.

Connect multiple plant and enterprise data sources to reveal how different industrial operations influence each other.

People, processes, and devices: large amounts of time series and transactional plant data are generated every day, but without operational and commercial context, the value of this data is limited.

The key to remaining competitive is to unlock this industrial data and quickly transform it into relevant business information that is available throughout the organization. AVEVA BI Gateway software synthesizes data from across the plant and reveals connections that would otherwise be invisible. It turns Big Data into manageable portions so that industrial teams can track performance based on the most important metrics, all in time to make a difference.

AVEVA BI Gateway Architecture

AVEVA BI Gateway consists of the following key components: the server, the model configurator, and the data warehouse.

AVEVA BI Gateway Server

The BI Gateway server provides the core services that manage the acquisition, aggregation, and persistence of operational metrics in connected data sources 24 hours a day, 7 days a week.

The software uniquely manages the contextualization of information across multiple sources with time-stamped and relational data, and stores the extracted information in a data warehouse optimized for retrieval.
Data sources include AVEVA applications (AVEVA MES, Batch Management, Historian, etc.); business data, third-party sources, and other plant systems.

Model Configurator

The AVEVA BI Gateway model configurator consists of three components:

• Data sources, which define access to the source system, including type, location, and authentication.
• Measures, defining the metric calculations to be performed.
• Dimensions, which define the context added to the measures, such as batch ID, shifts, reason codes, etc.

After the implementation of the BI model, the software populates a data warehouse by extracting historical data from connected data sources and keeps it up to date by refreshing the information periodically or based on external event triggers.

Historical data is loaded in reverse chronological order so that users can start analyzing the most recent history instantly, while the system creates the complete history for the specified time period and resolution.

Data Warehouse

All metrics and context information are maintained and persisted in an open information model (Microsoft SQL Server database). It provides a single version that people, data warehouses, and enterprise business intelligence tools need to strategically make sense of industrial or production data.

The database is optimized for retrieval and provides open and flexible access with preferred visualization clients such as Tableau, Power BI, Alpana, Qlik, SAP Business Objects, just to name a few.

AVEVA BI Gateway Functionality in the Cloud

AVEVA BI Gateway is also available in a cloud version along with the AVEVA Insight solution. AVEVA Insight is a cloud-based software-as-a-service (SaaS) solution that drives operational continuity and improves performance.

Best of all, it is easy to set up, manage, and use, with no IT infrastructure or additional staff. AVEVA Insight allows you to quickly turn data found in the plant into a real-time information source to support decision-making.

Adding BI Gateway to AVEVA Insight allows companies to:

• Better understand the business: know what is happening, what has happened, and what is likely to happen with immediate access to relevant data.
• Unlock operational data from the control room and make it accessible when and where personnel need it.
• Empower people to become active participants in real-time workflows and improve collaboration between teams.
• Close the IT/OT gap and share critical process information with business and finance teams.
• Expose hidden opportunities to reduce operating costs, increase asset performance, and drive better production results.

Native data adapters allow you to enjoy the analysis capabilities of AVEVA BI Gateway with Historian, Microsoft SQL Server, Oracle, PI System, or text file databases. In addition, it has a user-friendly web interface to create BI models, saving the data in dimensionally structured SQL databases that allow queries to be performed very efficiently.