skip to main content
What's new in this release?
  
What's new in this release?
The highlights of Release 7.1.3 are:
*New database version support
Apache Hive 0.10, 0.11, and 0.12
DB2 UDB V10.1 for Linux, UNIX, and Windows
DB2 V9.8, V10.5 for Linux, UNIX, and Windows (LUW)
Greenplum 4.2
Informix Dynamic Server 12.1
Microsoft SQL Server 2012
Microsoft Windows Azure for SQL Database
MySQL Enterprise Edition 5.6
OpenEdge 11.1, 11.2, and 11.3
Oracle 12c R1 (12.1)
Pivotal HAWQ 1.1
PostgreSQL 9.2
Salesforce API Version 26, 27, 28
Sybase IQ Server 15.4
Teradata 14.0
*New operating system version support
Oracle Solaris 11.1
Red Hat Linux 6.3
Windows 8
Windows Server 2012
*New drivers DataDirect Connect XE and DataDirect Connect64 XE for ODBC
Driver for Apache Hive
Supported with the following Hive versions
Amazon Elastic MapReduce (Amazon EMR)
Apache Hadoop Hive
Cloudera's Distribution Including Apache Hadoop (CDH)
MapR Distribution for Apache Hadoop
Returns result set metadata for parameterized statements that have been prepared but not yet executed.
Supports parameter arrays, processing the arrays as a seeries of executions, one execution for each row in the array.
Provides a connection option that allows you to configure the driver to report that it supports transactions, although Hive does not support transactions. This provides a workaround for applications that do not operate with a driver that reports that transactions are not supported.
Supports the following standard SQL functionality:
Create Index, Create Table, and Create View
Insert, Update, and Delete
Drop Index, Drop Table, and Drop View
Impala Wire Protocol
Certified with Cloudera Impala 1.0 database servers and formally certified with the following file formats and storage handlers:
File Formats:
Parquet
TextFile
Storage Handlers:
HBase
Returns result set metadata for parameterized statements that have been prepared by not yet executed.
Supports parameter arrays, processing the arrays as a series of executions, one execution for each row in the array.
Provides a connection option that allows you to configure the driver to report that it supports transactions, although Impala does not support transactions. This provides a workaround for applications that do not operate with a driver that reports that transcations are not supported.
Provides a connection option that allows you to set a default limit for the number of rows returned when an ORDER BY clause is submitted. This provides a workaround for applications that are not compatible with Impala's requirement that ORDER BY clauses limit the number of rows returned.
Supports the following standard SQL functionality:
Create Index and Create Table
Insert, Update, and Delete
Drop Index and Drop Table
*Support for setting the value of undocumented connection options using the setup dialog for the following drivers on Windows:
DB2 Wire Protocol
Driver for Apache Hive
MySQL Wire Protocol
Greenplum Wire Protocol
Oracle Wire Protocol
Salesforce
PostgreSQL Wire Protocol
Sybase IQ Wire Protocol
Progress OpenEdge Wire Protocol
SQL Server Wire Protocol
Sybase Wire Protocol
Oracle
Impala Wire Protocol
*Driver for Apache Hive enhancements since General Availability
Added support for HiverServer2
Certified with Hive 0.10, 0.11, 0.12
Certified with Cloudera 4.1, 4.2, 4.5
Certified with Hortonworks 1.3, 2.0
The UserName and Password connection attributes are now required for a connection to HiveServer2
When connection to HiveServer2, simultaneous connections per port are supported
The new WireProtocolVersion connection attribute specifies the version of the HiveServer to which the driver will connect.
The String Describe Type connection option now allows you to describe string columns as SQL_WLONGVARCHAR or SQL_WVARCHAR.
The Use Native Catalog Function connection option allows you to specify whether the driver uses native catalog functions to retrieve information returned by the SQLTables, SQLColumns, and SQLStatistics catalog functions.
Added support for Kerberos authentication, including the following connection options:
The GSS Client Library connection option now allows you to specify the name of the GSS client library that the driver uses to communicate with the Key Distribution center (KDC).
The Authentication Method connection option now allows you to specify the method the driver uses to authenticate the user to the server when a connection is established.
The Service Principal Name connection option allows you to specify the service principal name to be used by the driver for Kerberos authentication.
*DB2 Wire Protocol driver enhancements
Certified with DB2 V9.8, V10.12, V10.5 for Linux, UNIX, and Windows (LUW)
*Informix driver enhancements
Certified with Informix Dynamic Server 12.1
*Informix Wire Protocol driver enhancements
Certified with Informix Dynamic Server 12.1
*Oracle driver enhancements
Certified with Oracle 12c R1 (12.1)
*Oracle Wire Protocol driver enhancements
Certified with Oracle 12c R1 (12.1)
Oracle Advanced Security support, which can be configured using the following connection options:
Data Integrity Level sets the level of OAS data integrity used for data sent between the driver and database server.
Data Integrity Types specifies one or multiple algorithms to protect against attacks that intercept and modify data being transmitted between the client and server when OAS data integrity is enabled using the Data Integrity Level option.
Encryption Level determines whether data is encrypted and decrypted when transmitted over the network between the driver and database server using OAS encryption.
Encryption Types specifies one or multiple algorithms to use if OAS encryption is enabled using the Encryption Level property.
Modified to support all Oracle 11g R2 Kerberos encryption algorithms.
*Progress OpenEdge driver enhancements
Certified with OpenEdge 11.1, 11.2, 11.3
*PostgreSQL driver enhancements
Certified with PostgreSQL 9.2
The Max Char Size connection option specifies the maximum size of columns of type SQL_CHAR that the driver describes through result set descriptions and catalog functions.
The Max Long Varchar Size connection option specifies the maximum size of columns of type SQL_LONGVARCHAR that the driver describes through result set descriptions and catalog functions.
The Enable Keyset Cursors connection option enables emulated Keyset cursors to provide scrollable cursors to an ODBC application.
The Keyset Cursor Options connection option determines which columns are used to comprise the keyset that the driver uses to create the initial keyset on which cursor operations are based.
The Encryption Method connection option now supports Request SSL functionality.
*Greenplum driver enhancements
Certified with Pivotal HAWQ 1.1,
Certified with Greenplum 4.2.
The Max Char Size connection option specifies the maximum size of columns of type SQL_VARCHAR that the driver describes through result set descriptions and catalog functions.
The Max Long Varchar Size connection option specifies the maximum size of columns of type SQL_LONGVARCHAR that the driver describes through result set descriptions and catalog functions.
The Enable Keyset Cursors connection option enables emulated Keyset cursors to provide scrollable cursors to an ODBC application.
The Keyset Cursor Options connection option determines which columns are used to comprise the keyset that the driver uses to create the initial keyset on which cursor operations are based.
Added support for SSL encryption with Greenplum 4.2 and higher, including the following connection options:
The Encryption Method connection option now allows you to encrypt data sent between the driver and the database.
The Host Name In Certificate connection option now allows you to specify the host name for certificate validation when SSL encryption and validation are enabled.
The Key Password connection option now allows you to specify the key password that is used to access the individual keys in the keystore file when SSL and SSL client authentication are enabled on the database server.
The Key Store connection option now allows you to specify the directory containing the keystore file that is to be used when SSL and SSL client authentication are enabled on the database server.
The Key Store Password connection option allows you to specify the keystore password that is used to access the keystore file when SSL and SSL client authentication are enabled on the database server.
The Truststore connection option now allows you to specify the directory that contains the truststore file and the truststore file name that is to be used when SSL is enabled and the server authentication is used.
The Truststore Password connection option now allows you to specify the truststore password that is used to access the truststore file when SSL is enabled and the server authentication is used.
The User Name connection option now allows you to specify the user ID that is used to connect to your database.
The Validate Server Certificate connection option now determines whether the driver validates the certificates that are sent by the database server when SSL encryption is enabled.
*MySQL driver enhancements
Certified with MySQL Enterprise Edition 5.6
*Salesforce driver enhancements
Certified with Salesforce API Version 26, 27, and 28.
The Refresh Schema connection option specifies whether the driver automatically refreshes the remote object mapping and other information contained in a remote schema the first time a user connects to the specified embedded database.
The KeywordConflictSuffix key=value pair in the Config Options connection option can specify a string of up to five alphanumeric characters that the driver appends to any object or field name that conflicts with a SQL engine keyword.
Note: For the Salesforce Web Service API versions supported by the Salesforce driver, refer to the product matrix on the Progress DataDirect Web site:
http://www.datadirect.com/products/odbc/matrix/connectodbc.htm
*Sybase IQ Wire Protocol driver enhancements
Certified with Sybase IQ 15.4
*Driver for the Teradata Database enhancements
Certified with Teradata 14.0