This article contains information about how to configure Amazon Redshift Connector, PowerExchange for Amazon Redshift, and PowerExchange for Amazon Redshift for PowerCenter to get the best performance and efficiency. This document captures the concepts, best practices, and recommendations for tuning Informatica Cloud, Big Data …

You can configure single sign-on (SSO) to Amazon S3 with corporate credentials in Cloud Data Integration. SSO provides you with a single point of authentication and an enhanced security to access an Amazon Web Services (AWS) environment.

This article describes how you can configure VPC peering between the Amazon Redshift cluster and the serverless runtime environment.

You can use the IAM AssumeRole authentication to access Amazon Redshift V2 resources. You can configure the Redshift IAM role ARN with an IAM user or define an EC2 instance to assume a role. This article describes the guidelines to configure Redshift IAM Authentication using AssumeRole to connect to Redshift using Redshift V2 Connector.

You can use AWS Identity and Access Management (IAM) to control individual and group access to Amazon Redshift resources. You can configure AWS IAM to run tasks on the Secure Agent that is installed on the EC2 system. This article describes the guidelines to configure IAM Authentication for Amazon Redshift and Amazon Redshift V2 Connectors.

You can enable client-side or server-side encryption to encrypt data inserted in Amazon S3 buckets to protect data. You can generate a customer master key in AWS Key Management Service (AWS KMS) and configure the key in Amazon S3 connection properties to encrypt data. This article describes the guidelines and steps to configure AWS KMS …

You can use AWS Identity and Access Management (IAM) to control individual and group access to Amazon S3 resources. You can configure AWS IAM to run tasks on the Secure Agent that is installed on the EC2 system. This article describes the guidelines to configure IAM Authentication for Amazon S3 and Amazon S3 V2 Connectors.

This article describes how you can configure Informatica encryption for elastic mappings in Amazon S3 V2 Connector.

This article describes how you can configure Informatica encryption for mappings in advanced mode in Amazon S3 V2 Connector.

This article describes how you can configure private communication to connect to Amazon Redshift using the Amazon Redshift V2 Connector.

This article describes how you can configure private communication to connect to Amazon S3 using the Amazon S3 V2 Connector.

This article explains how to configure pushdown optimization for a mapping that uses the ODBC connection type to read from or write to Amazon Redshift. This article also explains the pushdown optimization functions, transformations, operators, and data types that you can push down to Amazon Redshift using the Amazon Redshift ODBC connection type.

You can use Amazon S3 V2 Connector to read from or write Avro and Parquet files to Amazon S3. This article lists the frequently asked questions about using Amazon S3 V2 Connector to read data from or write data to Amazon S3.

This article discusses the solutions to use the upsert operation with Amazon Redshift V2 Connector from Cloud Data Integration.

When you use Amazon Redshift Connector, multiple factors such as data set size, hardware parameters, and mapping parameters, impact the connector performance. You can optimize the performance by analyzing your data set size, using the recommended hardware, and tuning these parameters appropriately. This article describes general …

You can use Amazon S3 V2 Connector to read a JSON file through a binary port. To read a JSON file, you must use the Hierarchy Parser and Java transformations in the Amazon S3 V2 mapping. Adding the transformations enable the Secure Agent to convert the data of the binary format to the string format. This article explains how to create …

This article describes how you can use Amazon Redshift Serverless with Cloud Data Integration.

You can assume an IAM (Identity and Access Management) role in Amazon S3 resources to generate temporary security credentials. The temporary security credentials give you limited access to Amazon resources for a certain period. You can use the IAM role in Amazon Redshift V2 Connector and Amazon S3 V2 Connector to access Amazon S3 …

This article explains how to configure Azure Active Directory (AAD) authentication when you use Microsoft Azure SQL Data Warehouse Connector to connect to Microsoft Azure SQL Data Warehouse. By default, the Microsoft Azure SQL Data Warehouse connection uses Microsoft SQL Server authentication.

You can use a Microsoft Azure Synapse SQL connection to connect to a Microsoft Azure Synapse SQL endpoint that resides in the Azure Virtual Network. This article explains how to configure a virtual network to create a secure and scalable, on-demand Azure infrastructure on Azure cloud.

