ODBC Drivers for DB2

Secure and High-Performance Data Access Technology,
from OpenLink Software

Overview

OpenLink Software's ODBC Drivers for DB2 are high performing and enterprise-ready solutions for connecting to DB2 data sources from 32- and 64-bit ODBC-compliant applications used for:

  • Analytics
  • Virtualization
  • Business Intelligence (BI)
  • Extract, Transform, Load (ETL)

In addition to our generic data access driver features, these driver solutions offer the following additional benefits:

featureID
feature
featureLabel
featureSynopsis
hash
benefitID
benefitLabel
benefitSynopsis
Multithreading support
Enables development, deployment, and use of multithreaded client applications.
f988f51e9e4290f8edc72deb5740e6c8
Sophisticated Application Functionality
Supports data access, integration and management, from the simplest to the most sophisticated functionality
Deferred Fetching of Blob Data
The SQLGetData() and SQLPutData() ODBC API implementations have been significantly enhanced to provide intelligent handling of BLOB data. This facilitates transferring parameter data in parts over the network between the Enterprise Edition (Multi-Tier) Generic Client and Database Agents. Once transferred, the fragmented column data is reassembled in its entirety within the Client and/or Agent parts of the Enterprise Edition (Multi-Tier) driver (depending on if this is an insert or retrieval). This feature applies to data types such as SQL_LONGVARCHAR, SQL_WLONGVARCHAR, SQL_LONGVARBINARY, BLOB, and CLOB.
26095976fbfdb67686007bd3354e122a
Sophisticated Application Functionality
Supports data access, integration and management, from the simplest to the most sophisticated functionality
ODBC connection architecture diagram

Available Editions

Lite (Single-Tier)

  • These drivers are designed to connect a client application directly to a specific data source, such as a database management system, spreadsheet, or text file.
  • They do not require any additional middleware components to be installed.
  • Lite Edition drivers are suitable for small- to medium-sized environments.

Enterprise (Multi-Tier)

  • These drivers are designed to connect a client application to a data source via a middleware server, such as a web server or application server.
  • The middleware server acts as a gateway to the data source, and can provide additional functionality such as caching, load balancing, and data transformation.
  • Enterprise Edition drivers are ideal for large, distributed environments where security, scalability, and reliability are important.

