1 ATHENA

============================================================================== Magnitude Simba Athena ODBC Data Connector Release Notes ==============================================================================

The release notes provide details of enhancements, features, known issues, and workflow changes in Simba Athena ODBC Connector 1.1.17, as well as the version history.

1.1.17 =======================================================================

Released 2022-05-06

Resolved Issues The following issue has been resolved in Simba Athena ODBC Connector 1.1.17.

  • [AO-525] Addressed security vulnerabilities in URL processing.

Known Issues The following are known issues that you may encounter due to limitations in the data source, the connector, or an application.

  • [AO-479] The connector does not support the SQLDescribeParam API call.

    This is a limitation of the datasource.

Workflow Changes =============================================================

The following changes may disrupt established workflows for the connector.

1.1.13 ————————————————————————

  • Updated GlueEndpointOverride property

    The description of the GlueEndpointOverride property has been updated with new parameters. For more information, see the Installation and Configuration Guide.

  • Updated NonProxyHosts property

    The description of the NonProxyHosts property has been updated with new parameters. For more information, see the Installation and Configuration Guide.

1.1.11 ———————————————————————–

  • [AO-476] Updated Workgroup property

    On Linux, the default value for the Workgroup property has been set to Primary. Previously, the default value was not set. For more information, see the Installation and Configuration Guide.

1.1.7 ————————————————————————

  • [AO-291][AO-340] Removed support for earlier versions of operating systems

    Beginning with this release, the driver no longer supports the following operating systems:

    • macOS 10.9, 10.10, 10.11, and 10.12
    • CentOS 6
    • Red Hat Enterprise Linux (RHEL) 6

    For information about supported operating systems, see the Installation and Configuration Guide.

1.1.2 ————————————————————————

  • [AO-362] Updated MetadataRetrievalMethod property

    The default value for the MetadataRetrievalMethod property has been changed to Auto. Previously, the default value was ProxyAPI. For more information, see the Installation and Configuration Guide.

1.0.3 ————————————————————————

  • Result set streaming support

    Starting with version 1.0.3, the driver uses the result set streaming API to improve the performance of fetching query results. To take advantage of this feature you must include and allow the athena:GetQueryResultsStream action in your IAM policy statement. For details on managing Athena IAM policies, see https://docs.aws.amazon.com/athena/latest/ug/access.html.

Version History ==============================================================

1.1.16 ———————————————————————–

Released 2022-04-06

Enhancements & New Features

  • [AO-520] Enhancements to user-agent string

    The connector now includes additional information in the user-agent string.

  • Updated third-party libraries

    The connector now uses the following third-party libraries:

    • Expat version 2.4.6 (previously 2.2.9)
    • ICU version 58.3x
    • libcurl version 7.74.0
    • OpenSSL version 1.1.1n
  • Timeout error

    The connector now returns an error when the server query status times out.

  • Internal connector improvements

    The connector has been updated with minor internal improvements.

1.1.15 ———————————————————————–

Released 2021-12-17

Resolved Issues The following issue was resolved in Simba Athena ODBC Driver 1.1.15.

  • [AO-478] When SQLParamData() is called a second time, it incorrectly returns SQL_ERROR.

    This issue has been resolved.A second call of SQLParamData() now returns SQL_SUCCESS.

1.1.14 ———————————————————————–

Released 2021-12-03

Enhancements & New Features

  • Verify SSL

    You can now configure the connector to perform SSL certificate verfication via the AWS SDK. To do this, select the Verify SSL check box (set the VerifySSL connection property to 1). For more information, see the Installation and Configuration Guide.

  • Set trusted certificates in UI

    On Windows, you can now set the TrustedCerts connection property via the Advanced Options UI. To do this, type the path and name of the .pem file containing the certificate in the Trusted CA Certificate field. For more information, see the Installation and Configuration Guide.

1.1.13 ———————————————————————–

Released 2021-10-13

