TERADATA ODBC DRIVER
Robust Teradata ODBC Driver, Delivering Exceptional Performance and Scalability
Teradata ODBC Driver 
Click to Enlarge
Developed in cooperation with Teradata, the Progress DataDirect ConnectXE ODBC driver for Teradata provides a robust data connectivity solution for high-end, transaction-intensive applications:
- Delivers the faster response times and exceptional scalability needed for business intelligence, data warehousing, and custom applications
- Ensures application availability and user productivity through reliable ODBC Teradata connectivity
- Supports Windows, UNIX and Linux applications
- Supports both 32 bit and 64 bit ODBC connectivity
Try it now – Teradata ODBC Driver Download.
DataDirect's Platinum ODBC driver for Teradata includes the same advanced feature set of our industry-standard ODBC drivers, offering robust functionality, better performance, and higher availability than any other Teradata connectivity solution.
| Improves the performance and scalability of your applications | The DataDirect Connect ODBC driver for Teradata delivers the faster response times and massive scalability needed for business critical enterprise data warehouse applications. |
| Provides comprehensive coverage from one vendor | Only DataDirect offers an ODBC driver for Teradata 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. We also offer a 64 bit ODBC driver so your 64-bit applications can 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 databases (Teradata, Oracle, SQL Server, DB2, Sybase, and more). |
| Offers 100% specification compliance and robust functionality | DataDirect’s ODBC driver for the Teradata database provides the same advanced feature set of our industry-standard ODBC drivers, offering robust functionality, such as single sign-on, data encryption, comprehensive support for Teradata data types, and extensive Unicode support. |
| Guarantees reliability for demanding production environments | DataDirect ODBC drivers are 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 Teradata extensions to be leveraged quickly.
Comprehensive Database / Platform Coverage
- One driver supports simultaneous connections to Teradata 13.0 and V2R6.x
- Supports Windows (including v7), 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 Teradata ODBC driver available
Enterprise Applications
- Windows ODBC Driver Manager for Unix/Linux
- Unicode and ANSI character sets
- Built-in debugging capabilities
- Enterprise-quality driver logging
- Support for Single Sign-On using the following SSO authentication mechanisms: TD1, TD2, LDAP, KRB5, KRB5C, NTLM, NTLMC
Interoperability
- Interoperability, including SQL up-leveling, which simplifies the task of supporting other databases in addition to Teradata, such as Oracle, DB2, SQL Server, MySQL, 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
Driver Teradata ODBC Driver Functionality
- Ability to persist result sets as XML data files
- Supports multiple connections and 16 statements per connection to the Teradata database
THE INDUSTRY STANDARD FOR ODBC DRIVERS
Progress® DataDirect Connect®, Connect XE® and Connect64® for ODBC are the fastest, most comprehensive suite of ODBC drivers for all major databases— Oracle, Microsoft SQL Server, DB2, Salesforce.com, Sybase, Sybase IQ, database. com, force.com, and Progress® OpenEdge® 11 MT. Our unique “wire protocol” design eliminates the need for database client libraries, which greatly simplifies installation and administration and dramatically improves performance. In fact, these clientless drivers even outperform applications that use the database’s native (proprietary) API for database access. Progress DataDirect ODBC drivers are the industry standard for ODBC drivers, providing the advanced functionality, performance, and reliability developers need to quickly deliver high-quality, database-independent applications.
MOST COMPREHENSIVE SUITE OF ODBC DRIVERS FROM ONE VENDOR
You can count on Progress Software for reliable ODBC connectivity regardless of database or platform. Progress DataDirect ODBC drivers support all major databases, on every major platform, across a wide range of processor architectures.
In addition, a single driver supports multiple simultaneous connections to all supported versions of each database. This broadens the versions of databases you can support in a commercial product and eliminates the need to change drivers every time you change database versions in an enterprise environment.
- Supports all major databases— Oracle, Microsoft SQL Server, DB2, Salesforce.com, Sybase, Greenplum, PostgreSQL, MySQL, Informix, Apache Hive and more.
- Supports all major platforms—Windows, UNIX, Linux, and more
- Full 32-bit (Connect for ODBC) and 64-bit (Connect64 for ODBC) ODBC application support
- Each single-tier driver supports multiple database versions:
- Microsoft SQL Server 7, 2000, 2005, 2008, and 2012
- Windows Azure SQL Database
- Oracle (8i, 9i, 10g, and 11g)
- Multiple versions of DB2 running on Windows, UNIX, Linux, z/OS (OS/390), and iSeries (AS/400)
- Sybase 11.x, 12.x, 12.5.x, 15, and Sybase IQ 2 www.
HIGH-PERFORMANCE WIRE PROTOCOL DESIGN
Progress DataDirect ODBC drivers are available as “wire protocol,” meaning that the drivers do not require installation and maintenance of database client software and libraries. This unique wire protocol architecture dramatically improves performance and eliminates the need to install and keep up with the various versions of database client libraries such as Oracle Net (formerly Net8 and SQL*Net) and DB2 Connect for IBM DB2. Other benefits include:
- Simplified installation, configuration, and administration of applications
- Fastest available application data access performance—even faster than using the database’s native interface (such as Oracle OCI)
- Elimination of the need to test and certify against multiple versions of the database client libraries
PROVEN, RELIABLE DRIVERS OFFER BEST-IN-CLASS FUNCTIONALITY
Progress DataDirect ODBC drivers are the most widely used third-party ODBC drivers on the market and are tested under production conditions using the most comprehensive ODBC testing facility in the industry. Progress DataDirect consistently supports the latest, most complete implementation of the ODBC specification and the latest database versions and features, and offers enterprise functionality across all databases such as:
- No database client libraries required through unique wire protocol architecture
- Multiple performance tuning options and a Performance Tuning Wizard to achieve optimal driver performance for any application scenario
- Performance-oriented features such as connection pooling, statement pooling, data conversion, network wire management, and batching and throughput optimization
- 100% driver-implemented application failover and client-side load balancing, which do not require application code changes or expensive clustering software, such as Oracle RAC
- Robust security features such as Kerberos-based operating system (OS) authentication for Single Sign-on (SSL) and SSL-based data encryption over the network
- 100% driver-implemented, high-performance Bulk Load feature which does not require application code changes or database vendor bulk load tools
- Advanced connection pooling which does not require application code changes to enable or configure
- The industry’s best ODBC Driver Manager for UNIX/Linux
- Standards-based implementations of the latest database features and functionality
- Complete, consistent Unicode support across all platforms
- Built-in debugging capabilities
- Certified for leading virtualized environments
To learn more or download a free, 15 day trial of Progress® DataDirect Connect® or Connect64® for ODBC, go to www.progress.com/datadirect
