Enhanced 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

Amazon Athena Connector

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

• •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

• •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

Db2 for z/OS Bulk Load Connector

Db2 for z/OS CDC Connector

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

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

• •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

JDBC V2 Connector

Kafka Connector

Microsoft Azure Cosmos DB SQl API Connector

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

• •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

• •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

• •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

• •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

MySQL Connector

MySQL CDC Connector

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

Oracle CDC V2 Connector

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

PostgreSQL CDC Connector

Salesforce Connector

SAP HANA Connector

SAP HANA CDC Connector

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

• •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.
Preview Notice: 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

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