Connector What's New > April 2025 > Enhanced connectors

Enhanced connectors

This release includes enhancements to the following connectors.

Amazon Redshift V2 Connector

This release includes the following enhancements for Amazon Redshift V2 Connector:

•Mapping in SQL ELT mode

You can configure Amazon S3 as a source in a Lookup transformation in a mapping.

Databricks Connector

This release includes the following enhancements for Databricks Connector:

•Mapping in SQL ELT mode

You can configure Amazon S3 and Microsoft Azure Data Lake Storage Gen2 as sources in a Lookup transformation in a mapping.

•You can configure a Databricks connection to connect to Databricks endpoints hosted on Google Cloud Platform.
•You can use Delta UniForm to read Delta tables formatted for Apache Iceberg.
•You can stage data in a Volume in Databricks when you run a Databricks mapping on a Windows machine.

Google BigQuery V2 Connector

You can use a Normalizer transformation in a mapping in SQL ELT mode.

Google Cloud Storage V2 Connector

When you write data to Google Cloud Storage, you can optimize the upload of large files.

Kafka Connector

This release includes the following enhancements for Kafka Connector:

•You can read messages from a Kafka topic in real time when the connection is configured to use the Confluent schema registry.
•You can read and write data using the snappy and zstd compression formats.

Marketo V3 Connector

You can read data from Smart Campaign source objects in Marketo.

Microsoft Fabric Data Warehouse Connector

This release includes the following enhancements for Microsoft Fabric Data Warehouse Connector:

•Mapping in SQL ELT mode

- You can extract data from Microsoft Azure Data Lake Storage Gen2 and load data to Microsoft Fabric Data Warehouse.
- You can use a Rank transformation.

•You can access Microsoft Fabric Data Warehouse using an Azure Private Link endpoint.
•You can configure an SQL Transformation in a mapping to process a stored procedure.
•You can enable dynamic schema handling in a task to refresh the schema every time the task runs.

Microsoft SQL Server Connector

This release includes the following enhancements for Microsoft SQL Server Connector:

•You can configure Service Principal authentication to connect to Microsoft SQL Server database.
•You can run a mapping using one of the following upgraded driver versions:

- JDBC Base driver: 6.0.0.001475
- JDBC Latest driver: 6.0.0.001765

The connector uses the JDBC Base driver by default.

To use the JDBC Latest driver, you need to update the Secure Agent configuration. For more information about configuring the Latest driver, see the How to configure the JDBC or ODBC driver for Oracle and Microsoft SQL Server Connectors Knowledge article.

Oracle Connector

You can run a mapping using one of the following upgraded driver versions:

•JDBC Base driver: 6.0.0.001408
•JDBC Latest driver: 6.0.0.001506

The connector uses the JDBC Base driver by default.

Salesforce Connector

You can connect to Salesforce with the Salesforce API version up to 63.0, except the versions 58.0 and 61.0.

SAP Table Connector

This release includes the following enhancements for SAP Table Connector:

•You can read data of the UTCL data type from an SAP object in a mapping.
•You can read data from an entity-based CDS view in a mapping.
•SAP Table Connector uses the latest transport requests ER6K900176 for the TABLE_READER transport.

Snowflake Data Cloud Connector

You can edit the precision or scale of a field in the source or lookup object in a Snowflake mapping in SQL ELT mode that reads from Amazon S3 or Microsoft Azure Data Lake Storage Gen2.