TopView SQL for ODBC and OLEDB Data Sources
 

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

---

Watch the TopView SQL Intro and Configuration video

View the pictorial overview of TopView SQL

Download a full-functioning evaluation version of TopView SQL

---

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, ..)

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.