Communities
A collaborative platform to connect and grow with like-minded Informaticans across the globe
Product Communities
Connect and collaborate with Informatica experts and champions
Discussions
Have a question? Start a Discussion and get immediate answers you are looking for
User Groups
Customer-organized groups that meet online and in-person. Join today to network, share ideas, and get tips on how to get the most out of Informatica
Get Started
Community Guidelines
Knowledge Center
Troubleshooting documents, product guides, how to videos, best practices, and more
Knowledge Base
One-stop self-service portal for solutions, FAQs, Whitepapers, How Tos, Videos, and more
Support TV
Video channel for step-by-step instructions to use our products, best practices, troubleshooting tips, and much more
Documentation
Information library of the latest product documents
Velocity (Best Practices)
Best practices and use cases from the Implementation team
Learn
Rich resources to help you leverage full capabilities of our products
Trainings
Role-based training programs for the best ROI
Certifications
Get certified on Informatica products. Free, Foundation, or Professional
Product Learning Paths
Free and unlimited modules based on your expertise level and journey
Resources
Library of content to help you leverage the best of Informatica products
Tech Tuesdays Webinars
Most popular webinars on product architecture, best practices, and more
Product Availability Matrix
Product Availability Matrix statements of Informatica products
SupportFlash
Monthly support newsletter
Support Documents
Informatica Support Guide and Statements, Quick Start Guides, and Cloud Product Description Schedule
Product Lifecycle
End of Life statements of Informatica products
Ideas
Events
Change Request Tracking
Marketplace
English
  • Data Integration
  • All Products

Table of Contents

Search

  1. Preface
  2. April 2024
  3. February 2024
  4. December 2023
  5. November 2023
  6. Upgrade

What's New

What's New

Back Next

Enhanced connectors

Enhanced connectors

This release includes enhancements to the following connectors.

Adabas Connector

  • When you define a connection, you can specify one or more connection overrides in the
    Custom Properties
     field, such as $UserPass="User Name=jdoe;Password=mypassword".
  • You can override source objects through parameterization in mappings. Parameterization enables you to parameterize the number of source objects and object names. In mappings, the new Parameter field appears on the
    Source
     >
    Details
     tab. Click
    New Parameter
     next to the field to create a parameter with the new type of multi group data object. This type of parameter can define a set of source object groups, one group per object. You can then map the group names to target transformations.

Adabas CDC Connector

You can set a user-defined parameter in the
Custom Properties
 connection property that allows you to specify connection property overrides through a parameter file.

Amazon Athena Connector

You can configure AWS Identity and Access Management (IAM) authentication when the Secure Agent is installed on an Amazon Elastic Compute Cloud (EC2) system.

Amazon Redshift V2 Connector

This release includes the following enhancements for Amazon Redshift V2 Connector:
  • SQL ELT optimization enhancement
    • When you run a mapping enabled for SQL ELT optimization and the mapping contains multiple pipelines, you can define the flow run order when you want
      Data Integration
       to load the targets from the pipelines in a particular order.
    • When you configure a mapping to write to multiple targets in a single pipeline, with each target configured for any write operation, the target operations are processed in a predefined order of delete, update, upsert, and insert.
  • You can configure a SQL transformation to process a user-entered query to call a stored procedure that returns a value or no values.
  • You can configure a virtual private cloud endpoint to enable private communication between the Secure Agent and the Amazon S3 bucket for staging.

Databricks Delta Connector

This release includes the following enhancements for Databricks Delta Connector:
  • SQL ELT optimization enhancement
    When you run a mapping enabled for SQL ELT optimization and the mapping contains multiple pipelines, you can define the flow run order when you want
    Data Integration
     to load the targets from the pipelines in a particular order.
  • You can configure partitioning to optimize the mapping performance at run time when you write data to Databricks Delta targets.
  • You can improve the staging performance of a mapping that writes to Databricks Delta.
  • You can configure a connection and mapping in one environment and then migrate and run the mapping in another environment.

