Knowledge Base

Before you get started connecting interfaces to Visual KPI, ensure you meet the the following prerequisites: Install Visual KPI Server...

Visual KPI supports thousands of data sources. Each data source requires its own interface, and the method used to read...

Historian interfaces include time-series data that has a starting value, ending value and successive intermediate values based on set and...

Data can be collected from sources where the data is entered manually. Generally, this includes spreadsheets and forms. These are...

It is possible to establish a connection to a Microsoft Excel spreadsheet as a data source. However, changes to Microsoft...

You can obtain data from an Internet source or from in-house applications that can restrict access to data by using...

Note: The SQL interface feature is no longer available. It is included here for users that have existing SQL interfaces. Use...

Note: The native SQL interface type is no longer available. Why? Well, a) nobody really needed it, and b) the ODBC interface...

It is common that custodians of specialized data sources do not allow direct access to ERPs or vertical industry applications...

An interface requires security credentials configuration to access the databases. There are some best practices to follow to ensure the...

In many organizations, data source time zones and units vary. Data sources may be located in several different time zones...

Visual KPI interfaces allow the Visual KPI Server to communicate with and read data from external data sources, such as...

Interfacing with data sources allows the Visual KPI Server to communicate with and retrieve data from almost any data source....

You’ll use ODBC interfaces to connect to a SQL database. Use Visual KPI Server Manager to install and configure  ODBC interfaces....

Use Visual KPI Server Manager to install and configure the ODBC interface. The ODBC Interface can be installed on Visual...

The Visual KPI PI interface is a Web service that communicates with OSIsoft’s PI-SDK to get data from a PI...

Visual KPI Remote Context Services (RCS) can use OSIsoft PI AF as the master for configuration and hierarchy data and...

Use a JSON (REST) interface when connecting to restful databases. The JSON interface is made up of a base address...

Use Visual KPI Server Manager to install and configure the JSON interface. The JSON interface can be installed on Visual...

Visual KPI supports the use of Microsoft Excel as a data source. You can create interfaces to existing Excel worksheets or...

A Microsoft Excel Interface can be installed on Visual KPI Server or on any machine that is available to the...

OLAP interfaces, or Online Analytical Processing, is an older Microsoft standard for connecting to business data in multi-dimensional arrays. The...

Use Visual KPI Server Manager to install and configure an OLAP interface. An OLAP interface can be installed on Visual...

The format for connect strings varies, depending on the target database. You can define the connect string in the interface...

If you receive interface connection errors when trying to verify an interface connection, you can try these troubleshooting tips. Verify...

Use Visual KPI Server Manager to install and configure the GE Proficy interface. If you’ve been using the OLEDB interface,...

You can use ODBC Aggregation Settings with an ODBC interface to do some math on the returned data (a bucket...