IBM DB2 ADO.NET Provider
 
ADO.NET
DB2 Logo

IBM DB2 ADO.NET Provider

SQL-based Access to DB2 through ADO.NET for your custom .NET applications and SSAS.

download buy now

Other Technologies

Other Drivers

The DB2 ADO.NET Data Provider enables user to easily connect to DB2 data from .NET applications. Rapidly create and deploy powerful .NET applications that integrate with IBM DB2.

ADO architecture

DB2 .NET Connectivity Features

  • Support for LUW and AS/400 instances of DB2. For interest in z/OS support, please contact our support team at [email protected].
  • Connect to live IBM DB2 data, for real-time data access with the IBM DB2 JDBC Driver
  • Full support for data aggregation and complex JOINs in SQL queries
  • Seamless integration with leading BI, reporting, and ETL tools and with custom applications via the DB2 Connector.

Target Service, API

The driver provides native connectivity to IBM DB2 including DB2 for z/OS, DB2 for i (AS/400), and DB2 LUW. Supports both on-premises and cloud deployments.

Schema, Data Model

Models DB2 with full access to schemas, tables, views, stored procedures, functions, and system objects. Complete metadata discovery with DB2-specific data types.

Key Objects

Schemas, Tables, Views, Stored Procedures, Functions, Triggers, Indexes, and system tables. Access to all DB2 database objects.

Operations

Full DB2 SQL support with ANSI compliance. All DML/DDL operations, stored procedure execution, and DB2-specific features. Supports distributed transactions.

Authentication

Standard DB2 authentication with Username/Password. Supports SSL/TLS connections and Kerberos. Connection properties include Server

Start a 30-day Free Trial Today

DB2 ADO.NET Download

See what you can do with DB2 ADO.NET provider

SSAS Cube
SSAS Cube

Use DB2 from SQL Server Analysis Service (SSAS) multi-dimensional cubes. Keep your analytical data modeling and access to any source including cloud and on-premises.

Custom .NET Application
Custom .NET Application

The DB2 ADO.NET Provider allows developers to build applications that connect to DB2 using familiar SQL and Entity Framework. Integrate DB2 to your mission -critical applications or create easy side-by-side applications.

Reporting & BI
Low-Code Dev Platforms

You can connect from ADO.NET compliant low-code development tools:

Reporting & BI
Reporting Tools

You can connect DB2 from .NET-based reporting and analytics tools:

Standard ADO.NET Access to DB2

The IBM DB2 ADO.NET Provider offers the most natural way to access DB2 data from any .NET application. Simply use IBM DB2 Data Provider objects to connect and access data just as you would access any traditional database. You will be able to use the IBM DB2 Data Provider through Visual Studio Server Explorer, in code through familiar classes, and in data controls like DataGridView, GridView, DataSet, etc.

The CData ADO.NET Provider for IBM DB2 hides the complexity of accessing data and provides additional powerful security features, smart caching, batching, socket management, and more.

Working with DataAdapters, DataSets, DataTables, etc.

The IBM DB2 Data Provider has the same ADO.NET architecture as the native .NET data providers for SQL Server and OLEDB, including: DB2Connection, DB2Command, DB2DataAdapter, DB2DataReader, DB2DataSource, DB2Parameter, etc. Because of this you can now access DB2 data in an easy, familiar way.

For example:

using (DB2Connection conn = new DB2Connection("...")) {
	string select = "SELECT * FROM DB2Table";
	DB2Command cmd = new DB2Command(select, conn);
	DB2DataAdapter adapter = new DB2DataAdapter(cmd);
	using (adapter) {
		DataTable table = new DataTable();
		adapter.Fill(table);		
		...
	}
}

More Than Read-Only: Full Update/CRUD Support

IBM DB2 Data Provider goes beyond read-only functionality to deliver full support for Create, Read, Update, and Delete operations (CRUD). Your end-users can interact with the data presented by the IBM DB2 Data Provider as easily as interacting with a database table. 

using (DB2Connection connection = new DB2Connection(connectionString)) {
	DB2DataAdapter dataAdapter = new DB2DataAdapter(
	"SELECT Id, Where FROM DB2Table", connection);
  
	dataAdapter.UpdateCommand = new DB2Command(
		"UPDATE DB2Table SET Where = @Where " +
		"WHERE Id = @ID", connection);

	dataAdapter.UpdateCommand.Parameters.AddWithValue("@Where", "Where");
	dataAdapter.UpdateCommand.Parameters.AddWithValue("@Id", "80000173-1387137645");

	DataTable DB2TableTable = new DataTable();
	dataAdapter.Fill(DB2TableTable);

	DataRow firstrow = DB2TableTable.Rows[0];
	firstrow["Where"] = "New Location";

	dataAdapter.Update(DB2TableTable);
}

ADO.NET Provider Performance

With traditional approaches to remote access, performance bottlenecks can spell disaster for applications. Regardless if an application is created for internal use, a commercial project, web, or mobile application, slow performance can rapidly lead to project failure. Accessing data from any remote source has the potential to create these problems. Common issues include:

  1. Network Connections - Slow network connections and latency issues are common in mobile applications.
  2. Service Delays - Delays due to service interruptions, resulting in server hardware or software updates.
  3. Large Data - Intentional or unintentional requests for large amounts of data.
  4. Disconnects - Complete loss of network connectivity.

The CData ADO.NET Provider for IBM DB2 solves many of these issues with support for replication queries that can be used to sync data to local databases, greatly improving the performance and dramatically reduce application bottlenecks.

More information about ADO.NET Provider performance capabilities are available in the included documentation.

Visual Studio Integration & Server Explorer

Working with the new IBM DB2 ADO.NET Provider is easy. As a fully-managed .NET Data Provider, the IBM DB2 Data Provider integrates seamlessly with the Visual Studio development environment as well as any .NET application.

As an ADO.NET Data Provider, IBM DB2 ADO.NET Provider can be used to access and explore IBM DB2 data directly from the Visual Studio Server Explorer.

It's easy. As a standard ADO.NET adapter, developers can connect the Server Explorer to IBM DB2 ADO.NET Provider just like connecting to any standard database.

  • Add a new Data Connection from the Server Explorer and select the IBM DB2 Data Source
  • Configure the basic connection properties to access your IBM DB2 account data.

Explore all of the data available! IBM DB2 ADO.NET Provider makes it easy to access live IBM DB2 data from Visual Studio.

  • After configuring the connection, explore the feeds, views, and services provided by the IBM DB2 Data Source.
  • These constructs return live IBM DB2 data that developers can work with directly from within Visual Studio!

Developer Integration: Databind to DB2

Connecting Web, Desktop, and Mobile .NET applications with IBM DB2 is just like working with SQL Server. It is even possible to integrate IBM DB2 ADO.NET Provider into applications without writing code.

Developers are free to access the IBM DB2 ADO.NET Provider in whatever way they like best. Either visually through the Visual Studio Winforms or Webforms designers, or directly through code.

  • Developers can connect the IBM DB2 Data Source directly to form components by configuring the object's smart tags.
  • Add a new Data Connection from the Server Explorer and select the IBM DB2 Data Source. Then, select the feed, view, or services you would like to connect the object to.

Done! It's just like connecting to SQL Server.

  • Once the object is bound to the data source, applications can easily interact with IBM DB2 data with full read/write (CRUD) support.

Download the DB2 ADO.NET driver today!

download
buy now