Db2 Data Map Connector

  • When you define a connection, you can specify one or more connection overrides in the
    Custom Properties
     field, such as $UserPass="User Name=jdoe;Password=mypassword".
  • You can override source objects through parameterization in mappings. Parameterization enables you to parameterize the number of source objects and object names. In mappings, the new Parameter field appears on the
    Source
     >
    Details
     tab. Click
    New Parameter
     next to the field to create a parameter with the new type of multi group data object. This type of parameter can define a set of source object groups, one group per object. You can then map the group names to target transformations. .

Db2 for i CDC Connector

This release includes the following enhancements for Db2 for i CDC Connector:
  • You can set a user-defined parameter in the
    Custom Properties
     connection property that allows you to specify connection property overrides through a parameter file.
  • The optional mapping source property,
    Journal Name
    , enables you to override the library and journal name in the PowerExchange CAPI_CONNECTION statement.

Db2 for LUW CDC Connector

You can set a user-defined parameter in the
Custom Properties
 connection property that allows you to specify connection property overrides through a parameter file.

Db2 for z/OS Bulk Load Connector

When you define a connection, you can specify one or more connection overrides in the
Custom Properties
 field, such as $UserPass="User Name=jdoe;Password=mypassword".

Db2 for z/OS CDC Connector

You can set a user-defined parameter in the
Custom Properties
 connection property that allows you to specify connection property overrides through a parameter file.

Db2 for z/OS Image Copy Connector

  • When you define a connection, you can specify one or more connection overrides in the
    Custom Properties
     field, such as $UserPass="User Name=jdoe;Password=mypassword".
  • You can override source objects through parameterization in mappings. Parameterization enables you to parameterize the number of source objects and object names. In mappings, the new Parameter field appears on the
    Source
     >
    Details
     tab. Click
    New Parameter
     next to the field to create a parameter with the new type of multi group data object. This type of parameter can define a set of source object groups, one group per object. You can then map the group names to target transformations.

Db2 for z/OS Unload File Connector

  • When you define a connection, you can specify one or more connection overrides in the
    Custom Properties
     field, such as $UserPass="User Name=jdoe;Password=mypassword".
  • You can override source objects through parameterization in mappings. Parameterization enables you to parameterize the number of source objects and object names. In mappings, the new Parameter field appears on the
    Source
     >
    Details
     tab. Click
    New Parameter
     next to the field to create a parameter with the new type of multi group data object. This type of parameter can define a set of source object groups, one group per object. You can then map the group names to target transformations.

DB2 Loader Connector

You can encrypt passwords when connecting to DB2 databases.

Google BigQuery V2 Connector

This release includes the following enhancements for Google BigQuery V2 Connector:
  • You can create a target table with clustered columns at run time.
  • You can configure the threshold number of errors in a mapping task. The mapping continues to run until the number of errors reaches the set threshold value, then it fails.
  • You can enable sorted input in a cached Lookup transformation to enhance the lookup performance.
  • You can add a label in a mapping to filter the associated jobs in the Google Log Explorer.
  • You can configure views in a mapping in the following scenarios:
    • Within a Lookup transformation.
    • Within a Source transformation with staging optimization enabled.

IMS Connector

This release includes the following enhancements for IMS Connector:
  • When you define a connection, you can specify one or more connection overrides in the
    Custom Properties
     field, such as $UserPass="User Name=jdoe;Password=mypassword".
  • You can override source objects through parameterization in mappings. Parameterization enables you to parameterize the number of source objects and object names. In mappings, the new Parameter field appears on the
    Source
     >
    Details
     tab. Click
    New Parameter
     next to the field to create a parameter with the new type of multi group data object. This type of parameter can define a set of source object groups, one group per object. You can then map the group names to target transformations.

IMS CDC Connector

You can set a user-defined parameter in the
Custom Properties
 connection property that allows you to specify connection property overrides through a parameter file.

JDBC V2 Connector