This article explains how to configure pushdown optimization for a mapping that uses the ODBC connection type to read from or write to Microsoft Azure Synapse SQL. This article also explains the pushdown optimization functions, transformations, and operators that you can push down to Microsoft Azure Synapse SQL using the Microsoft Azure …

You can use an Azure private endpoint to securely and privately connect to your Azure storage account on a virtual network. This article explains how to configure an Azure private endpoint in the Azure portal.

You can use an Azure private endpoint to securely and privately connect to your Microsoft Azure Synapse SQL account on a virtual network. This article explains how to configure an Azure private endpoint in the Azure portal.

When you use Microsoft Azure Cosmos DB SQL API Connector to perform extensive query operations on data, you can use the Hierarchical Parser transformation to convert hierarchical input into flat output. The transformation processes XML or JSON input from the upstream transformation and provides flat output to the downstream …

When you use Microsoft Azure Cosmos DB SQL API Connector to perform extensive query operations on data, you can use the Hierarchical Parser transformation to convert hierarchical input into relational output. The transformation processes XML or JSON input from the upstream transformation and provides relational output to the downstream …

When you want to read data from a relational source and write data to Microsoft Azure Cosmos DB SQL API, you can use the Hierarchical Builder transformation to convert relational input into hierarchical output. The transformation processes a relational input from the upstream transformation and provides JSON output to the downstream …

When you want to read data from a relational source and write data to Microsoft Azure Data Lake Storage Gen2, you can use the Hierarchy Builder transformation to convert relational input into hierarchical output. The transformation processes a relational input from the upstream transformation and provides JSON output to the downstream …

You can tune the hardware parameters, database parameters, application server parameters, and Informatica mapping parameters to optimize the performance of Microsoft Azure Synapse SQL Connector. This article describes general reference guidelines, best practices, and case studies to help you tune the performance of Microsoft Azure …

You can use pushdown optimization to push transformation logic to source databases or target databases. Use pushdown optimization to improve task performance by using the database resources. When you run a task configured for pushdown optimization, the task converts the transformation logic to an SQL query. The task sends the query to …

You can tune the Informatica mapping parameters to optimize the performance of Microsoft Azure Cosmos DB SQL API Connector. This article describes general reference guidelines to help you tune the performance of Microsoft Azure Cosmos DB SQL API Connector.

You can use Microsoft Azure Data Lake Storage Gen2 Connector to read from or write to Microsoft Azure Data Lake Storage Gen2. This article describes general reference guidelines to help you tune the performance of Microsoft Azure Data lake Storage Gen2 Connector in Cloud Data Integration. It also describes the best practices and case …

You can connect to a serverless SQL pool when you read data from Microsoft Azure Synapse SQL. This article explains the prerequisite tasks that you must complete before you configure a Microsoft Azure Synapse SQL connection to connect to a serverless SQL pool.

You can use Microsoft Azure Blob Storage V3 Connector to connect to Microsoft Azure Blob Storage from Cloud Data Integration. This article explains the prerequisite tasks that you must complete before you create a Microsoft Azure Blob Storage V3 connection.

You can use Microsoft Azure Data Lake Storage Gen2 Connector to connect to Microsoft Azure Data Lake Storage Gen2 from Cloud Data Integration. This article explains the prerequisite tasks that you must complete before you create a Microsoft Azure Data Lake Storage Gen2 Connection.

You can use Microsoft Azure Synapse SQL Connector to connect to Microsoft Azure Synapse SQL from Cloud Data Integration. This article explains the prerequisite tasks that you must complete before you create a Microsoft Azure Synapse SQL connection.

You can use Databricks Delta Connector to connect to Databricks Delta Lake. This article describes general reference guidelines to help you tune the performance of Databricks Delta Connector in Cloud Data Integration. It also describes the best practices required when you run a mass ingestion task to transfer tables from a Databricks Delta …

You can use pushdown optimization to push transformation logic to source databases or target databases. Use pushdown optimization when you use database resources to improve the performance of the task. When you run a task configured for pushdown optimization, the task converts the transformation logic to an SQL query. The task sends …

This article describes frequently asked questions about using Google BigQuery V2 Connector to read data from and write data to Google BigQuery.

This article describes frequently asked questions about using Google BigQuery Connector to read data from and write data to Google BigQuery.

