DataDirect ADO.NET Data Providers for Sybase

DataDirect Connect for ADO.NET offers Sybase database developers and application architects a feature rich, reliable and secure data connectivity solution that is simple to implement and easy to manage — even when applications require connectivity across multiple database versions or platforms.

DataDirect's ADO.NET data provider supports Sybase 11.x, 12.x, and 15.0 versions, and is the only 100% managed code data provider available. As a 100% managed code provider, the Sybase client libraries are not required, eliminating the deployment, maintenance and performance costs associated with the client, allowing all of the database processing to occur within the CLR (Common Language Runtime). These features significantly improve performance, reliability and application security.

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.

Ready to try DataDirect Connect for ADO.NET?

Download | Learn More

To learn more about DataDirect's ADO.NET data provider for Sybase, review the materials below and follow the related links for deeper technical information. Also see the competitive advantage matrix, which compares DataDirect 100% managed data providers with competing data providers.

DataDirect Connect for ADO.NET / Sybase Topics:

Why Choose DataDirect ADO.NET Data Providers for Sybase?

DataDirect Connect for ADO.NET is the only 100% managed code provider for Sybase. All other options, including the Sybase ASE data provider, do not employ 100% managed code.

Because the DataDirect data provider is 100% managed code, your .NET assemblies run inside the .NET CLR (Common Language Runtime), allowing your application to take advantage of the numerous built-in services that enhance performance.

By contrast, Sybase providers bridge into unmanaged code running outside the CLR, adversely affecting performance since the .NET infrastructure has to check each call made to the native database client.

See the competitive advantage matrix, which compares the performance and reliability advantages of using a 100% managed code data provider like DataDirect Connect for ADO.NET.

Fully supports all Sybase database versions from a single provider

This eliminates the need to test, deploy and maintain Sybase client software (Open Client), which can escalate costs in environments using multiple Sybase versions. DataDirect's approach eliminates the need to test and certify each application deployed on a machine, each time the native client is updated.

Flexible deployment support

Since DataDirect's Connect for ADO.NET does not rely on the Sybase client software (Open Client), DataDirect eliminates versioning issues associated with database client libraries and provides a great deal of flexibility in terms of deployment options. With DataDirect, applications can be deployed “side by side” using different versions of the ADO.NET provider allowing different versions of Sybase to be accessed from the same application host machine. This eliminates the constraint in the Sybase solution that forces all applications to use the same version of the native database client which is effectively “hard wired” to a specific Sybase version.

DataDirect’s approach eliminates the need to re-qualify all applications due to the fact that an unrelated application is using a different version of the provider / database and provides greater flexibility in terms of development, QA and deployment schedules.

In addition, DataDirect is the only Sybase data provider that supports all Sybase versions in a single provider assembly. This approach reduces the cost associated with developing and deploying applications vs. Sybase’s approach that relies on native database clients that are “hard wired” to specific versions of the Sybase database.

Supports Microsoft .NET Framework 2.0, 3.0, and 3.5 / ADO.NET 2.0

The DataDirect Sybase data provider is certified for use with .NET Framework versions 2.0, 3.0 and 3.5 (32-bit and 64-bit) and conforms to the ADO.NET 2.0 specification. ADO.NET 2.0 provides support for a Common Programming Model that makes it easy to write interoperable code for various target databases.

Visual Studio 2008 Developer Tools

Only DataDirect offers visual development aids that integrate seamlessly into the Visual Studio 2008 environment. These tools provide a consistent level of functionality across the different database types and graphical dialogs that guide the developer in the connection process.

ClickOnce Deployment

The DataDirect provider can be distributed along with the application via the .NET "ClickOnce" deployment capability. (Formerly referred to as "No-Touch Deployment" in the .NET 1.x Framework.)

Sybase providers require manual deployment to each server or workstation hosting the application.

Quality and Reliability

Superior Performance Testing & Benchmarking

DataDirect's .NET testing infrastructure [the ADO.NET Verification Suite (ADOVS)] is designed to ensure quality and reliability, verify conformance using the Microsoft LTM (Local Test Manager), and rigorously test against all supported Sybase database versions. This comprehensive testing ensures that you can develop the most robust Sybase .NET application possible within your environment.

Support for the Microsoft Enterprise Library Data Access Application Block (DAAB)

Simplifies application development by wrapping common data access tasks into portable code that supports multiple applications and databases. DAAB classes provide access to the most frequently used features in ADO.NET greatly improving developer productivity. DAAB support requires Release 3.1, SP1.

Enhanced support for Meta-data Schema Options

In order to handle meta-data queries that result in a large amount of information, DataDirect now provides tunable and fine-grained control of what meta-data is returned to the ADO.NET provider to the application. The developer can configure whether specific collections (e.g., Descriptions, Synonyms, etc.) are returned as the result of a DBCommand.GetSchema() method call. This capability requires Release 3.1, SP 1.

Improved Integration with Visual Studio 2005

DataDirect has updated its support for Visual Studio 2005, including integration of the DataDirect Performance Tuning Wizards, DBA tools including Table and View Wizards, as well as developer aids with standard Templates and Toolkits. This capability requires Release 3.1, SP 1.

Interoperability

DataDirect Connect for ADO.NET enables applications to access multiple databases with fewer lines of code and less maintenance, ensuring consistent functionality and performance, regardless of the database.

