Discover Wonderware Intelligence, the Industrial Big Data solution that helps you make real-time decisions (Part 2)

Continuation of the previous post about the Wondeware Intelligence solution:

To develop ETL processes, Wonderware Intelligence provides three object templates that are naturally integrated into the development environment of System Platform, the Integrated Development Studio (IDE), and incorporates a predefined SQL-based database where all contextualized data (called Intelligence) covering the loading process is stored. These object templates are:

• Data Sources (which enable Extract processes): these are interfaces with different data sources (Historian, SQL Server, Oracle, Access, Text (CSV), OSIsoft PI Server…)
• Measures (which enable Transform processes): Measures are numerical values that represent consumption, events, transactions. Example: liters purified; liters desalinated; liters decanted; Kw consumed…
• Dimension (which enables Transform processes): Dimensions are variables that allow measures to be contextualized. Example: shift, equipment, product…

That is, the information can be provided in a NON-CONTEXTUALIZED way:

• Example: 10,000 liters of desalinated water (only with the measure), or it can be provided in a CONTEXTUALIZED way.
• Example: 10,000 liters of desalinated water, on February 28, during the morning shift, with equipment group 3, using sand filters 1 and 3 and consuming 30,000 Kwh.

Wonderware Intelligence provides the development environment that allows integrating information from different data sources, defining the measures and contextualizing them through different dimensions. Additionally, to perform information exploitation processes, Wonderware Intelligence includes reporting tools based on the Tableau Software solution. In any case, it is necessary to clarify that the contextualized information that is collected in the Intelligence database can be exploited with any other information exploitation tool (such as Qlick View, Cognos, Microstrategy…), since it is a SQL database accessible via ODBC and OLE DB.

It can be concluded that the main functionalities of Wonderware Intelligence are the following:

• Allows to standardize and homogenize ETL processes associated with industrial and infrastructure environments.
• Creates contextualized information in real time from data from different sources.
• Includes native support for Wonderware Historian, eDNA and OSIsoft PI Server namespaces.
• Combines real-time information and transactional information, performing measurements and contextualization processes in real time. It uses a single development environment to manage both types of information.
• Provides predefined models for Wonderware data sources (MES, Alarms, InBatch, Historian,…) Facilitates the development of dashboards without the need for programming.