ODBC Drivers for DB2

Secure and high-performance data access technology from OpenLink Software. Connect to DB2 with enterprise-grade reliability and performance.

Loading options...

Start Your Trial

Note: After clicking "Get Trial License", you will need to log in if you haven't already done so. If you don't have an account, you'll need to create one on the next page.

Which Edition Do I Need?

Answer these questions to find the right edition for you:

Why Choose Our ODBC Drivers for DB2?

Enterprise-grade data connectivity with proven performance and reliability

⚡

High Performance

Optimized for speed and efficiency with minimal overhead, delivering fast query execution and data transfer.

🔒

Enterprise Security

Built-in encryption, authentication, and compliance features for mission-critical deployments.

📊

Universal Connectivity

Seamless integration with diverse applications and platforms across your technology stack.

Why Should You Care?

Our ODBC Drivers for DB2 are high-performing and enterprise-ready solutions for connecting to Oracle databases from 32- and 64-bit applications that support ODBC connectivity.They are Ideal For:

  • ✓ Analytics and Business Intelligence
  • ✓ Data Virtualization and Integration
  • ✓ Extract, Transform, Load (ETL) Operations
  • ✓ Enterprise Application Integration

Available Editions

Choose the right edition for your deployment needs

Lite (Single-Tier)

  • ✓ Direct client-to-database connectivity without middleware
  • ✓ Ideal for small- to medium-sized environments
  • ✓ Streamlined installation and simplified administration
Single-Tier Architecture Diagram

Enterprise (Multi-Tier)

  • ✓ Middleware-driven architecture for enterprise scalability
  • ✓ Advanced features: caching, load balancing, security controls
  • ✓ Built for mission-critical workloads and distributed environments
Multi-Tier Architecture Diagram

Features Comparison by Driver Edition

Compare features across different driver editions

