Introducing Configurable Legacy Parallel Connection Mode for Exa-to-Exa Operation

Details

Detail name Value
Changelog Number 26800
Type Improvement
Status Resolved
Fix Versions Exasol 2025.1.2, Exasol 2025.2.0
Resolution Date 2025-08-20

Background

Currently, Exa-to-Exa connections are designed to use the latest parallel connection method by default. If the destination database does not support the latest parallel connection method, the system will automatically fallback to the legacy parallel connection mode.

While this fallback mechanism ensures compatibility, users lack the flexibility to explicitly activate or deactivate the legacy connection mode based on their requirements. In scenarios where users need to enforce the legacy mode or prevent its usage entirely, they are unable to specify this preference. This limitation prompted the introduction of configuration options to give users the ability to choose between the latest and legacy parallel connection modes.

Improvement

Two new parameters have been added to provide users control over the usage of legacy parallel connection mode:

  1. Database Parameter:
  2. Connection String Parameter:
  • Name: exaToExaLegacyConnection
  • Accepted Values:
  • Default: 0
  • 0 (Disable legacy parallel connection mode)
  • 1 (Enable legacy parallel connection mode)
  • Name: LegacyConnection
  • Accepted Values (Case Insensitive):
  • Y, YES, 1 (Enable legacy parallel connection mode)
  • N, NO, 0 (Disable legacy parallel connection mode)

Behavior

  • If the connection string parameter LegacyConnection is provided, it takes precedence over the database parameter exaToExaLegacyConnection.
  • If the connection string parameter is not specified, the database parameter determines the behavior.
  • Even if the legacy mode is deactivated, the system will fallback to the legacy connection mode if the destination database does not support the new mode (minimum version required: DB 8.32+ or DB 2025.1+).

Example Usage

Importing data with legacy connection mode disabled:

IMPORT INTO DemoSchema.DemoTable 
FROM EXA AT 'test.exasol.com:8563;LEGACYCONNECTION=N;' 
USER '******' IDENTIFIED BY '******' 
TABLE DemoSchema.DemoTable;
  • The LEGACYCONNECTION=N parameter explicitly disables the legacy connection mode.
  • Both the parameter name (LegacyConnection) and its values (Y, YES, N, NO, etc.) are case-insensitive, allowing flexibility in usage.

This improvement provides enhanced configurability, empowering users with the ability to explicitly activate or deactivate the legacy parallel connection mode based on their operational needs.