Enhanced connectors

Amazon Athena Connector

Amazon Redshift V2 Connector

Amazon S3 V2 Connector

• •You can use the document file format to read PDF files in a mapping in advanced mode.
• •When you use discover structure and document file format in a mapping in advanced mode, you can incrementally load source files from a directory to read and process only the files that have changed since the last time the mapping ran.

Azure AI Connector

Databricks Connector

• •You can read delta format files from Amazon S3 and Microsoft Azure Data Lake Storage Gen2 sources in a mapping in SQL ELT mode and mapping task configured for SQL ELT optimization.
• •You can use the Databricks cluster version 15.4 LTS at runtime to process Databricks mappings and tasks.

Google BigQuery V2 Connector

• •You can use Workload Identity Federation authentication to connect to Google BigQuery.
• •You can edit the precision of binary, decimal, and string data types, and the scale of the decimal data type for Google Cloud Storage or Amazon S3 sources in a SQL ELT mode mapping.
• •You can read and write JSON data using Google BigQuery Storage API or hybrid connection mode.

Kafka Connector

Microsoft Azure Data Lake Storage Gen2 Connector

• •When you use discover structure and document file format in a mapping in advanced mode, you can incrementally load source files from a directory to read and process only the files that have changed since the last time the mapping ran. 
• •You can write to a partitioned target when you use the delta format to write to a Delta Lake.

Microsoft Azure Synapse SQL Connector

Microsoft Excel Connector

Microsoft Fabric Data Warehouse Connector

• •You can edit the precision and scale of a field in the source or lookup object in a mapping in SQL ELT mode that reads from Microsoft Azure Data Lake Storage Gen2.
• •You can push window functions to Microsoft Fabric Data Warehouse.
For the list of supported functions, see the Microsoft Fabric Data Warehouse Connector documentation.

Microsoft Fabric OneLake Connector

Microsoft SQL Server Connector

• •You can run a mapping using one of the following upgraded driver versions:
• - ODBC EBF driver: 08.02.1801
• - ODBC Latest driver: 08.02.2200
To use these ODBC drivers, you need to update the Secure Agent configuration. For more information about configuring these drivers, see the How to configure the ODBC driver for Microsoft SQL Server Connector Knowledge Base article.
• •You can configure and run the environment SQL queries in the same session within a Target transformation.

MongoDB V2 Connector

• •You can configure rows for an insert, update, upsert, or delete operation when you write data to a MongoDB V2 target. This enhancement doesn't apply to mappings in advanced mode.
• •You can use LDAP authentication to connect to MongoDB in a mapping. This enhancement doesn't apply to mappings in advanced mode.
• •You can read data from a CDC source and write to a MongoDB V2 target in a mapping. This enhancement doesn't apply to mappings in advanced mode.
• •You can read from or write to Azure CosmosDB enabled with the MongoDB API in a mapping.

NetSuite Connector

ODBC Connector

Open Table Connector

• •You can read from and write to Apache Iceberg tables that are managed by the Polaris catalog and stored in Amazon S3 using OAuth2 client credentials authentication.
• •When you set up the Open Table connection, you can configure an EC2 role to assume a different IAM role to authenticate access to resources in Amazon S3 storage.
• •When you read from and write to Apache Iceberg tables, you can run SQL commands before and after reading or writing data. You can also truncate the target table before loading data into the target.

Oracle Autonomous Database Connector

• •When you read from an Oracle Autonomous Database source, you can read the data directly without staging it.
• •You can perform the following lookups on an Oracle Autonomous Database object in a mapping:
• - Cached and uncached lookups
• - Connected and unconnected lookups
• •You can perform the following actions on the data when you write to an Oracle Autonomous Database target:
• - Update, upsert, delete, and data-driven operations
• - Override the default SQL query used to write data
• - Run SQL commands before and after the write operation
• - Truncate the target table before loading data into it
• - Create the target table at runtime

Oracle Cloud Object Storage Connector

• •Read all files directly under a specified directory, excluding files in its subdirectories.
• •Read files from a directory path that is overridden during runtime.
• •Use wildcard characters in file names and directory paths during runtime to select files dynamically.
• •Recursively read files within all subdirectories under a specified directory.

Oracle Connector

• •You can run a mapping using one of the following upgraded driver versions:
• - JDBC EBF driver: 6.0.0.001506
• - JDBC Latest driver: 6.0.0.001574
To use these JDBC drivers, you need to update the Secure Agent configuration. For more information about configuring these drivers, see the How to configure the JDBC driver for Oracle Connector Knowledge Base article.
• •You can join tables across the schemas when you use multiple objects as the source type.

Slack Connector

Snowflake Data Cloud Connector

• •You can write to an Apache Iceberg target table created at run time.
• •You can optimize performance for a mapping task by configuring pass-through partitioning when you read from Snowflake. This enhancement doesn't apply to mappings in advanced mode.

Teradata Connector