1.78 release notes

Long-term support (LTS)

Welcome to the release notes for Matillion ETL version 1.78.

This version is a long-term support (LTS) release, which will be supported until at least November 2026.

Read more about Matillion ETL supported releases.

1.78.0

May 29th, 2025

Known issues

There are no known issues at this time.

Breaking changes

The upgrade of the Microsoft JDBC Driver for SQL Server from version 8.2.0.jre8 to 12.8.1.jre11 introduces a potential breaking change for customers connecting to SQL Server instances using self-signed or untrusted certificates.

Beginning with JDBC driver version 10.2, the default behavior of the encrypt setting changed as follows:

encrypt=true is now the default (was previously false).
trustServerCertificate is no longer automatically set when encrypt is enabled.
If trustServerCertificate=true isn't explicitly added, connection attempts using self-signed or untrusted certificates will fail.

Because of this change, after upgrading from a Matillion ETL version prior to 1.78 you may experience unexpected connection failures if using a SQL Server instance with a self-signed or untrusted certificate. To avoid this, include the following in your JDBC connection strings:

trustServerCertificate=true

For background information on this upgrade, read this Microsoft blog post.

Deprecations

Manage CDC

As of December 1st 2024, the Manage CDC feature is end of life (EOL), and this feature has been removed from Matillion ETL version 1.78. Read the tech note Removal of Manage CDC from Matillion ETL to learn more.

Dynamics Nav

Matillion have removed the Dynamics NAV Query connector from Matillion ETL version 1.78.

Improvements and bug fixes

All platforms

Added a Print Variables component that prints the value of a job or environment variable at a specific point in the job execution.
Added a password strength indicator for user passwords.
Google Ads Query now uses the v18 API, which is the latest version of the Google Ads API. This change is required to ensure continued access to the Google Ads API, as v17 will sunset on June 4, 2025. Read the Google Ads API documentation for more information.
Fixed an issue that was causing the SharePoint OAuth set up to fail due to insufficient permission scopes.

Snowflake

When performing a migration from one Matillion ETL instance to another, you have the option to migrate some or all of your Snowflake query tags.

Databricks

Added the option to select OAuth authentication when setting up a Databricks environment or project.
When performing a migration from one Matillion ETL instance to another, you have the option to migrate some or all of your Databricks job compute configurations.

Amazon Redshift

Added the option to select IAM-based authentication when setting up a Redshift environment or project.

Driver updates

Microsoft JDBC driver for SQL Server updated 8.2.0.jre8 → 12.8.1.jre11. This is a potentially breaking change, as detailed above.