HomeProductsSSIS ComponentsSSIS Data Flow Components 5.2 introduce enhanced connection security and broader database...

SSIS Data Flow Components 5.2 introduce enhanced connection security and broader database support

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.

SSIS Data Flow ComponentsDownloadDocumentation
SSIS Data Flow Components for ActiveCampaignDownloadDocs
SSIS Data Flow Components for Adobe CommerceDownloadDocs
SSIS Data Flow Components for Amazon RedshiftDownloadDocs
SSIS Data Flow Components for AsanaDownloadDocs
SSIS Data Flow Components for Azure Synapse AnalyticsDownloadDocs
SSIS Data Flow Components for BigCommerceDownloadDocs
SSIS Data Flow Components for Cin7 CoreDownloadDocs
SSIS Data Flow Components for DB2DownloadDocs
SSIS Data Flow Components for Dynamics 365DownloadDocs
SSIS Data Flow Components for EmailOctopusDownloadDocs
SSIS Data Flow Components for FreshBooksDownloadDocs
SSIS Data Flow Components for FreshdeskDownloadDocs
SSIS Data Flow Components for Freshworks CRMDownloadDocs
SSIS Data Flow Components for Google AdsDownloadDocs
SSIS Data Flow Components for Google AnalyticsDownloadDocs
SSIS Data Flow Components for Google BigQueryDownloadDocs
SSIS Data Flow Components for HubSpotDownloadDocs
SSIS Data Flow Components for Insightly CRMDownloadDocs
SSIS Data Flow Components for JiraDownloadDocs
SSIS Data Flow Components for MailchimpDownloadDocs
SSIS Data Flow Components for MarketoDownloadDocs
SSIS Data Flow Components for MySQLDownloadDocs
SSIS Data Flow Components for NetSuiteDownloadDocs
SSIS Data Flow Components for OracleDownloadDocs
SSIS Data Flow Components for PipedriveDownloadDocs
SSIS Data Flow Components for PodioDownloadDocs
SSIS Data Flow Components for PostgreSQLDownloadDocs
SSIS Data Flow Components for QuickBooks OnlineDownloadDocs
SSIS Data Flow Components for SalesforceDownloadDocs
SSIS Data Flow Components for Salesforce Marketing CloudDownloadDocs
SSIS Data Flow Components for SendPulseDownloadDocs
SSIS Data Flow Components for ShipStationDownloadDocs
SSIS Data Flow Components for ShopifyDownloadDocs
SSIS Data Flow Components for SlackDownloadDocs
SSIS Data Flow Components for SnowflakeDownloadDocs
SSIS Data Flow Components for SQLiteDownloadDocs
SSIS Data Flow Components for SQL ServerDownloadDocs
SSIS Data Flow Components for StreakDownloadDocs
SSIS Data Flow Components for StripeDownloadDocs
SSIS Data Flow Components for SugarCRMDownloadDocs
SSIS Data Flow Components for SurveyMonkeyDownloadDocs
SSIS Data Flow Components for Twitter AdsDownloadDocs
SSIS Data Flow Components for WordPressDownloadDocs
SSIS Data Flow Components for ZendeskDownloadDocs
SSIS Data Flow Components for Zoho BooksDownloadDocs
SSIS Data Flow Components for Zoho CRMDownloadDocs
SSIS Data Flow Components for Zoho DeskDownloadDocs
SSIS Data Flow Components for Zoho InventoryDownloadDocs
SSIS Data Flow Components for Zoho InvoiceDownloadDocs
SSIS Data Flow Components for Zoho PeopleDownloadDocs
dotConnect Team
dotConnect Teamhttps://www.devart.com/dotconnect/
The dotConnect Team is a group of experienced .NET developers at Devart who specialize in building and supporting dotConnect data providers. They share practical insights, coding tips, and tutorials on .NET development and database connectivity through the Devart blog.
RELATED ARTICLES

Whitepaper

Social

Topics

Products