Device & Data Integration
HMI/SCADA Add-Ins
Industrial Data Ops
TOP Server ODBC Client Bridge OPC Driver
Reliable OPC client access to ODBC data sources
The TOP Server® ODBC Client Bridge Driver provides a communication interface to databases as long as the database has an ODBC interface available. This includes but it not limited to Access, SQL Server, Oracle, and many others. Think of the driver as a way to bridge data from databases to OPC UA, OPC DA, and Suitelink.
This driver can read / write data from/to databases in four different ways - using fixed tables, dynamic tables, queries, and stored procedures. The driver can automatically generate tags in TOP server based on tables, queries and stored procedures. Data acquisition is optimized based on upstream client demand while data integrity is ensured using extensive error handling.
This driver is primarily used for reading and converting database data to OPC. If you need to log data from drivers in TOP Server a regular or triggered basis, you should consider the TOP Server DataLogger plug-in instead.
Available here as a standalone real-time data driver or also available in the following vertical Industry Suite:
TOP Server ODBC Client Bridge Driver
$1846
$
Part # 41233169-N
Delivery Methods: CD or Online
Availability: 0 to 1 Business Days
Perpetual License to use the server and drivers in this suite on a single computer with no artificial limits on number of devices, tags, or connected client applications. Includes 1 yr support & maintenance agreement.
FEATURES & RESOURCES
-
Key Features
-
Standard Features
-
Advanced Features
-
Device Support
-
Protocols / Networks
-
Available Languages
-
Videos & App Notes
-
Help Files & Release Notes
-
Technical Blog
-
Additional Resources
ODBC Client Bridge Key Features Include
- Maximum Number of Channels & Devices:
- Channels - 256
- Devices per Channel - 4096
- NOTE: Practical channel/device limits will vary depending on your available system resources and communications architecture
- Supports multiple connection sessions to multiple ODBC data sources
- Supports four access methods: fixed table, dynamic table, query, and stored procedure
- Automatic Tag Database generation for plug and play ease of use
Standard ODBC Client Bridge Features Include
- Supports four access methods: fixed table, dynamic table, query, and stored procedure
- TOP Server Built-In Features:
- Multi-threaded architecture for high scalability
- Runtime changes via wizard-based configuration interface with intuitive Properties Editor
- Secure User Management
- Built-in Device/Network Redundancy
- Auto-Demotion (Slow Polling)
- Extensive communication and server diagnostics (OPC / Communications / Event Log)
- For all TOP Server built-in features, click here.
ODBC Client Bridge Advanced Features Include
- Automatic Tag Database Generation based on tables, queries and stored procedures from your ODBC data source - simplifies setup and saves you significant engineering time and money.
- Support for "Execute" statements within the Query access method
- Execute tag for executing queries (e.g. Channel.Device.Execute)
- Supports the ability to enable or disable the query time interval, allowing users to exclusively trigger queries on demand via the device's Execute tag.
- Supports read and write to SQL engine
- Write to BIGINT stored procedure inputs
- Supports automatic generation of SQL type 'NCHAR' as OPC type 'string'
Supported Devices Include (Don't See Your Device Listed? Contact Us)
- Microsoft Access
- Microsoft SQL
- MySQL
- Oracle
- Sybase
Supported Protocols / Networks
- ODBC API
TOP Server How-To Videos and Application Notes
To insure you get the most from your investment in TOP Server®, we provide a variety of application notes/guides and how-to videos, since we know that sometimes it helps to see someone showing you how to do things.
Driver Help Files / Release Notes
Use the below links to access TOP Server release history and driver help documentation.
Access use cases, how-tos and more
Real-world use cases, step-by-step how-to's and video tutorials - our blog contains useful resources and information to help you get connected.
TOP Server Specific Blog Posts
Additional Useful Resources
Access additional TOP Server related information below not covered in other sections:
Get Started Now
The demo is the full product once licensed. Once a client application connects to the TOP Server, the TOP Server runtime will operate for 2 hours at a time. At the end of the 2 hour demo period, the demo timer must be reset by restarting the TOP Server runtime service.
Connect with Us
1-888-665-3678 (US + Canada toll free)
+1-704-849-2773 (Global)
support.softwaretoolbox.com
STAY CONNECTED
1-888-665-3678 (US + Canada)
+1-704-849-2773 (Global)
+1-704-849-6388 (Fax)
support.softwaretoolbox.com
WORKING WITH US
WHO WE ARE
RECENT POSTS
Usage subject to our website terms and conditions.
