This article describes general reference guidelines and best practices to help you tune the performance of PowerExchange for Netezza. You can tune the key hardware, driver, Netezza database, Informatica mapping, and session parameters to optimize the performance of PowerExchange for Netezza. This article also provides information on …

When you run Teradata mappings on the Hive engine, you can use Teradata Connector for Hadoop to improve performance. This article describes how to configure Teradata Connector for Hadoop to run mappings to read data from or write data to Teradata on the Hive engine.

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 use AWS Identity and Access Management (IAM) to control individual and group access to Amazon Redshift resources. You can configure AWS IAM to run mappings on the Data Integration Service that is installed on the EC2 system. This article describes the guidelines to configure IAM Authentication for PowerExchange for Amazon Redshift.

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 Data Integration Service that is installed on the EC2 system. This article describes the guidelines to configure IAM Authentication for PowerExchange for Amazon S3.

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 …

When you use PowerExchange for Amazon Redshift on Spark engine, multiple factors such as data set size, hardware parameters, and mapping parameters, impact the adapter performance. You can optimize the performance by analyzing your data set size, using the recommended hardware, and tuning these parameters appropriately. This article …

When you use PowerExchange for Microsoft Azure Blob Storage to read data from or write data to Microsoft Azure Blob Storage, multiple factors such as hardware parameters, database parameters, application server parameters, and Informatica mapping parameters impact the adapter performance. You can optimize the performance by tuning …

When you use PowerExchange for Microsoft Azure Cosmos DB SQL API to read data from or write data to Microsoft Azure Cosmos DB SQL API, multiple factors such as hardware parameters, database parameters, application server parameters, and Informatica mapping parameters impact the adapter performance. You can optimize the performance by …

When you use PowerExchange for Microsoft Azure SQL Data Warehouse to read data from or write data to Microsoft Azure SQL Data Warehouse, multiple factors such as hardware parameters, database parameters, application server parameters, and Informatica mapping parameters impact the adapter performance. You can optimize the performance …

When you use Informatica PowerExchange for Microsoft Azure SQL Data Warehouse to read data from or write data to Microsoft Azure SQL Data Warehouse, multiple factors such as hardware parameters, database parameters, application server parameters, and Informatica mapping parameters impact the adapter performance. You can optimize the …

This article describes how to configure the Optimized Spark mode to increase the performance of PowerExchange for Google BigQuery to read data from or write data to Google BigQuery from Informatica Developer. Learn how to configure the Google BigQuery Data Object Read and Write operation properties when you use Optimized Spark mode.

This article describes the key hardware and Hadoop cluster parameters that you can tune to optimize the performance of PowerExchange for Google BigQuery for Spark. Learn how to optimize the performance of PowerExchange for Google BigQuery on Spark by tuning these parameters appropriately.

Configure PowerExchange for SAP NetWeaver and the SAP BW environment to extract data from a load balancing SAP BW environment.

PowerExchange for SAP NetWeaver uses SAP NetWeaver RFC SDK libraries to integrate with SAP. To configure PowerExchange for SAP NetWeaver, you must download the SAP NetWeaver RFC SDK libraries from the SAP Marketplace and install them. This article explains how to download the SAP NetWeaver RFC SDK libraries from the SAP Marketplace …

This article explains how to configure HTTPS streaming with Informatica Developer when you read data from SAP tables.

This article describes the parameters that you can tune to optimize the performance of an SAP Table Data Extraction mapping from Informatica® Developer.