Overview of Data Provider

The Microsoft OLE DB Provider for DB2 Version 4.0 (Data Provider) lets you create distributed applications targeting IBM DB2 databases. The Data Provider takes advantage of Microsoft SQL Server data access architecture together with a Microsoft network client for DB2 that functions as a Distributed Relational Database Architecture (DRDA) application requester. The Data Provider converts Microsoft Component Object Model (COM) OLE DB commands and data types to DRDA protocol code points and data formats.

OLEDB V4.0 enterprise data integration solutions

Data Provider Features

The Data Provider offers the following features:

  • Installation using an interactive and scriptable program.

  • Support for Windows 32-bit x86 and 64-bit x64 operating systems.

  • Access to DB2 server computers across a TCP/IP network connection.

  • Execution of DB2 dynamic SQL commands within remote unit of work transactions.

  • Tools for creating, testing, modifying and storing data source definitions.

  • A trace utility for recording flows and commands to enable troubleshooting of problems.

  • Help through on-line user documentation.

The Data Provider is designed and tested for use with Microsoft SQL Server 2012 and Microsoft SQL Server 2008 R2. The Data Provider is based on technology in Microsoft Host Integration Server 2010. For more information about HIS 2010, see Host Integration Server 2010 (http://go.microsoft.com/fwlink/?LinkID=180445).