ODBC Client | Velotic
Chat with us

ODBC Client

The ODBC Client driver works in conjunction with Kepware Server to provide single-point access to multiple ODBC data sources via Open DataBase Connectivity (ODBC).

View price

Details

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

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

Also consider

Kepware+

Get all Kepware Server connectivity in one package, built for enterprises seeking to standardize and manage connectivity at scale.

Kepware Server Free Trial

Explore all Kepware Server capabilities for free and experience secure, reliable industrial connectivity before committing to purchase.