PROGRESS DATADIRECT SQL SERVER ODBC DRIVER

The Most Reliable, Best Performing ODBC Driver for SQL Server

Progress DataDirect's ODBC driver for SQL Server delivers the best performance and scalability for applications connecting to Microsoft SQL Server. One driver simultaneously supports SQL server 7, 2000, 2005, and 2008. Progress DataDirect's ODBC SQL Server driver is available for UNIX and Linux platforms as well as Windows and for 64-bit applications.

PRODUCT OVERVIEW
KEY BENEFITS
KEY FEATURES
COMPETITIVE MATRIX

Progress DataDirect's unique wire protocol ODBC SQL Server driver eliminates the need to connect to the database through components on the database server. This single-tier architecture results in better response time and throughput and reduces the cost of deploying and maintaining applications.

Advantages of Progress DataDirect Driver

Improves the performance and scalability of your applications: Progress DataDirect's ODBC drivers are proven to out-perform competitive drivers, demonstrating marked improvement in response time, throughput, and scalability of your SQL Server applications. The wire protocol architecture of the ODBC SQL Server driver, as well as easy-to-use tuning options, optimizes the rate and efficiency of data transfer. In addition, a high-performance Bulk Load capability enables large amounts of data to be loaded very quickly.
Provides comprehensive coverage from one vendor: Progress DataDirect offers an ODBC driver for SQL Server on every major platform – Windows, Linux and UNIX, including UNIX platforms such as IBM AIX, HP-UX, and Sun Solaris, across a wide range of processor architectures. We also offer a 64-bit wire protocol ODBC driver for SQL Server so your 64-bit applications can take full advantage of faster processing speeds.
Reinforces your security strategy: Progress DataDirect drivers include advanced, industry standard security mechanisms such as SSL data encryption and operating system authentication via Kerberos.
Ensures high availability: Progress DataDirect drives completely manage application failover and balancing of work load without requiring changes to application code or costly server configurations or database clustering technologies.
Makes it easy and cost effective to support multiple databases / database versions: One Progress DataDirect driver supports simultaneous connections to SQL Server 7, 2000, 2005, and 2008, which significantly reduces the costs of deploying and testing applications. This also allows you to consolidate critical business applications onto a single platform. In addition, Progress DataDirect drivers boast numerous interoperability features that simplify the task of supporting other databases in addition to SQL Server, such as Oracle, DB2, Sybase, MySQL, and more.
Reduces the cost and time of deploying and maintaining applications: Progress DataDirect’s wire protocol architecture eliminates the need for additional components on the database server for connectivity. One install contains everything needed to connect to any SQL Server instance. This greatly simplifies deployment and eliminates connectivity issues associated with different versions of SQL Server and its service packs.
Guarantees quality and reliability: Progress DataDirect drivers are quality tested and certified with a wide variety of applications and environments and are proven in hundreds of leading commercial software products and thousands of the most demanding corporate environments.
Reduces total cost of ownership through superior technical support: In contrast to database vendors and other third-party vendors, Progress DataDirect's award-winning support is focused exclusively on data connectivity and includes 24x7 phone, web, email, forum, fax, and an extensive knowledgebase. Resolving data connectivity issues quickly reduces the total cost of ownership of software.

Progress DataDirect features are 100% driver implemented, allowing them to be leveraged quickly without requiring changes to application code or proprietary SQL Server extensions.

Performance	Wire protocol architecture Easy-to-use tuning options and automatic driver tuning via Performance Wizard Bulk Load Load balancing Advanced Connection Pooling Statement pooling Data conversion Socket management Network wire management Batching and throughput optimization
Comprehensive Database / Platform Coverage	Windows and Unix / Linux One driver supports simultaneous connections to SQL Server 7, 2000, 2005, and 2008 64-bit ODBC driver for SQL Server available
Security	Operating system authentication (aka Single Sign-On) via Kerberos SSL data encryption
Enterprise Application Functionality	Application failover Load balancing Windows ODBC Driver Manager for Unix/Linux Unicode and ANSI character sets Stored procedures Built-in debugging capabilities
Interoperability	Interoperability including SQL up-leveling, which simplifies the task of supporting other databases in addition to SQL Server, such as Oracle, DB2, Sybase, MySQL, and more Common architecture across drivers makes it easy to support different databases
Driver Functionality	Stored procedures Scalar and catalog functions Parameter arrays Data type conversions SQL Server 2008 features: Transparent Data Encryption (TDE) Database Compression New data types New Scalar functions and SQL constructs FILESTREAM data type attribute Named Instances support – Allows applications to specify a particular installation of SQL Server Support for SQL Server 2005 data types such as: Varbinary(max), Varchar(max), and XML Support for SQL Server Unicode data types: Nchar, Nvarchar, Ntext, and Nvarchar(max) Support for the SQL Server 2005 transaction isolation levels: Snapshot, Read Committed with Snapshots, and Read Committed with Locks Supports the ability to execute a single SQL statement using multiple rows of values
Quality and Reliability	Quality tested and certified with the Progress DataDirect ODBC Verification Suite (OVS), the largest, most mature ODBC testing infrastructure 100% ODBC specification compliance – leverage SQL Server functionality without proprietary extensions or code