format
featureID
featureLabel
featureSynopsis
benefitID
benefitLabel
benefitSynopsis
formatImage
formatName
prodImage
Connection Pooling
Enables efficient management of resources associated with database sessions
Controlled Access to Data Assets
Controlled Access to Data Assets prevents unauthorised changes
https://uda.openlinksw.com/images/udapformatst.png
Single-Tier Architecture
https://uda.openlinksw.com/images/odbcdb2st.gif
Database mirroring compatibility
Provides developer with DBMS server topology flexibility
Sophisticated Application Functionality
Supports data access, integration and management, from the simplest to the most sophisticated functionality
https://uda.openlinksw.com/images/udapformatst.png
Single-Tier Architecture
https://uda.openlinksw.com/images/odbcdb2st.gif
Deferred Fetching of Blob Data
The SQLGetData() and SQLPutData() ODBC API implementations have been significantly enhanced to provide intelligent handling of BLOB data. This facilitates transferring parameter data in parts over the network between the Enterprise Edition (Multi-Tier) Generic Client and Database Agents. Once transferred, the fragmented column data is reassembled in its entirety within the Client and/or Agent parts of the Enterprise Edition (Multi-Tier) driver (depending on if this is an insert or retrieval). This feature applies to data types such as SQL_LONGVARCHAR, SQL_WLONGVARCHAR, SQL_LONGVARBINARY, BLOB, and CLOB.
Sophisticated Application Functionality
Supports data access, integration and management, from the simplest to the most sophisticated functionality
https://uda.openlinksw.com/images/udapformatst.png
Single-Tier Architecture
https://uda.openlinksw.com/images/odbcdb2st.gif
Multiple Active Result Sets (MARS)
Enables applications developers to work concurrently against multiple query result sets
Controlled Access to Data Assets
Controlled Access to Data Assets prevents unauthorised changes
https://uda.openlinksw.com/images/udapformatst.png
Single-Tier Architecture
https://uda.openlinksw.com/images/odbcdb2st.gif
Multithreading support
Enables development, deployment, and use of multithreaded client applications.
Sophisticated Application Functionality
Supports data access, integration and management, from the simplest to the most sophisticated functionality
https://uda.openlinksw.com/images/udapformatst.png
Single-Tier Architecture
https://uda.openlinksw.com/images/odbcdb2st.gif
Reference Cursors Support in Stored Procedures
Support for advanced DBMS Server functionality.
Sophisticated Application Functionality
Supports data access, integration and management, from the simplest to the most sophisticated functionality
https://uda.openlinksw.com/images/udapformatst.png
Single-Tier Architecture
https://uda.openlinksw.com/images/odbcdb2st.gif
SSL Support
Secure data transmission between applications and DBMS server
Controlled Access to Data Assets
Controlled Access to Data Assets prevents unauthorised changes
https://uda.openlinksw.com/images/udapformatst.png
Single-Tier Architecture
https://uda.openlinksw.com/images/odbcdb2st.gif
Snapshot transaction isolation level
Enabling additional transaction isolation granularity to application developers.
Sophisticated Application Functionality
Supports data access, integration and management, from the simplest to the most sophisticated functionality
https://uda.openlinksw.com/images/udapformatst.png
Single-Tier Architecture
https://uda.openlinksw.com/images/odbcdb2st.gif
Support for Serial Data Type
Provides application developers with access to last serial values for a given table.
Sophisticated Application Functionality
Supports data access, integration and management, from the simplest to the most sophisticated functionality
https://uda.openlinksw.com/images/udapformatst.png
Single-Tier Architecture
https://uda.openlinksw.com/images/odbcdb2st.gif
Transaction Isolation Levels configuration
User-level configuration of Transaction Isolation Levels. Transaction Isolation levels are optionally configurable as part of the DBMS connection configuration.
Sophisticated Application Functionality
Supports data access, integration and management, from the simplest to the most sophisticated functionality
https://uda.openlinksw.com/images/udapformatst.png
Single-Tier Architecture
https://uda.openlinksw.com/images/odbcdb2st.gif
Transaction Isolation mode discovery
Enables developers to determine if DBMS instance is transactional or non-transactional.
Sophisticated Application Functionality
Supports data access, integration and management, from the simplest to the most sophisticated functionality
https://uda.openlinksw.com/images/udapformatst.png
Single-Tier Architecture
https://uda.openlinksw.com/images/odbcdb2st.gif
XML and Native Large Value data types support
Provides developers with increased range of data types for developing new-generation applications.
Sophisticated Application Functionality
Supports data access, integration and management, from the simplest to the most sophisticated functionality
https://uda.openlinksw.com/images/udapformatst.png
Single-Tier Architecture
https://uda.openlinksw.com/images/odbcdb2st.gif
Connection Pooling
Enables efficient management of resources associated with database sessions
Controlled Access to Data Assets
Controlled Access to Data Assets prevents unauthorised changes
https://uda.openlinksw.com/images/udapformatmt.png
Multi-Tier Architecture
https://uda.openlinksw.com/images/odbcdb2mt.gif
Database Independent Networking
Database Independent Networking that enables the use of a single generic data access driver for ODBC, JDBC, ADO.NET, and OLE DB with a variety of backend database management systems (dbms).
Ease of Integration
Ease of integration speeds deployment and enhances utility
https://uda.openlinksw.com/images/udapformatmt.png
Multi-Tier Architecture
https://uda.openlinksw.com/images/odbcdb2mt.gif
Database Independent Networking
Database Independent Networking that enables the use of a single generic data access driver for ODBC, JDBC, ADO.NET, and OLE DB with a variety of backend database management systems (dbms).
Ease of Integration
Ease of integration speeds deployment and enhances utility
https://uda.openlinksw.com/images/udapformatmt.png
Multi-Tier Architecture
https://uda.openlinksw.com/images/odbcdb2mt.gif
Database mirroring compatibility
Provides developer with DBMS server topology flexibility
Sophisticated Application Functionality
Supports data access, integration and management, from the simplest to the most sophisticated functionality
https://uda.openlinksw.com/images/udapformatmt.png
Multi-Tier Architecture
https://uda.openlinksw.com/images/odbcdb2mt.gif
Deferred Fetching of Blob Data
The SQLGetData() and SQLPutData() ODBC API implementations have been significantly enhanced to provide intelligent handling of BLOB data. This facilitates transferring parameter data in parts over the network between the Enterprise Edition (Multi-Tier) Generic Client and Database Agents. Once transferred, the fragmented column data is reassembled in its entirety within the Client and/or Agent parts of the Enterprise Edition (Multi-Tier) driver (depending on if this is an insert or retrieval). This feature applies to data types such as SQL_LONGVARCHAR, SQL_WLONGVARCHAR, SQL_LONGVARBINARY, BLOB, and CLOB.
Sophisticated Application Functionality
Supports data access, integration and management, from the simplest to the most sophisticated functionality
https://uda.openlinksw.com/images/udapformatmt.png
Multi-Tier Architecture
https://uda.openlinksw.com/images/odbcdb2mt.gif
Multiple Active Result Sets (MARS)
Enables applications developers to work concurrently against multiple query result sets
Controlled Access to Data Assets
Controlled Access to Data Assets prevents unauthorised changes
https://uda.openlinksw.com/images/udapformatmt.png
Multi-Tier Architecture
https://uda.openlinksw.com/images/odbcdb2mt.gif
Multithreading support
Enables development, deployment, and use of multithreaded client applications.
Sophisticated Application Functionality
Supports data access, integration and management, from the simplest to the most sophisticated functionality
https://uda.openlinksw.com/images/udapformatmt.png
Multi-Tier Architecture
https://uda.openlinksw.com/images/odbcdb2mt.gif
Reference Cursors Support in Stored Procedures
Support for advanced DBMS Server functionality.
Sophisticated Application Functionality
Supports data access, integration and management, from the simplest to the most sophisticated functionality
https://uda.openlinksw.com/images/udapformatmt.png
Multi-Tier Architecture
https://uda.openlinksw.com/images/odbcdb2mt.gif
SSL Support
Secure data transmission between applications and DBMS server
Controlled Access to Data Assets
Controlled Access to Data Assets prevents unauthorised changes
https://uda.openlinksw.com/images/udapformatmt.png
Multi-Tier Architecture
https://uda.openlinksw.com/images/odbcdb2mt.gif
Snapshot transaction isolation level
Enabling additional transaction isolation granularity to application developers.
Sophisticated Application Functionality
Supports data access, integration and management, from the simplest to the most sophisticated functionality
https://uda.openlinksw.com/images/udapformatmt.png
Multi-Tier Architecture
https://uda.openlinksw.com/images/odbcdb2mt.gif
Support for Serial Data Type
Provides application developers with access to last serial values for a given table.
Sophisticated Application Functionality
Supports data access, integration and management, from the simplest to the most sophisticated functionality
https://uda.openlinksw.com/images/udapformatmt.png
Multi-Tier Architecture
https://uda.openlinksw.com/images/odbcdb2mt.gif
Transaction Isolation Levels configuration
User-level configuration of Transaction Isolation Levels. Transaction Isolation levels are optionally configurable as part of the DBMS connection configuration.
Sophisticated Application Functionality
Supports data access, integration and management, from the simplest to the most sophisticated functionality
https://uda.openlinksw.com/images/udapformatmt.png
Multi-Tier Architecture
https://uda.openlinksw.com/images/odbcdb2mt.gif
Transaction Isolation mode discovery
Enables developers to determine if DBMS instance is transactional or non-transactional.
Sophisticated Application Functionality
Supports data access, integration and management, from the simplest to the most sophisticated functionality
https://uda.openlinksw.com/images/udapformatmt.png
Multi-Tier Architecture
https://uda.openlinksw.com/images/odbcdb2mt.gif
Session Rules Book
Attibute-based Access Controls that apply to all ODBC, JDBC, ADO.NET, OLE DB connnections to a target database. Default attributes include username, machine name or network address, client application operating system, and administrator configurable domain. This functionality provides data access policies that enable control over read and write modes available to ODBC, JDBC, ADO.NET, or OLD DB connections as applications and service usage evolves. For example, transparently enabling read-only mode when an application is being used outside the office thereby thwarting hacks that might occur over WiFi connections. Or implications of different users operating the same application from a common device where each has different privileges.
Controlled Access to Data Assets
Controlled Access to Data Assets prevents unauthorised changes
https://uda.openlinksw.com/images/udapformatmt.png
Multi-Tier Architecture
https://uda.openlinksw.com/images/odbcdb2mt.gif
Session Rules Book
Attibute-based Access Controls that apply to all ODBC, JDBC, ADO.NET, OLE DB connnections to a target database. Default attributes include username, machine name or network address, client application operating system, and administrator configurable domain. This functionality provides data access policies that enable control over read and write modes available to ODBC, JDBC, ADO.NET, or OLD DB connections as applications and service usage evolves. For example, transparently enabling read-only mode when an application is being used outside the office thereby thwarting hacks that might occur over WiFi connections. Or implications of different users operating the same application from a common device where each has different privileges.
Controlled Access to Data Assets
Controlled Access to Data Assets prevents unauthorised changes
https://uda.openlinksw.com/images/udapformatmt.png
Multi-Tier Architecture
https://uda.openlinksw.com/images/odbcdb2mt.gif
XML and Native Large Value data types support
Provides developers with increased range of data types for developing new-generation applications.
Sophisticated Application Functionality
Supports data access, integration and management, from the simplest to the most sophisticated functionality
https://uda.openlinksw.com/images/udapformatmt.png
Multi-Tier Architecture
https://uda.openlinksw.com/images/odbcdb2mt.gif

Features Comparison by Driver Edition