format
featureID
featureLabel
featureSynopsis
formatImage
formatName
prodImage
https://data.openlinksw.com/oplweb/product_format/st#this
https://data.openlinksw.com/oplweb/product_feature/ConnectionPooling#this
Connection Pooling
Enables efficient management of resources associated with database sessions
https://uda.openlinksw.com/images/udapformatst.png
Single-Tier Architecture
https://uda.openlinksw.com/images/odbcdb2st.gif
https://data.openlinksw.com/oplweb/product_format/st#this
https://data.openlinksw.com/oplweb/product_feature/Databasemirroringcompatibility#this
Database mirroring compatibility
Provides developer with DBMS server topology flexibility
https://uda.openlinksw.com/images/udapformatst.png
Single-Tier Architecture
https://uda.openlinksw.com/images/odbcdb2st.gif
https://data.openlinksw.com/oplweb/product_format/st#this
https://data.openlinksw.com/oplweb/product_feature/DeferredFetchingofBlobData#this
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.
https://uda.openlinksw.com/images/udapformatst.png
Single-Tier Architecture
https://uda.openlinksw.com/images/odbcdb2st.gif
https://data.openlinksw.com/oplweb/product_format/st#this
https://data.openlinksw.com/oplweb/product_feature/MultipleActiveResultSets-MARS#this
Multiple Active Result Sets (MARS)
Enables applications developers to work concurrently against multiple query result sets
https://uda.openlinksw.com/images/udapformatst.png
Single-Tier Architecture
https://uda.openlinksw.com/images/odbcdb2st.gif
https://data.openlinksw.com/oplweb/product_format/st#this
https://data.openlinksw.com/oplweb/product_feature/Multithreadingsupport#this
Multithreading support
Enables development, deployment, and use of multithreaded client applications.
https://uda.openlinksw.com/images/udapformatst.png
Single-Tier Architecture
https://uda.openlinksw.com/images/odbcdb2st.gif
https://data.openlinksw.com/oplweb/product_format/st#this
https://data.openlinksw.com/oplweb/product_feature/ReferenceCursorsSupportinStoredProcedures#this
Reference Cursors Support in Stored Procedures
Support for advanced DBMS Server functionality.
https://uda.openlinksw.com/images/udapformatst.png
Single-Tier Architecture
https://uda.openlinksw.com/images/odbcdb2st.gif
https://data.openlinksw.com/oplweb/product_format/st#this
https://data.openlinksw.com/oplweb/product_feature/SSLSupport#this
SSL Support
Secure data transmission between applications and DBMS server
https://uda.openlinksw.com/images/udapformatst.png
Single-Tier Architecture
https://uda.openlinksw.com/images/odbcdb2st.gif
https://data.openlinksw.com/oplweb/product_format/st#this
https://data.openlinksw.com/oplweb/product_feature/Snapshottransactionisolationlevel#this
Snapshot transaction isolation level
Enabling additional transaction isolation granularity to application developers.
https://uda.openlinksw.com/images/udapformatst.png
Single-Tier Architecture
https://uda.openlinksw.com/images/odbcdb2st.gif
https://data.openlinksw.com/oplweb/product_format/st#this
https://data.openlinksw.com/oplweb/product_feature/SupportforSerialDataType#this
Support for Serial Data Type
Provides application developers with access to last serial values for a given table.
https://uda.openlinksw.com/images/udapformatst.png
Single-Tier Architecture
https://uda.openlinksw.com/images/odbcdb2st.gif
https://data.openlinksw.com/oplweb/product_format/st#this
https://data.openlinksw.com/oplweb/product_feature/TransactionIsolationLevelsconfiguration#this
Transaction Isolation Levels configuration
User-level configuration of Transaction Isolation Levels. Transaction Isolation levels are optionally configurable as part of the DBMS connection configuration.
https://uda.openlinksw.com/images/udapformatst.png
Single-Tier Architecture
https://uda.openlinksw.com/images/odbcdb2st.gif
https://data.openlinksw.com/oplweb/product_format/st#this
https://data.openlinksw.com/oplweb/product_feature/TransactionIsolationmodediscovery#this
Transaction Isolation mode discovery
Enables developers to determine if DBMS instance is transactional or non-transactional.
https://uda.openlinksw.com/images/udapformatst.png
Single-Tier Architecture
https://uda.openlinksw.com/images/odbcdb2st.gif
https://data.openlinksw.com/oplweb/product_format/st#this
https://data.openlinksw.com/oplweb/product_feature/XMLandNativeLargeValuedatatypessupport#this
XML and Native Large Value data types support
Provides developers with increased range of data types for developing new-generation applications.
https://uda.openlinksw.com/images/udapformatst.png
Single-Tier Architecture
https://uda.openlinksw.com/images/odbcdb2st.gif
https://data.openlinksw.com/oplweb/product_format/mt#this
https://data.openlinksw.com/oplweb/product_feature/ConnectionPooling#this
Connection Pooling
Enables efficient management of resources associated with database sessions
https://uda.openlinksw.com/images/udapformatmt.png
Multi-Tier Architecture
https://uda.openlinksw.com/images/odbcdb2mt.gif
https://data.openlinksw.com/oplweb/product_format/mt#this
https://data.openlinksw.com/oplweb/product_feature/DatabaseIndependentNetworking#this
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).
https://uda.openlinksw.com/images/udapformatmt.png
Multi-Tier Architecture
https://uda.openlinksw.com/images/odbcdb2mt.gif
https://data.openlinksw.com/oplweb/product_format/mt#this
https://data.openlinksw.com/oplweb/product_feature/DatabaseIndependentNetworking#this
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).
https://uda.openlinksw.com/images/udapformatmt.png
Multi-Tier Architecture
https://uda.openlinksw.com/images/odbcdb2mt.gif
https://data.openlinksw.com/oplweb/product_format/mt#this
https://data.openlinksw.com/oplweb/product_feature/Databasemirroringcompatibility#this
Database mirroring compatibility
Provides developer with DBMS server topology flexibility
https://uda.openlinksw.com/images/udapformatmt.png
Multi-Tier Architecture
https://uda.openlinksw.com/images/odbcdb2mt.gif
https://data.openlinksw.com/oplweb/product_format/mt#this
https://data.openlinksw.com/oplweb/product_feature/DeferredFetchingofBlobData#this
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.
https://uda.openlinksw.com/images/udapformatmt.png
Multi-Tier Architecture
https://uda.openlinksw.com/images/odbcdb2mt.gif
https://data.openlinksw.com/oplweb/product_format/mt#this
https://data.openlinksw.com/oplweb/product_feature/MultipleActiveResultSets-MARS#this
Multiple Active Result Sets (MARS)
Enables applications developers to work concurrently against multiple query result sets
https://uda.openlinksw.com/images/udapformatmt.png
Multi-Tier Architecture
https://uda.openlinksw.com/images/odbcdb2mt.gif
https://data.openlinksw.com/oplweb/product_format/mt#this
https://data.openlinksw.com/oplweb/product_feature/Multithreadingsupport#this
Multithreading support
Enables development, deployment, and use of multithreaded client applications.
https://uda.openlinksw.com/images/udapformatmt.png
Multi-Tier Architecture
https://uda.openlinksw.com/images/odbcdb2mt.gif
https://data.openlinksw.com/oplweb/product_format/mt#this
https://data.openlinksw.com/oplweb/product_feature/ReferenceCursorsSupportinStoredProcedures#this
Reference Cursors Support in Stored Procedures
Support for advanced DBMS Server functionality.
https://uda.openlinksw.com/images/udapformatmt.png
Multi-Tier Architecture
https://uda.openlinksw.com/images/odbcdb2mt.gif
https://data.openlinksw.com/oplweb/product_format/mt#this
https://data.openlinksw.com/oplweb/product_feature/SSLSupport#this
SSL Support
Secure data transmission between applications and DBMS server
https://uda.openlinksw.com/images/udapformatmt.png
Multi-Tier Architecture
https://uda.openlinksw.com/images/odbcdb2mt.gif
https://data.openlinksw.com/oplweb/product_format/mt#this
https://data.openlinksw.com/oplweb/product_feature/Snapshottransactionisolationlevel#this
Snapshot transaction isolation level
Enabling additional transaction isolation granularity to application developers.
https://uda.openlinksw.com/images/udapformatmt.png
Multi-Tier Architecture
https://uda.openlinksw.com/images/odbcdb2mt.gif
https://data.openlinksw.com/oplweb/product_format/mt#this
https://data.openlinksw.com/oplweb/product_feature/SupportforSerialDataType#this
Support for Serial Data Type
Provides application developers with access to last serial values for a given table.
https://uda.openlinksw.com/images/udapformatmt.png
Multi-Tier Architecture
https://uda.openlinksw.com/images/odbcdb2mt.gif
https://data.openlinksw.com/oplweb/product_format/mt#this
https://data.openlinksw.com/oplweb/product_feature/TransactionIsolationLevelsconfiguration#this
Transaction Isolation Levels configuration
User-level configuration of Transaction Isolation Levels. Transaction Isolation levels are optionally configurable as part of the DBMS connection configuration.
https://uda.openlinksw.com/images/udapformatmt.png
Multi-Tier Architecture
https://uda.openlinksw.com/images/odbcdb2mt.gif
https://data.openlinksw.com/oplweb/product_format/mt#this
https://data.openlinksw.com/oplweb/product_feature/TransactionIsolationmodediscovery#this
Transaction Isolation mode discovery
Enables developers to determine if DBMS instance is transactional or non-transactional.
https://uda.openlinksw.com/images/udapformatmt.png
Multi-Tier Architecture
https://uda.openlinksw.com/images/odbcdb2mt.gif
https://data.openlinksw.com/oplweb/product_format/mt#this
https://data.openlinksw.com/oplweb/product_feature/UDASessionRulesBook#this
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.
https://uda.openlinksw.com/images/udapformatmt.png
Multi-Tier Architecture
https://uda.openlinksw.com/images/odbcdb2mt.gif
https://data.openlinksw.com/oplweb/product_format/mt#this
https://data.openlinksw.com/oplweb/product_feature/UDASessionRulesBook#this
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.
https://uda.openlinksw.com/images/udapformatmt.png
Multi-Tier Architecture
https://uda.openlinksw.com/images/odbcdb2mt.gif
https://data.openlinksw.com/oplweb/product_format/mt#this
https://data.openlinksw.com/oplweb/product_feature/XMLandNativeLargeValuedatatypessupport#this
XML and Native Large Value data types support
Provides developers with increased range of data types for developing new-generation applications.
https://uda.openlinksw.com/images/udapformatmt.png
Multi-Tier Architecture
https://uda.openlinksw.com/images/odbcdb2mt.gif