Enhancements & New Features

  • Support for Browser SAML authentication

    The connector now supports Browser SAML for authentication. For more information, see the Installation and Configuration Guide.

  • Support for session duration

    You can now set the session duration when using ADFS, Azure AD, or Browser Azure AD for authentication. To do this, type the duration in seconds in the Session Duration field (set the duration property). For more information, see the Installation and Configuration Guide

1.1.12 ———————————————————————–

Released 2021-08-04

Resolved Issues The following issues have been resolved in Simba Athena ODBC Connector 1.1.12.

  • [AO-477] In some cases, SQLPrepare() calls fail when using different connection handles.

    This issue has been resolved. Now, the connector does not concurrently generate the same prepared statement for the connection issued.

  • [AO-480] When using SQLGetInfo(), SQL_ALTER_TABLE returns 0.

    This issue has been resolved. SQL_ALTER_TABLE now returns SQL_AT_ADD_COLUMN_DEFAULT in this case.

  • [AO-485] EndpointOverride is applied to both Athena and Glue.

    This issue has been resolved. EndpointOverride is now correctly applied only to Athena.

1.1.11 ———————————————————————–

Released 2021-07-05

Enhancements & New Features

  • [AO-464] JWT authentication

    The connector can now authenticate the connection using a JSON Web Token (JWT). For more information, see the Installation and Configuration Guide.

1.1.10 ———————————————————————–

Released 2021-06-11

Enhancements & New Features

  • [AO-400][AO-467] Updated query support

    The connector now supports explain statements and parametrized queries.

Resolved Issues The following issue has been resolved in Simba Athena ODBC Connector 1.1.10.

  • [AO-461] The connector does not refresh expired credentials.

1.1.9 ————————————————————————

Released 2021-04-26

Enhancements & New Features

  • [AO-446] NonProxyHost configuration

    You can now connect to certain hosts directly even when a proxy connection has been configured. To do this, type a list of hosts, seperated by a comma ( , ), in the Non Proxy Host field (set the NonProxyHost property). For more information, see the Installation and Configuration Guide.

  • [AO-450] Updated Browser Azure AD property

    When authenticating through Browser Azure AD, the client_secret property is now optional. Previously, the connector required client_secret to be set. For more information, see the Installation and Configuration Guide.

Resolved Issues The following issue has been resolved in Simba Athena ODBC Connector 1.1.9.

  • [AO-440] The connector does not accept NULL values in the aws-sdk output format.

1.1.8 ————————————————————————

Released 2021-02-18

Enhancements & New Features

  • [AO-407] SAML authentication using PingFederate

    The driver can now retrieve and use credentials from the PingFederate credential provider. For more information, see the Installation and Configuration Guide.

  • [AO-425] Updated metadata retrieval

    The driver now retrieves only the required table and schema metadata from the datasource when the exact names of the table and database are provided.

  • [AO-416] Configure Metadata Retrieval Method on Windows

    On Windows, you can now configure the Metadata Retrieval Method by using the ODBC Administrator. For more information, see the Installation and Configuration Guide.

Resolved Issues The following issues have been resolved in Simba Athena ODBC Driver 1.1.8.

  • [AO-423] In some cases, when running a prepare call, the driver includes a semi-colon ( ; ) in the query.

  • [AO-426] In some cases, the driver does not parse multi-line and single-line comments from the query.

1.1.7 ————————————————————————

Released 2020-12-31

Enhancements & New Features

  • [AO-410] SAML authentication using Azure

    The driver can now retrieve and use credentials from an Azure AD or Browser Azure AD credential provider. For more information, see the Installation and Configuration Guide.

Resolved Issues The following issue has been resolved in Simba Athena ODBC Driver 1.1.7.

  • [AO-355] When the key-value pair of a required setting is missing in odbc.ini, iodbctest terminates unexpectedly.

    This issue has been resolved. The driver nows returns a “missing settings” error message.

==============================================================================

Installation and Configuration Guide