|
|
ODBC (Open Database Connectivity) allows historical plant
process data to integrate directly with any type of ODBC-enabled
application. Many off-the-shelf, third-party desktop applications
such as word processors, spreadsheets, and database application
development tools are ODBC-enabled.
The ODBC Server can immediately import historic process data
directly from the control system to the desktop application,
eliminating the effort and error of manual data entry. Performance
data from the DCS historian can be combined with accounting
or other information, allowing plant managers to compare expected
plant performance.
ODBC has become the standard for connecting applications
to both local and remote databases. Structured Query Language
(SQL) has emerged as the standard language for accessing and
filtering data. With these standards now in place, it is possible
for applications to access the historical databases in different
systems without requiring the use of a proprietary data link.
This standardized approach reduces development costs, and
ensures a reliable, easy to use interface to access critical
historic plant performance data.
ODBC Server Features:
- Delivers critical historic process data to multiple client
applications
- Uses SQL queries to filter data at the server, reducing
network traffic
- Provides an easy way for plants to develop their own customized
OPC client applications using any current Microsoft®
Windows® development environment
- Supports applications that combine historic DCS data with
other data sources, such as lab or product cost analysis.
|
