15 TERADATA
============================================================================== Magnitude Simba Teradata ODBC Data Connector Release Notes ==============================================================================
The release notes provide details of enhancements, features, known issues, and workflow changes in Simba Teradata ODBC Connector 17.20.00.008, as well as the version history.
17.20.00.008 =================================================================
Released 2022-09-23
Enhancements & New Features
[SENTDO-2481] Browser tab timeout support
The connector can now automatically close the browser tab opened by Federate authentication. To do this, from the EXTERNALBROWSER Tab Timeout drop-down list select Enable and in the Timeout (seconds) field specify the desired time, in seconds, to wait before the browser closes after authenticating (set the BrowserTabTimeout property to amount of time to wait). For more information, see the Installation and Configuration Guide.
[SENTDO-2482] Updated help files
On Windows, the Japanese help files have been updated.
Known Issues The following are known issues that you may encounter due to limitations in the data source, the connector, or an application.
Some custom fields are not supported for SQLGetDescField.
When calling SQLGetDescField, the connector does not support the SQL_DESC_TD_ACTIVITY_TYPE and SQL_DESC_TD_COST_ESTIMATE custom header description fields.
Catalog functions always return ODBC 3.x column names.
For catalog functions, the connector returns the ODBC 3.x column names rather than ODBC 2.x column names, even in an ODBC 2.x environment.
The setting for the SQL_ATTR_ROWS_FETCHED_PTR statement attribute does not persist.
You can set a value by calling SQLSetStmtAttr(SQL_ATTR_ROWS_FETCHED_PTR), but the value is reset after you close the cursor.
In specific cases, during INSERT operations that require the data to be truncated, there is no message indicating that truncation has occurred.
This behavior occurs when both of the following conditions are met:
- The Session Mode option (the SessionMode property) is set to Teradata.
- The connector inserts data that is too large for the target column.
The database truncates the data to fit, but the message indicating that truncation has occurred is not returned. The connector expects the database to report the truncation. However, when Session Mode is set to Teradata, the database does not return the truncation message.
Workflow Changes =============================================================
The following changes may disrupt established workflows for the connector.
17.20.00.006 —————————————————————–
[SENTDO-2352] Updated MaxRespSize property
The default value for the MaxRespSize property is now 524,288 (512K). Previously, it was 65,536 (64K). For more information, see the Installation and Configuration Guide.
Version History ==============================================================
17.20.00.006 —————————————————————–
Released 2022-08-25
Enhancements & New Features
[SENTDO-2477] Upgraded OpenSSL
The connector now uses OpenSSL version 1.1.1q. Previously, the connector used 1.1.1n.
Resolved Issues The following issues have been resolved in Simba Teradata ODBC Connector 17.20.00.006.
[SENTDO-2454] When calling SQLDescribeCol, and the query contains multi-statements (statements separated by semicolons), the connector returns incorrect column names.
[SENTDO-2465] When using Microsoft SSIS to load the connector and the TDWallet value is saved in the DSN, the connector returns an error.
17.20.00.003 —————————————————————–
Released 2022-06-30
Resolved Issues The following issues have been resolved in Simba Teradata ODBC Connector 17.20.00.003.
[SENTDO-1906] When using MS Access queries with DATE criteria, the connector returns an error.
[SENTDO-2441] When Teradata Gateway TLS setting is set to nolegacy mode and the connector SSLMode is set to Allow, the connector is unable to fallback to TLS connection.
17.20.00.001 —————————————————————–
Released 2022-05-25
[SENTDO-2356] Updated GCC suport
On Linux, the connector now supports GCC version 4.8.5.
[SENTDO-2359] Support for UAF functions
The connector now supports the Unbounded Array Framework (UAF) feature.
[SENTDO-2401] Improved performance for connections
The connector now has a better success rate when connecting to the Teradata database if the port status returns incorrectly.
[SENTDO-2405][SENTDO-2408][SENTDO-2395][SENTDO-2431] Upgraded third-party libraries
The connector has been updated to use the following libraries:
- OpenSSL version 1.1.1n (previously 1.1.1l)
- Expat version 2.4.6 (previously 2.2.9)
- TeraSSO version 17.20.00.05
[SENTDO-2378][SENTDO-2379][SENTDO-2399] Updated platform support
The connector now supports the following platforms:
- Ubuntu 20.04
- Windows 11
- Windows Server 2022
For a list of supported platforms, see the Installation and Configuration Guide.
[SENTDO-2383] Federate Authentication port number
When using Federate Authentication and the identity provider URL doesn’t have a port number:
- for https, the connector now uses default port 443
- for HTTP, the connector now uses default port 80
[SENTDO-2383] Improved socket error messages
The socket error messages are now more descriptive for Identity Provider URL and Token endpoint URL.
Resolved Issues The following issues have been resolved in Simba Teradata ODBC Connector 17.20.00.001.
[SENTDO-2032] In some cases, when the connector and TPT coexist in the same process, the connector terminates unexpectedly.
[SENTDO-2275] When calling SQLBindParameter(…, SQL_C_CHAR, SQL_CHAR, …) on a database column with the NUMBER type, the database generates a “22003: Badcharacter in format or data of …” error message.
[SENTDO-2349] When Teradata GSS is configured to Kerberos authentication, but the DSN or connection string specifices a different authentication method, the connector fails to make a connection to the database.
[SENTDO-2385] When using TD Gateway with the EXTERNALBROWSER mechanism and the clientID or Identity Provider is not set, the connector logins and does not return an error.
This issued has been resolved. The connector now returns an error message.
[SENTDO-2403] The connector incorrectly logs the number of detected COP entries from the Teradata database.
[SENTDO-2389] When using SSLMode, the connector does not detect socket level errors and continues to operate.
[SENTDO-2392] When SQLConnect and SQLDisconnect is called repeatedly, the connector may encounter an intermittent port number response error.
[SENTDO-2417] When TLS port is enabled, the connection fails.
[SENTDO-2400] The connector does not send an acknowledgement request.
17.20.00.000 —————————————————————–
Released 2022-02-25
Version 17.20.00.000 was the initial release of the Simba Teradata ODBC Connector.
[SENTDO-2299] Support for Unbounded Array Framework
The connector now supports the Unbounded Array Framework (UAF) feature.
[SENTDO-2356] Updated GCC support
On Linux, the connector now supports GCC version 4.8.5.
Resolved Issues The following issues have been resolved in Simba Teradata ODBC Connector 17.20.00.000.
[SENTDO-2372] When executing SQLStatistics, the connector appends extra double quotation marks ( ” ) to the query, resulting in a syntax error.
[SENTDO-2373] When connecting with Microsoft Access, an unexpected connection dialog box appears.
==============================================================================