What's new in this release? The highlights of Release 7.1.2 are: • New database version support ◦ Apache Hive 0.10 ◦ DB2 UDB V10.1 for Linux, UNIX, and Windows ◦ DB2 V9.8 for Linux, UNIX, and Windows ◦ Greenplum 4.2 ◦ Microsoft SQL Server 2012 ◦ Microsoft Windows Azure for SQL Database ◦ MySQL Enterprise Edition 5.6 ◦ PostgreSQL 9.2 ◦ Salesforce API Version 26 ◦ 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 server 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 ◦ Certified with Cloudera 4.1 ◦ The UserName and Password connection attributes are now required for a connection to HiveServer2 ◦ When connection to HiverServer2, 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. • DB2 Wire Protocol driver enhancements ◦ Certified with DB2 V10.1 for Linux, UNIX, and Windows • Oracle Wire Protocol driver enhancements ◦ 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. • 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. • Greenplum driver enhancements ◦ 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. • Salesforce driver enhancements ◦ Certified with Salesforce API Version 26 ◦ 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. 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