SQL ODBC Driver

Don’t Let Your SQL ODBC Driver Be a Performance Bottleneck

In SQL ODBC and other distributed application topologies, designers and administrators sometimes underestimate the role that database drivers play in application performance. In fact, the same application running on the same hardware and accessing the same SQL database will perform better or worse depending on the SQL ODBC driver that you use. In some production environments, perceived application sluggishness may actually be the consequence of a poorly performing SQL ODBC driver. Especially for applications that process large data volumes, that serve an extensive user population, or that are instrumental in satisfying service level agreements, choosing a high-performance SQL ODBC driver will be critical to service quality and scalability.

Get Top Performance with a Progress DataDirect SQL ODBC Driver

Progress® DataDirect makes the world’s best-performing database drivers. Benchmarking studies have demonstrated that our DataDirect Connect® line of drivers substantially outperforms competing drivers on key measures including throughput, memory usage, and CPU efficiency. In fact, DataDirect Connect drivers even outperform applications that use the target database’s native API for access. With Connect drivers, you can be sure that your distributed applications are able to run at peak performance.

Several Connect features combine to deliver industry-leading SQL ODBC driver performance:

• DataDirect Connect drivers communicate directly with the database over TCP/IP without need for database client libraries. Doing away with this extra communication layer markedly improves application response time and scalability.
• Our SQL ODBC drivers are engineered to use network, memory, and CPU resources in the most efficient way possible.
• Every Connect SQL ODBC driver includes a range of tunable performance features including connection and statement pooling, bulk loading, batching and throughput optimization, load balancing, and more.

These performance features are standard with all of our database drivers, including our ODBC for SQL Server and other SQL Server drivers, our ADO.NET data providers, and our JDBC SQL Server connection products. Our JDBC SQL Server driver is now available in a Type 5 version that performs more efficiently than conventional Type 4 drivers.

Our Connect line features high-performance drivers for every major connectivity API, operating platform, and database. Whether for SQL ODBC or other data connectivity scenarios,  a better performing driver will translate into faster application response times, reduced hardware requirements, and better scalability.

For enterprises with mainframe data infrastructures, Progress also offers solutions including mainframe business event processing that can help you perform real-time analysis of mainframe business events.

Learn more about our SQL ODBC drivers and other ODBC drivers, or download a driver today and start your free trial period.