……………………………………………….Expertise in .NET Technologies

DataDirect ADO.NET Data Provider for DB2

Posted by Ravi Varma Thumati on October 8, 2009

The only 100% managed code data provider for .NET applications connecting to DB2:

  • Best application performance and scalability for DB2
  • Eliminates the need for costly and cumbersome IBM DB2 Connect client libraries
  • Flexible and cost effective deployment
  • Robust security features

DataDirect Connect for ADO.NET has been thoroughly proven in data transaction intensive environments in which high performance, stability and security are mission-critical requirements.

Key Benefits

Improves the performance and scalability of your applications DataDirect ADO.NET data providers outperform other providers in throughput capacity, as well as memory and CPU utilization.

Only DataDirect providers are 100% managed, making no calls outside the .NET runtime environment. This dramatically improves application performance and scalability by eliminating reliance on components that reside outside the managed environment.

DataDirect providers also include a high-performance Bulk Load capability for loading large amounts of data into DB2 very quickly, which doesn’t require application code changes or additional bulk load tools.

Provides comprehensive database/platform coverage from one vendor DataDirect can serve all your data connectivity needs, for any API (JDBC, ODBC, .NET) for any major database—SQL Server, Oracle, DB2, Sybase, and more, while offering extensive platform support.
Enables faster, more flexible deployment Because it doesn’t require database client libraries, the DataDirect provider supports “side-by-side” installation, allowing you to run multiple applications using different versions of the database on the same machine. This eliminates the need to re-qualify unrelated applications if an application is updated.
Makes it easy and cost effective to support multiple databases and database versions One DataDirect provider supports simultaneous connections to all DB2 versions and platforms: DB2 UDB 7.x, 8.x, and 9.x for Linux, Windows, UNIX, and z/OS; and DB2 UDB V5R1, 2, 3, and 4 for iSeries). This significantly reduces the cost of deploying and testing applications against multiple versions of DB2 and its client libraries.
Enables single sign-on and end-to-end data encryption DataDirect providers include advanced, industry-standard security mechanisms:

  • SSL data encryption to secure the integrity of your data and provide client/server authentication
  • Operating system authentication via Kerberos, allowing you to include database access in a Single Sign-On environment

In addition, 100% managed code ensures no reliance on components outside the .NET managed environment, allowing the application to take full advantage of the security controls in .NET.

Guarantees reliability for demanding production environments DataDirect providers are quality tested and certified using our extensive ADO.NET Verification Suite (ADOVS), verifying all supported Windows platforms and Oracle database versions. We also test ADO.NET conformance using the Microsoft LTM (Local Test Manager). This comprehensive testing ensures that you can develop the most robust DB2 .NET application.
Offers 100% specification compliance and robust functionality DataDirect providers are certified for use with .NET Framework versions 2.0, 3.0 and 3.5 (32-bit and 64-bit), are fully compliant with ADO.NET 2.0, and offer advanced functionality such as:

  • Connection failover and client load balancing
  • Numerous connection tuning options
  • Distributed transactions
  • ClickOnce deployment (formerly “No Touch”)
  • Support for Microsoft Enterprise Library Data Access (DAAB) Application Block
  • Visual development aids that integrate seamlessly with Visual Studio 2008
  • Built-in debugging tools and tracing capabilities
Reduces total cost of ownership through superior technical support Focused on database connectivity, our award-winning support includes 24×7 phone, web, email, forum, fax, and an extensive knowledgebase.

Superior technical support is essential to resolve data connectivity issues quickly, thereby reducing the total cost of ownership of software.

Additional DataDirect Data Provider Features for DB2:

  • XA transactions
  • 2 MB SQL Statements
  • 128 bit column names
  • Supports returning errors from stored procedures and SQL statements using the RAISE_ERROR function
  • Use Current Schema – Can restrict results from a meta-data collections query to a specific database schema
  • Statement caching for increased efficiency between DB2 database and .NET application
  • Additional connection tuning options – Array Send Size, Socket Send Buffer Size, Socket Receive Buffer Size
  • Workload Manager (WLM) support – Enterprise applications experience the greatest benefit of this feature, which allows a user to specify performance goals and priorities for connections created through our provider. Available for DB2 on LUW and z/OS.
  • Expired password support – To better support situations where a password is expired, you can provide an alternate password as part of the connection string. If the primary password has been expired, the provider will attempt to connect using the alternate password.
  • Connection Statistics and Client Monitoring Information



Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: