1. Home
    2. topviewData Source
  2. TopView SQL Lookup

TopView SQL Lookup

for ODBC/OLEDB Data Sources

TopView SQL Lookup allows you to easily monitor, alarm, and send notifications (Email, SMS, TAP, Text-to-speech, Voice, …) for database lookup-query results performed against databases (DBMS), spreadsheets, and files.

TopView SQL Lookup is designed for monitoring values that can be queried in a lookup table. For example, a SQL table of device names with their current measurement values and timestamps is an ideal candidate for TopView SQL Lookup. Our other SQL-based TopView product, TopView for SQL Events,  is designed to monitor and filter event logs written to SQL databases.

Pictorial Overview of TopView SQL Lookup

Download evaluation version of TopView SQL Lookup

Using TopView SQL Lookup with Inductive Automation Ignition

TopView SQL Lookup Product Overview and Demo

The following TopView video will overview the TopView SQL Lookup product and demonstrate how to configure TopView SQL Lookup to perform real-time monitoring of data from an ODBC or OLEDB database.

More about TopView SQL Lookup

ODBC and OLEDB provide standard interfaces for querying data from databases. Some drivers also support spreadsheets and files as the data source.

TopView SQL Queries support SELECT statements and Stored Procedures.

TopView SQL supports ODBC or OLEDB data sources including:

  • Oracle
  • Microsoft SQL Server
  • Microsoft Access
  • Wonderware Historian
  • MySQL
  • Paradox
  • FoxPro
  • IBM Informix, DB2, ISeries
  • PI OLEDB (for OSISoft PI)
  • Microsoft Excel
  • Flat files (CSV, tab-delimited, etc.)

TopView SQL allows real-time monitoring and alarming for:

  • Process Data historians
  • Lab systems
  • Inventory systems
  • Database performance (Database statistics queries)
  • CRM databases
  • Sharepoint databases
  • Maintenance systems
  • Most DBMS’s (Database Management Systems)