You can use a JDBC V2 connection to read data from Salesforce Data Cloud.

Kafka Connector

You can configure the polling interval value in the source advanced properties. The polling interval determines how long the agent waits to retrieve records from the Kafka broker.

Microsoft Azure Cosmos DB SQl API Connector

When you write data in bulk to Microsoft Azure Cosmos DB SQl API, you can set the mapping to throttle throughput of low priority requests and prioritize higher priority requests.

Microsoft Azure Synapse SQL Connector

This release includes the following enhancements for Microsoft Azure Synapse SQL Connector:
  • SQL ELT optimization enhancement
    When you run a mapping enabled for SQL ELT optimization and the mapping contains multiple pipelines, you can define the flow run order when you want
    Data Integration
     to load the targets from the pipelines in a particular order.
  • When you run a mapping that reads from and writes to Microsoft Azure Synapse SQL, you can override the schema name that the Secure Agent uses to create external tables for staging data files.
  • You can use the ISNULL or ISNOTNULL operators when you define a source filter or an uncached lookup condition.
  • You can push the IS_DATE() function to process in Microsoft Azure Synapse SQL.

Microsoft Fabric Data Warehouse Connector

This release includes the following enhancements for Microsoft Fabric Data Warehouse Connector:
  • You can use custom queries to read data from Microsoft Fabric Data Warehouse source objects.
  • You can configure a connection and mapping in one environment and then migrate and run the mapping in another environment.
  • You can determine the behavior of a task that encounters errors while executing pre-SQL or post-SQL commands.
  • You can perform delete and data driven operations when you write to a Microsoft Fabric Data Warehouse target.
  • You can truncate the target data before inserting the data to a Microsoft Fabric Data Warehouse target.

Microsoft Fabric Lakehouse Connector

This release includes the following enhancements for Microsoft Fabric Lakehouse Connector:
  • You can configure a connection and mapping in one environment and then migrate and run the mapping in another environment.
  • You can use custom queries to read data from Microsoft Fabric Lakehouse source objects.

Microsoft Fabric OneLake Connector

This release includes the following enhancements for Microsoft Fabric OneLake Connector:
  • You can read files from directories and sub-directories.
  • You can use wildcard characters to specify the source files and source directory names.
  • You can configure an authenticated or unauthenticated proxy server to connect to Microsoft Fabric OneLake.
  • You can read data from semi-structured or unstructured source files in a mapping in advanced mode.
  • You can append data to an existing file in Microsoft Fabric OneLake.

Microsoft SQL Server Connector

This release includes the following enhancements for Microsoft SQL Server Connector:
  • You can run Microsoft SQL Server mappings using the upgraded JDBC driver version 6.0.0.001282 or ODBC driver version 08.02.1500.
  • You can configure the connection timeout value for test connection while creating a Microsoft SQL Server connection.

Microsoft SQL Server CDC Connector

You can set a user-defined parameter in the
Custom Properties
 connection property that allows you to specify connection property overrides through a parameter file.

MySQL Connector

You can configure the connection timeout value for test connection while creating a MySQL connection.

MySQL CDC Connector

You can set a user-defined parameter in the
Custom Properties
 connection property that allows you to specify connection property overrides through a parameter file.

ODBC Connector

This release includes the following enhancements for ODBC Connector:
  • You can read from
    or write data to
    Sybase ASE databases.
  • You can use Kerberos authentication to connect to SSL-enabled Sybase ASE databases.

Oracle Cloud Object Storage Connector

You can read and write Gzip-compressed flat files.

Oracle CDC V2 Connector

You can set a user-defined parameter in the
Custom Properties
 connection property that allows you to specify connection property overrides through a parameter file.

Oracle Connector

This release includes the following enhancements for Oracle Connector:
  • You can run Oracle mappings using the upgraded JDBC driver version 6.0.0.001165 or ODBC driver version 08.02.3072.
  • You can configure the connection timeout value for test connection while creating an Oracle connection.

PostgreSQL Connector