Advantages of Progress DataDirect Driver	Limitations of Microsoft Driver
Best ODBC driver performance Outperforms other drivers because it's optimized to communicate directly with SQL Server using the TDS protocol. Connection tuning options make it easy to tune the driver for maximum performance across a wide variety of application scenarios.	Microsoft's focus is not on ODBC access and therefore their ODBC driver is limited in terms of performance and in the ways that it can be tuned.
UNIX / Linux support Over 10 years ago, Progress DataDirect licensed the source code for the Microsoft ODBC driver for SQL Server to port it to non-Windows platforms. Since that time, Progress DataDirect has leveraged this knowledge and experience to develop the most functionally advanced ODBC driver for SQL Server for platforms such as UNIX and Linux. Progress DataDirect offers an ODBC driver for SQL Server on every major platform – Windows, Linux and UNIX, including UNIX platforms such as IBM AIX, HP-UX, and Sun Solaris, across a wide range of processor architectures. In addition, Progress DataDirect distributes its own ODBC Driver Manager, the industry's most widely deployed driver manager for UNIX and Linux platforms, with every installation.	Microsoft's platform support for its own driver is limited to Windows. As a result, Microsoft licenses Progress DataDirect's SQL Server ODBC driver for use with its applications that deploy on UNIX and Linux.
One driver supports multiple versions of SQL Server Supports simultaneous connections to SQL Server 7, 2000, 2005, and 2008, which significantly reduces the costs of deploying and testing applications. This also allows you to consolidate critical business applications onto a single platform.	Microsoft requires different drivers to support SQL Server 7, 2000, 2005, and 2008. Applications that must access multiple versions of SQL Server must account for differences in these drivers to avoid exposing unexpected behavior to users.
Bulk Load Includes a high-performance bulk load capability for loading large amounts of data into SQL Server the fastest way possible. You can use Progress DataDirect Bulk Load within existing applications without the need for application code changes, an additional bulk load tool from Microsoft.	Requires deploying Microsoft's bulk load tool, bcp, which is slower than Progress DataDirect Bulk Load and restricts the platform support of bulk load to Windows-only. In addition, proprietary application code changes and data input formats are required to invoke this command-line tool.
Advanced security features Our drivers include industry-standard security mechanisms: SSL data encryption to secure the integrity of your data and provide client/server authentication Operating system authentication via Kerberos or NTLM, allowing you to include database access in a Single Sign-On environment.	Microsoft's support for these security features is limited to applications deployed on Windows only.
Application failover and load balancing The driver completely manages application failover, disaster recovery, and balancing of work load without requiring changes to application code or database configuration.	Microsoft doesn't offer support for failover and load balancing in their driver.
Reliability for demanding production environments Quality tested and certified with a wide variety of applications and environments using the DataDirect ODBC Verification Suite (OVS), the largest, most mature ODBC testing infrastructure. More mission-critical applications depend on DataDirect for reliable data access than on any other vendor's software.	Microsoft's testing infrastructure for data connectivity is unknown.
Complete interoperability between databases SQL Up-leveling and other interoperability features such as standard escape syntax make it easy and cost-effective for an application to support multiple databases (SQL Server, Oracle, DB2, Sybase, and more). Applications can access different relational databases with less code and less maintenance, ensuring consistent functionality and behavior regardless of the database.	Interoperability is not provided because the Microsoft driver is designed to work only with SQL Server. Organizations that need to access more than SQL Server will be forced to use drivers from different vendors, requiring a learning curve to account for the proprietary feature support of each one.
Comprehensive Technical Support Focused on database connectivity, our award-winning support includes 24x7 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.	Because Microsoft is not focused primarily on data connectivity, troubleshooting will be more difficult and take longer.

SQL SERVER CUSTOMERS

Select Comfort
Performance and reliability

Perceptive Software
Multiple database support

Products

PROGRESS DATADIRECT SQL SERVER ODBC DRIVER

The Most Reliable, Best Performing ODBC Driver for SQL Server

RELATED LINKS

SQL SERVER CUSTOMERS