ODBC Client Driver OPC Server

Product # EX5-ODBCI-NA00 - $895.00
Support & Maintenance within Warranty - $179.00
Support & Maintenance out Warranty / Expired - $447.50
Buy Now
Kepware's ODBC Client driver works in conjunction with our OPC Server KEPServerEX, to provide single-point access to multiple ODBC data sources via ODBC (Open DataBase Connectivity). The goal of ODBC is to make it possible to gather any data from any application, regardless of which database management system (DBMS) is handling the data. Using the power and speed of OPC, KEPServerEX is able to offer ODBC data to any OPC/DDE enabled client. Data integrity is ensured with our extensive error handling.

The ODBC Client Driver is also included in the Manufacturing Suite.

ODBC Client Driver OPC Server Manual ODBC Client Driver OPC Server Manual (PDF)


ODBC Client Driver OPC Server
Plug-in Driver Features:
  • Clients may reside Locally or Remotely
  • Clients can communicate via OPC or NetDDE
  • Read and write access to multiple ODBC compliant databases
  • Read and write to SQL engine
  • Write to BIGINT stored procedure inputs
  • Four access methods including fixed table, dynamic table, query, and stored procedure
  • Auto tag generation based on tables, queries and stored procedures from your ODBC data source
  • Auto-generation of SQL type 'NCHAR' as OPC type 'string'
  • Simple and self-evident user interface will allow users to get their data immediately


Protocol
  • ODBC API - Open DataBase Connectivity Application Programming Interface

Application Support
Supported Devices

Databases
  • Microsoft Access
  • Microsoft SQL
  • Oracle
  • Sybase
  • MySql
The ODBC Client Driver is capable of communicating with any application that supports the standard "ODBC" or MyODBC data source format.

Required: MDAC - Microsoft Data Access Components (it consists of several core components that provide various database technologies; including ODBC and its drivers.)

KEPServerEX OPC Server

Drivers "Plug-in" to KEPServerEX

The ODBC Client Driver OPC Server is a plug-in device driver for KEPServerEX. A "Plug-in" is a software program (.dll) that extends the capabilities of KEPServerEX to fit the communication requirements of a specific device or system. The plug-in driver handles all of the proprietary communications between the device/system and the OPC layer, KEPServerEX. The KEPServerEX core then handles all OPC and Proprietary Client communications between the plug-in driver and the Client application. For a complete list of features and capabilities please visit the KEPServerEX overview page.
  • OPC Foundation Certified - The Best of OPC on the Market
  • High Performance - Multi Threaded - Runtime Configurable
  • Detailed Protocol Diagnostics - Communications Trace
  • Detailed OPC Diagnostics - Communications Trace
  • Native Interfaces - Client Connectivity Beyond the OPC Standards
  • Stratus High Availability Computing - Certified
  • Marathon High Availability Computing - Certified
  • Kepware 2 Hour Demonstration Mode on all Products