This article describes frequently asked questions about using Google Cloud Storage Connector to read data from and write data to Google BigQuery.

When you use Google BigQuery V2 Connector to read data from or write data to Google BigQuery, multiple factors such as hardware, Google Compute Engine, Secure Agent, and Informatica mapping parameters impact the connector performance. You can optimize the performance by tuning these parameters appropriately. This article describes …

This article provides instructions on how to authenticate to Snowflake using an external OAuth such as Okta in Snowflake Data Cloud Connector from Cloud Data Integration.

This article explains how to configure pushdown optimization for a mapping that uses the ODBC connection type to read from or write to Snowflake. This article also explains the pushdown optimization functions, transformations, operators, and data types that you can push down to Snowflake using the Snowflake ODBC connection type.

When you use Snowflake Connector to read data from or write data to Snowflake, multiple factors such as hardware, database, Amazon EC2, Secure Agent, and Informatica mapping parameters impact the connector performance. You can optimize the performance by tuning these parameters appropriately. This article describes general reference …

You can configure pushdown optimization in a mapping that reads from or writes to Snowflake. This article describes the various pushdown scenarios that you can configure to optimize the performance of Snowflake Data Cloud Connector.

You can use the SSL protocol to configure a secure connection to the SAP HANA server from Cloud Data Integration. This article describes how to configure the Secure Agent for SSL communication with an SAP HANA server.

In Data Integration, you can configure a Web Service transformation that calls the SAP BW BEx Query web service from a mapping task. This article describes the steps to create a Web Service transformation, configure an SAP BW BEx Query business service in the transformation, and connect to the SAP BW BEx Query web service to read data.

MongoDB Connector uses the Simba MongoDB JDBC driver to connect to MongoDB. This article provides detailed information about the MongoDB JDBC driver options that you can configure in a MongoDB connection in Data Integration.

MongoDB Connector uses the Simba MongoDB JDBC driver to connect to MongoDB Atlas. This article provides detailed information about the MongoDB Connection properties that you can configure in a MongoDB connection to connect to MongoDB Atlas database using Cloud Data Integration.

When you want to read data from a relational source and write data to Apache Kafka, you can use the Hierarchical Builder transformation to convert relational input into hierarchical output. This article describes how to use the Hierarchical Builder transformation with Kafka Connector to convert relational input into hierarchical output.

This article describes frequently asked questions about using Kafka Connector to read data from and write to Kafka topics.

You can configure SAP BAPI Connector as a business service within a mapping or a mapping task for SAP BAPI data integration. To configure SAP BAPI Connector as a business service, you must associate an SAP BAPI connection with the business service, and add the required BAPI operation for the business service. This article describes how …

When you use MongoDB Connector to read data from or write data to MongoDB, you can optimize the performance by tuning the mapping parameters appropriately. This article describes general reference guidelines to help you tune the performance of MongoDB Connector in Cloud Data Integration.

When you use SAP Table Reader Connector, factors such as packet size and heap size impact the connector performance. You can optimize the performance by tuning these parameters appropriately. This article describes general reference guidelines to help you tune the performance of SAP Table Reader Connector.

When you use ServiceNow Connector to read data from or write data to ServiceNow, you can optimize the performance by tuning the mapping parameters appropriately. This article describes general reference guidelines to help you tune the performance of ServiceNow Connector in Cloud Data Integration.

You can use Microsoft Sharepoint Online Connector to read data from or write data to Microsoft Sharepoint Online. To use the connector, you must complete certain prerequisite tasks. This article explains the prerequisite tasks that you must complete before you use Microsoft Sharepoint Online Connector.

This article provides detailed information on how you can configure a mapping to transfer data between Kafka topics and MongoDB collections in Data Integration.

To establish SSL communication for MySQL Connector, you must install the MySQL JDBC and ODBC drivers, version 8.0.12 on the Secure Agent machine. This article explains how to install the MySQL JDBC and ODBC drivers on Windows or Linux systems and configure SSL for a MySQL connection.

This article describes how to configure the advanced security options for Oracle Connector in Cloud Data Integration to connect to an Oracle database enabled with advanced security encryption.

You can configure an Oracle connection to connect to Oracle Database Cloud Service from Cloud Data Integration®. This article describes how to configure Oracle connectivity to Oracle Database Cloud Service.