This release includes enhancements to the following connectors.
Amazon Redshift V2 Connector
This release includes the following enhancements for Amazon Redshift V2 Connector:
•Amazon Redshift V2 Connector uses the JDBC driver version 2.1.0.32.
•The Secure Agent tries to reconnect to Amazon S3 if the connection times out while downloading data from Amazon S3 staging to the agent machine. The maximum number of retry attempts is 3.
Amazon S3 V2 Connector
This release includes the following enhancements for Amazon S3 V2 Connector:
•You can use AWS IAM Roles Anywhere to generate temporary security credentials to securely access Amazon S3 resources from your servers, applications, or containers outside of AWS using X.509 certificates instead of long-term credentials.
This enhancement doesn't apply to mappings in advanced mode.
•You can read from and write to an Amazon S3 bucket in the Tel Aviv, Israel region.
•Amazon S3 V2 Connector uses the AWS SDK version 1.12.730.
Databricks Connector
This release includes the following enhancements for Databricks Connector:
•SQL ELT optimization enhancement
If you want to stop a running job enabled for SQL ELT optimization, you can clean stop the job. When you use clean stop, Data Integration terminates all the issued statements and processes spawned by the job.
•You can configure Azure Private Link to enable private communication between the Secure Agent and Databricks endpoint hosted on the Microsoft Azure platform using OAuth Machine-to-Machine authentication.
This enhancement doesn't apply to mappings in advanced mode.
•You can read data from materialised views in Databricks. A materialized view is a database object that stores the results of a query as a physical table.
This enhancement doesn't apply to mappings in advanced mode.
•Databricks Connector uses the JDBC driver version 2.7.1.
Google Analytics Connector
You can read data from a Cohort report.
Google BigQuery V2 Connector
You can push COUNTIF and FORMAT functions to Google BigQuery in a mapping in SQL ELT mode.
Microsoft Azure Cosmos DB SQL API Connector
You can write vector embeddings to a Microsoft Azure Cosmos DB SQL API target.
Microsoft SQL Server Connector
You can edit the precision and scale of both input and output fields in stored procedures or functions called from a SQL transformation.
Open Table Connector
When you configure a mapping with an Apache Iceberg table, you can specify different catalog types for source and target tables.
Oracle Financials Cloud V1 Connector
You can read the encrypted data from an Oracle Financials Cloud application.
PostgreSQL Connector
You can read and write data of the JSONB data type.
SAP Table Connector
You can read data of the DATN, DECFLOAT16, DECFLOAT34, and TIMN data types from source tables.