Overview

The Code192 Alpana Data Integration Tool provides an intuitive visual interface for integrating and transforming data from various sources into analytics ready data.

To import data from Wonderware Historian Server and RESTful Web Services, you need to install Code192 Alpana Data Integration Tool in the data server. This agent extracts the web accessible data to the data server and refresh the data to keep it alive based on provided time schedules.

To Configure your query and to be able to connect to the Historian Server, you need to install the Historian Web API.

Find how to install Historian Web APIhere

Find how to install Code192 Alpana Data Integration Tool here

Publishing workflow for live data

Here is the main workflow to publish live dashboards thanks to Code192 Alpana Data Integration Tool.

The publication of a live dashboard’s process is slightly different than Database Connection connector like Microsoft SQL Server, ODBC Connection (like Oracle) or flat file connectors like Microsoft Excel, JSON or CSV.

To achieve the live publication, you need a Database to store the live data gathered by Code192 Alpana Data Integration Tool.

The Code192 Integration Data Tool needs to know how often you want to update your database to publish a live dashboard.

  • Find how configuring live dashboard schedule here
  • Find how publishing live dashboard here

  • Find out advanced information about Data Integration Tool visual interface here