You can use Kerberos authentication to connect to PostgreSQL databases.

PostgreSQL CDC Connector

You can set a user-defined parameter in the
Custom Properties
 connection property that allows you to specify connection property overrides through a parameter file.

Salesforce Connector

You can use version 59.0 and 60.0 of Salesforce API to create a Salesforce connection and access Salesforce objects.

SAP HANA Connector

You can read from SAP HANA external views that are created by SAP BW CompositeProviders in the SAP system.

SAP HANA CDC Connector

You can set a user-defined parameter in the
Custom Properties
 connection property that allows you to specify connection property overrides through a parameter file.

Sequential File Connector

This release includes the following enhancements for Sequential File Connector:
  • When you define a connection, you can specify one or more connection overrides in the
    Custom Properties
     field, such as $UserPass="User Name=jdoe;Password=mypassword".
  • You can override source objects through parameterization in mappings. Parameterization enables you to parameterize the number of source objects and object names. In mappings, the new Parameter field appears on the
    Source
     >
    Details
     tab. Click
    New Parameter
     next to the field to create a parameter with the new type of multi group data object. This type of parameter can define a set of source object groups, one group per object. You can then map the group names to target transformations.

Snowflake Data Cloud Connector

This release includes the following enhancements for Snowflake Data Cloud Connector:
  • Mapping in SQL ELT mode enhancements
    • You can preview data for individual transformations to validate the mapping logic. You can also preview data from fields that contain primitive and hierarchical data types.
    • You can preview the SQL queries at design time.
    • When you configure multiple targets, you can view statistics for each target separately in the job details page.
    • You can push a few data generation, encryption, string and binary, and numeric functions to Snowflake.
      For the list of supported functions, see the Snowflake Data Cloud Connector documentation.
  • When you run a mapping enabled for SQL ELT optimization and the mapping contains multiple pipelines, you can define the flow run order when you want
    Data Integration
     to load the targets from the pipelines in a particular order.
  • You can set the default column value for the return field in a Lookup transformation in a Snowflake mapping.
    This feature does not apply to mappings in advanced mode.
  • You can override the query_tag parameter that is defined in the Snowflake connection in a mapping task.
    This feature does not apply to mappings in advanced mode.
  • You can remove the leading and trailing white spaces from strings when you write to a target. You can also convert fields that contain only spaces into empty strings and write them as Null values to a target.
    This feature does not apply to mappings in advanced mode.
  • You can read from Apache Iceberg tables that are managed by Snowflake or any external catalog, and write to Apache Iceberg tables that are managed by Snowflake.
    Reading from Apache Iceberg tables that are managed by Snowflake or any external catalog, and writing to Apache Iceberg tables that are managed by Snowflake is available for preview.
    Preview functionality is supported for evaluation purposes but is unwarranted and is not supported in production environments or any environment that you plan to push to production. Informatica intends to include the preview functionality in an upcoming release for production use, but might choose not to in accordance with changing market or technical circumstances. Note that if you are working on a preview POD, all data is excluded from SOC 2 compliance coverage. For more information, contact Informatica Global Customer Support.

Tableau V3 Connector

You can configure a personal access token authentication to connect to Tableau Server or Tableau Online.

VSAM Connector

This release includes the following enhancements for VSAM Connector:
  • When you define a connection, you can specify one or more connection overrides in the
    Custom Properties
     field, such as $UserPass="User Name=jdoe;Password=mypassword".
  • You can override source objects through parameterization in mappings. Parameterization enables you to parameterize the number of source objects and object names. In mappings, the new Parameter field appears on the
    Source
     >
    Details
     tab. Click
    New Parameter
     next to the field to create a parameter with the new type of multi group data object. This type of parameter can define a set of source object groups, one group per object. You can then map the group names to target transformations. .

VSAM CDC Connector

You can set a user-defined parameter in the
Custom Properties
 connection property that allows you to specify connection property overrides through a parameter file.
0 COMMENTS
We’d like to hear from you!