Data Direct’s ADO.NET data provider includes interoperability features such as a common code base across all providers; standard escape syntax for stored procedures, outer joins, scalar functions, and date, time and timestamps. Additional functionality includes ANSI standard parameter markers, standardized error code mapping and SQL leveling. DataDirect's ADO.NET data provider also supports provider-neutral error objects, standardized error code mappings and common ways to specify arrays of parameters for use.

By contrast, Sybase's data provider is specific to the Sybase 12.x database; interoperability is not provided across the entire Sybase product line, let alone support for other database versions such as Oracle, DB2 and SQL Server.

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, including Sybase.

ClickOnce Deployment

ClickOnce Deployment is a feature of the .NET Framework that lets you package Windows Forms applications so they can be distributed with a minimum of work. Like browser-based application deployment, ClickOnce Deployment lets clients download the assemblies they need from a remote Web server.

Only 100% managed code solutions like DataDirect Connect for ADO.NET, offers the ability to deploy the data providers along with the application code. Sybase providers require manual effort for the initial installation and ongoing maintenance of the data access components.

Connection Pooling

Connection pooling in ADO.NET is not provided by the core components of the .NET Framework. It must be implemented in the .NET data provider itself. All DataDirect .NET data providers provide the same connection pooling functionality.

By thoughtfully handling connection management before implementation of the ADO.NET provider, improved application performance and maintainability can be substantially improved.

Connection Failover and Client Load Balancing

It is important to ensure that the data on which your critical .NET application depends is always available. "Connection failover" and "connection retry" are two useful features that are available in the DataDirect Connect for ADO.NET data provider.

"Connection failover" allows an application to connect to an alternate (or backup) database server if the primary database server is unavailable.

"Connection retry" defines the number of times that the data provider attempts to connect to the primary (and, if configured, alternate or back up) database servers after the first unsuccessful connection attempt. "Connection retry" can be an important strategy for seamless system recovery.

Distributed Transactions

If your .NET application needs to connect to more than one database, you need to use distributed transactions (application code that relies on multiple data sources). The DataDirect Connect for ADO.NET data provider supports distributed transactions using the Microsoft Distributed Transaction Coordinator (MS DTC).

By contrast, Sybase's provider does not support distributed transactions.

Operating System (OS) Authentication (aka Single Sign-On/Kerberos)

OS authentication is a trusted third-party authentication service that verifies user identities. The latest release of DataDirect Connect for ADO.NET data providers support NTLM, which delivers a session security mechanism that provides for message confidentiality (encryption) and integrity (signing). Kerberos is a variety of NTLM.

This feature can be used to integrate the authentication of users for an application with the authentication mechanisms provided by the environment the application runs in. Organizations can create a Single Sign-On environment that bolsters security, eliminates the need for users to log in separately for each application, and reduces the costs associated with managing user accounts. DataDirect's OS authentication features allow the ADO.NET Sybase data provider to integrate seamlessly into that environment.

The following authentication features are supported:

  • Delegated credentials – Provides the ability for the application to act on behalf of the user. For web-based applications, the application or web server can use the delegated credential that represents the user vs. the credential that represents the server administrator. This bolsters security because the application can base permissions on the actual end-user. In addition, the application audit trail can associate usage with the end-user vs. a generic system administrator ID.
  • Re-authentication – DataDirect provides the ability to re-associate a pooled connection with a different authenticated user. Applications that use connection pooling can use this feature to more efficiently re-use connections while minimizing the number of connections required in the pool.
  • Comprehensive KDC (Kerberos Key Distribution Center) support– Includes support for both Active Directory and MIT.

Support for Secure Socket Layer (SSL) Encryption

SSL is an industry-standard protocol for sending encrypted data over database connections. SSL secures the integrity of your Sybase data by encrypting information and providing client/server authentication. DataDirect Connect for ADO.NET Sybase data providers support SSL to protect data that is transmitted between the database and the application, data that could otherwise be compromised.

Superior Performance and Scalability

DataDirect's ADO.NET data providers are proven in production scenarios and benchmark tests to be significantly faster and more scalable and more stable than Sybase providers. In some scenarios, the DataDirect solution has significantly decreased the number of servers required to support a multi-tier application. Benchmark results show that for queries that select a large number of rows, the DataDirect driver performs from 50% to 315% better as the number of threads are scaled in the test.

In addition, through the use of multiple connection options available through the use of the DataDirect provider, any .NET application can benefit because no code changes are required.

Performance Tuning Wizard

DataDirect's ADO.NET providers include a simple-to-use wizard that automatically generates the connection properties needed to configure your ADO.NET data provider for optimal performance.

The Performance Tuning Wizard covers all application characteristics that affect performance, including database type, select statement characteristics, stored procedures usage, transaction characteristics, scrollable result sets, etc.

Performance Tuning and Testing

Our experienced staff employs a wide variety of tests designed to exercise the data provider, not the database, so provider execution is isolated and measured. Tests performed include every area of functionality in which high performance is expected, including; inserts, updates, deletes, and selects. Other tuning tests include very high volume and batch transactions, as well as data type conversion and parameter testing.

Scalability Testing

To test for scalability, we start with one thread and increase the thread count until either the client-side hardware or the server-side hardware reaches saturation. We are always striving to improve over our previous product release, and we look for factors such as good response time, efficient use of network traffic, disk I/O usage and efficient use of memory.

Ready to try DataDirect Connect for ADO.NET?

Download | Learn More