Call us on: +44 (0)1364 654100

Home

 » 

Catalogue

 » 

IT

 » 

Database

 » 

Connectivity

 » 

DataDirect Connect® For ADO.NET

No Image Available

Request a call back about this product

DataDirect Connect® For ADO.NET

Published By:  Progress DataDirect


Delivers a flexible, secure connection to: Oracle, DB2, Microsoft SQL Server and Sybase.

Product Variants

For advice on this product or for a quote, please contact us or click here to request a call back.

Description
New Features
Licensing

DataDirect Connect for ADO.NET provides unmatched interoperability between database versions and vendors by abstracting differences between different databases and database versions. Developers can use Connect for ADO.NET to write and deploy applications that connect to multiple databases while reducing the amount of code required to utilize features specific to each database.

DataDirect Connect for ADO.NET offers robust security features such as operating system authentication for creating a Single Sign-On environment and SSL to protect critical data.

What's New in DataDirect for ADO.NET 3.2

DataDirect Connect for ADO.NET is the industry's only suite of ADO.NET data providers with a 100% managed architecture, eliminating the need for database clients, boosting performance, and delivering a flexible, secure connection to Oracle, DB2, Sybase and Microsoft SQL Server. Release 3.2 contains features designed to:

  • Provide a consistent way to perform ¿bulk load¿ operations in .NET across all supported databases
  • Deliver significantly improved performance without requiring application code changes
  • Allow for faster, simpler runtime ADO.NET provider tune-ability and troubleshooting

DataDirect Bulk Load

A persistent data connectivity challenge is the need to load very large amounts of data into relational databases as fast as possible. DataDirect Bulk Load is the first independent, standards-based implementation of bulk load functionality that provides consistent semantics across all supported databases. It is available in this release for use with all supported databases: Oracle, DB2, Sybase, and SQL Server.

New Performance Features

Available with this release, existing applications can immediately benefit from these features as no code changes are required to use them:

  • Statement caching ¿ Many different types of applications can benefit from the increased efficiency afforded by enabling the provider connection options associated with this feature.
  • Additional performance tuning options ¿ The Array Send Size, Socket Send Buffer Size, and Socket Receive Buffer Size connection options allow for greater application-database communication efficiency for many application use cases.

Connection Statistics and Client Monitoring Information

  • Connection Statistics ¿ Most ADO.NET provider performance tuning, debugging, and analysis is pre-emptive and happens only during the application design and test phases. Once in production, however, very little information is available to troubleshoot runtime provider problems.

With this release, DataDirect provides a consistent set of statistical counters across all supported databases, which allows for reactive configuration or tuning of a provider based on what is actually happening with the provider in production. This in turn allows customers to implement strategies such as 24x7 application performance analysis, incident detection and notification, or trend analysis, which are key for critical applications.

  • Client Monitoring Information ¿ Available in this release, all DataDirect ADO.NET providers support a consistent way to set client information such as application name, client user, and client host name for easier runtime troubleshooting. No application changes are required to leverage this feature due to its implementation through provider connection options.

New DB2 Provider Features

  • Support for DataDirect Bulk Load
  • Statement caching support
  • Additional performance tuning options - Array Send Size, Socket Send Buffer Size, Socket Receive Buffer Size
  • Connection Statistics support
  • Client Monitoring Information support
  • Workload Manager (WLM) support ¿ Enterprise applications and databases will 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.
  • SSL support - Support for the established standard for encrypting network communications is now available for DB2 on LUW and z/OS.
  • DB2 iSeries V6R1 support ¿ Support for the latest DB2 iSeries version and associated features are now available with this release. Includes support for XA transactions (distributed transactions) to DB2 V6R1 and support for the new DECFLOAT data type.
  • DB2 LUW V9.5 feature support ¿ Support for the new features available with the latest version of the DB2 LUW is now available with this release. Includes support for DB2 Database Compression, updating XML documents via XQuery expressions, larger identifier lengths, and the new DECFLOAT data type.

New Oracle Provider Features

  • Support for DataDirect Bulk Load
  • Statement caching support
  • Additional performance tuning options - Array Send Size, Socket Send Buffer Size, Socket Receive Buffer Size
  • Connection Statistics support
  • Client Monitoring Information support
  • Server-side result set caching ¿ Available with this release, this feature can boost performance for specific application operations connecting to Oracle 11g. Unlike the Oracle ODP.NET provider, no application changes are required to leverage this feature due to its implementation through provider connection options.
  • Transparent Data and Tablespace Encryption support ¿ Available in this release, DataDirect has certified that these security-related Oracle 11g database features will work correctly with the Oracle provider.
  • SECUREFILE LOB Storage support ¿ Available in this release, DataDirect has certified that this Oracle 11g performance enhancement for LOB handling will work correctly with the Oracle provider.
  • Transaction Timeout ¿ Available in this release, this feature allows for the configuration of a specific transaction timeout time. No application changes are required to leverage this feature due to its implementation through provider connection options.
  • Support for Oracle 11g R2

New SQL Server Provider Features

  • Support for DataDirect Bulk Load
  • Support for SQL Server 2008

New Sybase Provider Features

  • Support for DataDirect Bulk Load
  • Statement caching support
  • Additional performance tuning options - Socket Send Buffer Size, Socket Receive Buffer Size
  • Connection Statistics support

New Database Versions Supported

  • Oracle 11g R2
  • SQL Server 2008

New Platform Support

  • Windows 2008

Licensing Options for DataDirect Technologies Products
DataDirect Technologies offers two types of licensing options for this product: Workstation, and Server licenses. If you are unsure as to which type of license you require, please contact DataDirect Technologies and we will help you determine the appropriate license type. In addition to ensuring that you are licensed properly based on your deployment, the server driver offers functionality critical for success in high performance server-based applications.

Workstation Basis. If the Product is licensed on a Workstation basis, each Workstation using or accessing the Product must be licensed. A license must be purchased for each Workstation using or accessing the Product. A ¿Workstation¿ shall be defined as a computer that is operated, either attended or via remote access, by one person at a time, and cannot be used by more than one person, directly or indirectly, simultaneously. In no event shall the number of workstations utilizing or accessing the Product exceed the number of Workstations identified in the Order Letter.

Server Basis. If the Product is licensed on a Server basis, then a license fee must be paid for the maximum number of processors (¿CPUs¿) utilized by the Server whether or not such access is simultaneous or consecutive. Servers utilizing dual core processing (or multiple core processing) or other multi-processor technology shall have each core processor count as one (1) CPU. The Product may only be used by server-based applications running on that server accessed by other computers and may not be installed via file sharing on a local area network file system. A ¿Server¿ shall be defined as a logical computer with one or more CPUs on which the Product resides, along with the applications utilizing the Product, and which can be accessed by other computers. The term ¿Server¿ includes, but is not limited to, web servers, batch servers and application servers.

SupportLink is mandatory on all supported versions and must be included on all quotations. See the section on SupportLink for the definition of supported versions.

Shopping Basket
    0 Item(s)
    Total:
    0.00


    View and amend your basket
         
    ISV Royalty Licensing
    SSN Banner