USE CASE: ODBC, JDBC, AND OLE DB ACCESS TO SCADA AND DATA HISTORIAN SYSTEMS

Goal

Access information in SCADA systems from widely used desktop tools for reporting, analysis and application development.

Issues and Alternatives

SCADA systems store and archive real-time data from many different data sources. These systems are normally run on UNIX, VAX/VMS, Alpha/OpenVMS or Windows NT platforms. This does not make this information easily accessible and usable by standard desktop tools.

Resolution

Most desktop tools are ODBC, OLE DB, and JDBC compatible. Using OpenAccess SDK, you can quickly implement a custom driver for one of these standard APIS to access your SCADA system—without expertise in ODBC, JDBC, OLE DB, or SQL.

Implementation

See ODBC, JDBC, and OLE DB Access to SCADA and Data Historian Systems for a sample case, implementation instructions, and the OpenAccess features suited to SCADA systems.

Benefits

• Quickly access information in proprietary SCADA systems from standard desktop tools like Microsoft Access, Crystal Reports, Microsoft Excel, and many others. 
• Develop with minimal human resource investment because it does not require expertise in ODBC, JDBC, OLE DB, or SQL. 
• Limit the types of queries that can be issued. 
• Support many hardware platforms and operating systems.