TopView SQL Lookup

for ODBC/OLEDB Data Sources

TopView SQL Lookup allows you to easily monitor, alarm, and send notification (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


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)

TopView SQL provides a transparent layer between each database and the points (“tags”) that will be monitored by the TopView Alarm and Notification Engine.