12 SALESFORCE

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

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

3.0.2 ========================================================================

Released 2024-03-21

Enhancements & New Features

[SF-963] Security updates

The connector has been updated with security improvements.
[SF-964] Upgraded compiler support

The connector now uses Windows Visual Studio 2022. For supported versions, see the Installation and Configuration Guide.
[SF-965] Updated security flags

The following security flags have been used to improve security checks in the connector:
- /CETCOMPAT
- /guard:cf
- /Qspectre
- /SDL
[SF-966] Updated third-party libraries

The connector now uses the following third-party libraries:
- Boost 1.82.0 (previously 1.66.0)
- Expat 2.6.0 (previously 2.5.0)
- libcURL 8.6.0 (previously 8.4.0)
- OpenSSL 3.0.13 (previously 3.0.11)
- ZLib 1.3.1 (previously 1.2.13)
[SF-969] Filepath validation support

The connector can now verify the filepath provided in the CertsPath property is a canonical absolute path.

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

Text area fields return string data “as is” from the REST API, possibly returning carriage-return line-feed sequences instead of
line-feeds only, as was usual for the SOAP API.
There are rounding discrepancies between SOAP, REST and Bulk API when using the SOQL CONVERTCURRENCY scalar function.
The CONVERTCURRENCY, DISTANCE, and FORMAT functions are not supported in filters.

These SOQL functions and their aliases cannot be used in filters. Only fields can be used in filters.
The following SQL features are not supported by the connector:
- Typeof
- Offset
- With
Binary data types are not supported for INSERT, UPDATE, and DELETE statements.
Support for the Encrypted TextArea custom field type is limited.

The connector retrieves the field as a string of asterisks (for example, “***“), which may cause filtering to be incorrect.
Query processing is not optimal when GROUP BY returns large result sets.

Normally, when a result set exceeds 2000 rows, the connector will use the queryMore() call and a server-side cursor to retrieve additional rows in 1000-row chunks. Doing so allows the query to be processed efficiently. However, if the query contains a GROUP BY clause, then queryMore() cannot be used. In this case, you must change the filtering conditions to query data in smaller chunks.
SQL string operators are case-sensitive.

Although Salesforce uses case-insensitive matching for string operators such as “=” and “LIKE”, the connector processes SQL string operators in a case-sensitive manner.
Restrictions in queries may not be enforced during the prepare stage.

A query may succeed during the prepare stage even if it violates one of the following:
- Restrictions on using ToLabel() in the filter clause.
- Restrictions on using fields in the HAVING clause.
- Restrictions on the operations that can be performed for specific data types. For example, ORDER BY is not supported for the following data types:
  - Multi-select picklist
  - Rich text area
  - Long text area
  - Encrypted The query fails when it is executed.
If unixODBC 2.3.1 is used, the connector terminates unexpectedly when calling SQLSetConnectAttr with the SQL_ATTR_ODBC_CURSORS attribute. The ODBC specification does not recommend using this library.

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

The following changes may disrupt established workflows for the connector.

3.0.0 ————————————————————————

[SF-920] Removed support for OS platforms

Beginning with this release, the connector no longer supports the following OS platforms:
- Windows 8.1 and 7 SP1
- Windows Server 2008 R2 SP1
- macOS 10.13 and 10.14
- Debian 8 and 9
- Red Hat Enterprise Linux (RHEL) 6
- SUSE Linux Enterprise Server (SLES) 11
- Ubuntu 16.04 and 18.04
For a list of supported OS versions, see the Installation and Configuration Guide.

2.2.22 ——————————————————————

Removed support for Ubuntu 14.04

Beginning with this release, the connector no longer supports Ubuntu 14.04. For a list of supported Linux versions, see the Installation and Configuration Guide.

2.2.21 ———————————————————————–

[SF-798] Removed support for earlier versions of Windows

Beginning with this release, the connector no longer supports the following versions of Windows:
- Windows 7
- Windows Server 2008
- Windows Server 2008r2
For a list of supported Windows versions, see the Installation and Configuration Guide.
[SF-797] Removed support for macOS 10.12 and earlier

Beginning with this release, the connector no longer supports the following versions of macOS:
- macOS 10.12
- macOS 10.11
- macOS 10.10
- macOS 10.9
For a list of supported macOS versions, see the Installation and Configuration Guide.

2.2.20 ———————————————————————–

[SF-799] Removed support for CentOS 6

Beginning with this release, the connector no longer supports CentOS 6. For a list of supported Linux versions, see the Installation and Configuration Guide.
[SF-796] Removed support for Visual Studio 2013

Beginning with this release, the connector no longer supports Visual Studio
1. For a list of supported Visual Studio versions, see the Installation and Configuration Guide.

2.2.12 ———————————————————————–

Rollback of 2.2.11

Due to unforeseen issues with the 2.2.11 release, all features and resolved issues included in that release have been rolled back as of this release. For information on the features and resolved issues that have been rolled back, see the 2.2.11 section in the Version History.

2.2.1 ————————————————————————

Minimum TLS Version

Beginning with this release, the driver requires a minimum version of TLS for encrypting the data store connection. By default, the driver requires TLS version 1.2. This requirement may cause existing DSNs and connection strings to stop working, if they are used to connect to data stores that use a TLS version earlier than 1.2.

To resolve this, in your DSN or connection string, set the Minimum TLS option (the Min_TLS property) to the appropriate version of TLS for your server. For more information, see the Installation and Configuration Guide.

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

3.0.1 ————————————————————————

Released 2024-01-18

Enhancements & New Features

[SF-936] Updated third-party libraries

The connector now uses the following third-party libraries:
- libcURL 8.4.0 (previously 7.88.1)
- OpenSSL 3.0.12 (previously 3.0.9)

Resolved Issues The following issue has been resolved in Simba Salesforce ODBC Connector 3.0.1.

[SF-934] The connector fails to use expanded chunkable tables.

3.0.0 ————————————————————————

[SF-920] Removed support for OS platforms

Beginning with this release, the connector no longer supports the following OS platforms:
- Windows 8.1 and 7 SP1
- Windows Server 2008 R2 SP1
- macOS 10.13 and 10.14
- Debian 8 and 9
- Red Hat Enterprise Linux (RHEL) 6
- SUSE Linux Enterprise Server (SLES) 11
- Ubuntu 16.04 and 18.04
For a list of supported OS versions, see the Installation and Configuration Guide.

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

Installation and Configuration Guide