SYBASE IQ ODBC DRIVER
The Best Performing Sybase IQ ODBC Driver
Wire Protocol vs. Classic Architecture 
Click to Enlarge
For organizations licensing Sybase IQ, the Progress DataDirect Connect XE for ODBC driver delivers industry-best Platinum ODBC performance and functionality when connecting to the Sybase IQ data warehouse. DataDirect Connect XE for ODBC:
- Provides Windows applications the benefit of Sybase IQ scalability from tens to hundreds of terabytes
- Improves runtime performance for Windows applications for highly complex queries in your driver
- Leverages advanced driver functionality like failover
- Extends and improves ROI of existing Business Intelligence investments
Try it now – Sybase IQ ODBC Driver Download.
No matter what the application platform or hardware – Progress DataDirect Connect XE for ODBC ensures that distributed and grid-computing systems have uninterrupted access to business-critical data.
| Improves the performance and scalability of your applications | DataDirect’s Sybase IQ ODBC driver delivers the faster response times and massive scalability needed for critical business intelligence solutions. Our drivers outperform competitive drivers in throughput, CPU efficiency, and memory usage. |
| Provides comprehensive coverage from one vendor | Leverage your BI application deployments from whatever platform they’re located on. Only DataDirect offers a SybaseIQ ODBC driver on every major platform – Windows (including v7), UNIX and Linux, including UNIX platforms such as IBM AIX, HP-UX, and Sun Solaris, across a wide range of processor architectures. A 64 bit ODBC driver enables your 64-bit applications to take full advantage of the faster processing speeds. |
| Makes it easy and cost effective to support multiple databases / database versions | SQL up-leveling and other interoperability features allow applications to support multiple data sources (Sybase IQ, Oracle, SQL Server, DB2, Sybase, and more). |
| Offers 100% specification compliance and robust functionality | DataDirect’s Sybase IQ ODBC driver provides the same advanced feature set of our industry-standard ODBC drivers, offering robust functionality, such as single sign-on, data encryption, and extensive Unicode support. |
| Guarantees reliability for demanding production environments | DataDirect’s Sybase IQ ODBC driver is 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. |
| Reduces total cost of ownership through superior technical support | In contrast to database vendors and other third-party vendors, DataDirect's award-winning support is focused exclusively on data connectivity and includes 24x7 phone, web, email, forum, and an extensive knowledgebase. Resolving data connectivity issues quickly reduces the total cost of ownership of software. |
DataDirect Platinum ODBC product features are 100% driver implemented, which means they do not require changes to application code or proprietary extensions to be leveraged quickly.
- Robust Bulk Load capabilities
- Load balancing
- Built-in debugging capabilities
- Enterprise-quality driver logging
- Advanced Connection Pooling
- Statement pooling
- Data conversion
- Socket management
- Network wire management
- Batching and throughput optimization
Comprehensive Database / Platform Coverage
- Supports Windows, Linux, and Unix platforms, including Unix platforms such as IBM AIX, HP-UX, and Sun Solaris across a wide range of processor architectures
- 64-bit ODBC driver for SybaseIQ available
Enterprise Application Functionality
- Application failover
- Windows ODBC Driver Manager for Unix/Linux
- Extensive Unicode application and data support
- Stored procedures
- SSL data encryption with client authentication support
Interoperability
- Interoperability, including SQL up-leveling, which simplifies the task of supporting other databases in addition to Sybase IQ, such as Oracle, DB2, SQL Server, Sybase, and more
- Common architecture across drivers makes it easy to support different databases
Quality and Reliability
- Quality tested and certified with the DataDirect ODBC Verification Suite (OVS), the largest, most mature ODBC testing infrastructure
- 100% ODBC specification compliance
Additional Sybase IQ ODBC Driver Functionality
- Supports InnoDB, MyISAM, and Memory (HEAP) storage engines
- Complete compatibility with DataDirect ODBC Driver Manager
- SQLCancel support
- Query Timeout support
- Login Timeout support
- ODBC 3.0 features
- Stored procedures
- Scalar functions
- Data type conversions
- Catalog functions
- Parameter arrays
