ODBC Client

Subscription

$578/yr

Pay an annual fee to use the software. Support & Maintenance is included. Add to Cart Added

Your cart cannot contain both a Subscription and a Perpetual product.

Please modify your cart to add this license type.

Add to Cart
Perpetual

$1725

Pay a one-time product list price. Mandatory year-one Support & Maintenance Agreement is included. Add to Cart Added

Your cart cannot contain both a Subscription and a Perpetual product.

Please modify your cart to add this license type.

Add to Cart

Overview

Product Overview

The ODBC Client driver provides single-point access to multiple ODBC data sources via Open DataBase Connectivity (ODBC). 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, Kepware is able to offer ODBC data to any OPC/DDE enabled client and ensures data integrity through extensive error handling.

Performance

  • Clients may reside Locally or Remotely
  • Clients can communicate via OPC
  • Supports read and write access to multiple ODBC-compliant databases
  • Supports read and write to SQL engine
  • Write to BIGINT stored procedure inputs
  • Supports four access methods, including fixed table, dynamic table, query, and stored procedure
  • Supports automatic tag generation based on tables, queries, and stored procedures from your ODBC data source
  • Supports automatic generation of SQL type 'NCHAR' as OPC type 'string'
  • Simple interface enables users to get their data immediately

Protocols

  • ODBC API

Supported Devices

  • Microsoft Access
  • Microsoft SQL
  • MySql
  • Oracle
  • Sybase

Available Languages

  • English

Application Support

  • DDE Format CF_Text and AdvancedDDE
  • NIO Interface for iFIX
  • OPC .NET Service (OPC .NET) Version 1.00
  • OPC Alarms and Events (OPC AE) Version 1.10
  • OPC Data Access (OPC DA) Versions 1.0a, 2.0, 2.05a, and 3.0
  • OPC Unified Architecture (OPC UA) Clients
  • SuiteLink and FastDDE for Wonderware

Documents

Release Notes

Access and search all Kepware product release notes here.

Additional Tech Info

  • The ODBC Client driver is capable of communicating with many applications that support the standard "ODBC" or MyODBC data source format.
  • Microsoft Data Access Components (MDAC) is required. MDAC consists of several core components that provide various database technologies; including ODBC and its drivers.

Featured Suites