We are pleased to announce the release of Devart SSIS Data Flow Components 5.2, which introduces enhanced connection security, improved Google BigQuery authentication, and support for the latest MySQL versions.

Enhanced security with SSL connections over SSH tunnels
SSIS Data Flow Components 5.2 now support SSL connections over SSH tunnels for Amazon Redshift, MySQL, and PostgreSQL. Previously, SSL and SSH connection settings could not be used together. With this release, users can configure both in a single connection, combining SSH tunneling with SSL encryption for secure data transfers.
This enhancement is particularly useful for environments that require both secure SSH tunneling and SSL-encrypted database connections.
Improved Google BigQuery service account authentication
The latest version of SSIS Data Flow Components for BigQuery simplifies service account authentication for Google BigQuery. The connection editor now includes Authentication Type and Service Account Json fields, allowing users to configure service account authentication directly in the interface.
Users can also specify the path to a service account key file in the Service Account Json property. Additionally, improved error messages make it easier to identify and resolve issues with invalid service account keys.
Support for the latest MySQL versions
SSIS Data Flow Components for MySQL 5.2 introduce support for MySQL 9.7 LTS and the MySQL 26.7 and 26.10 Innovation releases. The update also includes an expanded list of supported keywords to maintain compatibility with the latest MySQL versions.
Improved encoding and collation support for MySQL and MariaDB
Version 5.2 enhances encoding and collation support for MySQL and MariaDB, improving the handling of character data across different database configurations. These improvements help ensure more consistent data processing when working with databases that use different character sets and collations.
More precise time zone handling for PostgreSQL
SSIS Data Flow Components for PostgreSQL 5.2 introduce a new Exact Timezone connection string parameter. This parameter determines whether the time zone rules of the PostgreSQL server or the operating system are used when reading date and time values that include time zone information. This gives users greater control over how time zone information is interpreted, helping ensure consistent date and time values across different environments.
The release also updates the list of supported time zones.
Get the latest version
Devart SSIS Data Flow Components 5.2 are available for download. Upgrade to take advantage of enhanced connection security, expanded database compatibility, and improved data integration capabilities.
Browse the SSIS Data Flow Components below to download the latest versions and access product documentation.

