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
  • PowerExchange Adapters for Informatica 10.5.6
  • All Products

Data Warehouse

PowerExchange for Greenplum User Guide

Use the Informatica® PowerExchange® for Greenplum User Guide to learn how to load data to Greenplum Database by using the Developer tool. Learn to create a Greenplum connection and develop and run mappings in an Informatica domain.

PowerExchange for Netezza User Guide

Use the Informatica® PowerExchange® for Netezza User Guide to learn how to read from or write to Netezza by using the Developer tool. Learn to create a Netezza connection and develop and run mappings in an Informatica domain. It also includes information on partitioning, dynamic mapping, and parameterization of Netezza sources and targets.

PowerExchange for Teradata Parallel Transporter API User Guide

Use the Informatica® PowerExchange® for Teradata Parallel Transporter API User Guide to learn how to read from and write to Teradata by using the Developer tool. Learn to create a Teradata Parallel Transporter API connection, develop and run mappings in the native or Hadoop environment. This guide also includes information on …

Ecosystem – Amazon

PowerExchange for Amazon Redshift User Guide

Use the Informatica® PowerExchange® for Amazon Redshift User Guide to learn how to read from or write to Amazon Redshift by using the Developer tool. Learn to create a connection, develop and run mappings and dynamic mappings in the native environment and in the Hadoop and Databricks environments.

PowerExchange for Amazon S3 User Guide

Use the Informatica® PowerExchange® for Amazon S3 User Guide to learn how to read from or write to Amazon S3 by using the Developer tool. Learn to create a connection, develop and run mappings and dynamic mappings in the native environment and in the Hadoop and Databricks environments.

Ecosystem – Azure

PowerExchange for Microsoft Azure Blob Storage User Guide

Use the Informatica® PowerExchange® for Microsoft Azure Blob Storage User Guide to learn how to read from or write to Microsoft Azure Blob Storage by using the Developer tool. Learn to create a connection, develop and run mappings and dynamic mappings in the native environment and in the Hadoop and Databricks environments.

PowerExchange for Microsoft Azure Cosmos DB SQL API User Guide

Use the Informatica® PowerExchange® for Microsoft Azure Cosmos DB SQL API User Guide to learn how to read and write documents to a collection in the Cosmos DB database by using the developer tool. Learn to create a Microsoft Azure Cosmos DB SQL API connection and develop and run mappings in an Informatica domain.

PowerExchange for Microsoft Azure Data Lake Storage Gen1 User Guide

Use the Informatica® PowerExchange® for Microsoft Azure Data Lake Storage Gen1 User Guide to learn how to read from or write to Microsoft Azure Data Lake Storage Gen1 by using the Developer tool. Learn to create a connection, develop and run mappings and dynamic mappings in the native environment and in the Hadoop and Databricks …

PowerExchange for Microsoft Azure Data Lake Storage Gen2 User Guide

Use the Informatica® PowerExchange® for Microsoft Azure Data Lake Storage Gen2 User Guide to learn how to read from or write to Microsoft Azure Data Lake Storage Gen2 by using the Developer tool. Learn to create a connection, develop and run mappings and dynamic mappings in the native environment and in the Hadoop and …

PowerExchange for Microsoft Azure SQL Data Warehouse User Guide

Use the Informatica® PowerExchange® for Microsoft Azure SQL Data Warehouse User Guideto learn how to read from or write to Microsoft Azure SQL Data Warehouse by using the Developer tool. Learn to create a connection, develop and run mappings and dynamic mappings in the native environment and in the Hadoop and Databricks environments.

Ecosystem – Google

PowerExchange for Google Analytics User Guide

Use the Informatica® PowerExchange® for Google Analytics User Guide to learn how to read from Google Analytics by using the Developer tool. Learn to create a Google Analytics connection, develop and run mappings in the native environment and in the Hadoop environments.

PowerExchange for Google BigQuery User Guide

Use the Informatica PowerExchange for Google BigQuery User Guide to learn how to read from and write to Google BigQuery by using the Developer tool. Learn to create a Google BigQuery connection, develop and run mappings in the native environment and in the Hadoop environments.

PowerExchange for Google Cloud Spanner User Guide

Use the Informatica PowerExchange for Google Cloud Spanner User Guide to learn how to read from and write to Google Cloud Spanner by using the Developer tool. Learn to create a Google Cloud Spanner connection, develop and run mappings in the native environment and in the Hadoop environments.

PowerExchange for Google Cloud Storage User Guide

Use the Informatica PowerExchange for Google Cloud Storage User Guide to learn how to read from and write to Google Cloud Storage by using the Developer tool. Learn to create a Google Cloud Storage connection, develop and run mappings in the native environment and in the Hadoop environments.

Ecosystem – Snowflake

PowerExchange for Snowflake User Guide

Use the Informatica® PowerExchange® for Snowflake User Guide to learn how to read from and write to Snowflake by using the Developer tool. Learn to create a Snowflake connection, develop and run mappings in the native, Hadoop, or Databricks environment.

Enterprise Application

PowerExchange for Cassandra JDBC User Guide

Use the Informatica® PowerExchange® for Cassandra JDBC User Guide to learn how to read from or write to Cassandra JDBC database by using the Developer tool. Learn to create a Cassandra JDBC connection and develop and run mappings in an Informatica domain.

PowerExchange for Cassandra User Guide

Use the Informatica® PowerExchange® for Cassandra User Guide to learn how to read from or write to Cassandra database by using the Developer tool. Learn to create a Cassandra connection, develop and run mappings, and create virtual tables to normalize data in Cassandra collections.

PowerExchange for HBase User Guide

Use the Informatica® PowerExchange® for HBase User Guide to learn how to read from or write to column families in an HBase table by using the Developer tool. Learn to create a connection and develop and run mappings and in the native environment and Hadoop environments.

PowerExchange for HDFS User Guide

Use the Informatica® PowerExchange® for HDFS User Guide to learn how to read from or write to Hadoop Distributed File System by using the Developer tool. Learn to create a connection, develop and run mappings and dynamic mappings in the native environment and Hadoop environments.

PowerExchange for Hive User Guide

Use the Informatica® PowerExchange® for Hive User Guide to learn how to read from or write to Hive by using the Developer tool. Learn to create a connection and develop mappings to access data in Hive sources and targets.

PowerExchange for JD Edwards EnterpriseOne User Guide

Use the Informatica® PowerExchange® for JD Edwards EnterpriseOne User Guide to learn how to read from or write to JD Edwards EnterpriseOne by using the Developer tool. Learn to create a connection, develop, and run mappings in the native environment.

PowerExchange for Kudu User Guide

Use the Informatica® PowerExchange® for Kudu User Guide to learn how to write to Kudu by using the Developer tool. Learn to create a connection, develop and run mappings and dynamic mappings on the Spark engine in the Hadoop environment.

PowerExchange for LDAP User Guide

Use the Informatica® PowerExchange® for LDAP User Guide to learn how to read from or write to LDAP by using the Developer tool. Learn to create an LDAP connection, develop, and run mappings in the native environment.

PowerExchange for MapR-DB User Guide

Use the Informatica® PowerExchange® for MapR-DB User Guide to learn how to read from or write to MapR-DB binary tables by using the Developer tool. Learn to create a connection and develop and run mappings in the native environment and Hadoop environments.

PowerExchange for Microsoft Dynamics CRM User Guide

Use the Informatica® PowerExchange® for Microsoft Dynamics CRM User Guide to learn how to extract from or load to Microsoft Dynamics CRM by using the Developer tool. Learn to create a Microsoft Dynamics CRM connection and develop and run mappings in an Informatica domain.

PowerExchange for MongoDB User Guide

Use the Informatica® PowerExchange® for MongoDB User Guide to learn how to read from or write to MongoDB by using. Learn to create a connection, develop mappings, and run sessions in an Informatica domain.

PowerExchange for Salesforce Marketing Cloud User Guide

Use the Informatica® PowerExchange® for Salesforce Marketing Cloud User Guide to learn how to read from or write to Salesforce Marketing Cloud by using the Developer tool. Learn to create a Salesforce Marketing Cloud connection, develop and run mappings in the native environment.

PowerExchange for SAP NetWeaver User Guide

Use the Informatica® PowerExchange® for SAP Netweaver User Guide to learn how to extract data from and load data to SAP by using the Developer Tool. Learn to create an SAP connection, develop and run mappings in the native environment and in the Hadoop environments.

PowerExchange for SAS User Guide

Use the Informatica® PowerExchange® for SAS User Guide to learn how to read from or write to SAS by using the Developer tool. Learn to create a SAS connection and develop and run mappings and dynamic mappings in an Informatica domain.

PowerExchange for Tableau User Guide

Use the Informatica® PowerExchange® for Tableau User Guide to learn how to read data from and write data to Tableau by using the Developer tool. Learn to create a Tableau connection, develop, and run mappings in the native environment.

PowerExchange for Tableau V3 User Guide

Use the Informatica® PowerExchange® for Tableau V3 User Guide to learn how to read data from source, generate a Tableau .hyper output file, and write data to Tableau by using the Developer tool. Learn to create a Tableau V3 connection, develop, and run mappings in the native environment.

Relational

PowerExchange for JDBC V2 User Guide

Use the Informatica® PowerExchange® for JDBC V2 User Guide to learn how to read from and write to Aurora PostgreSQL, Azure SQL Database, and databases with the Type 4 JDBC driver using the Developer tool. Learn to create a JDBC V2 connection, develop and run mappings in the native, Hadoop, or Databricks environment.

Web

PowerExchange for OData User Guide

Use the Informatica® PowerExchange® for OData User Guide to learn how to read from an OData service by using the Developer Tool. Learn to create an Odata connection and develop and run mappings in an Informatica domain.

Additional Content

Common Content for Data Integration 10.5.6

Configuring an IAM Assume Role to Access AWS Resources Using PowerExchange for Amazon S3

This video demonstrates how to configure an IAM assume role to access AWS resources using PowerExchange for Amazon S3.

Data Warehouse

Best Practices for Optimizing Performance in PowerExchange for Netezza

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 …

Configuring PowerExchange for Teradata Parallel Transporter API to Run Teradata Mappings on the Hive Engine

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.

Using SSL to Connect to a Greenplum Database in PowerExchange for GreenPlum

This article describes how to configure secure communication between PowerExchange for Greenplum and the Greenplum server by using the Secure Sockets Layer (SSL) protocol. This article also describes the SSL configurations required for the DataDirect ODBC driver to connect to the Greenplum database from Informatica.

Ecosystem – Amazon

Amazon Redshift Connector Best Practices

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 …

Configuring AWS IAM Authentication for PowerExchange for Amazon Redshift

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.

Configuring IAM Authentication for PowerExchange for Amazon S3

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.

Configuring Pushdown Optimization for PowerExchange for Amazon Redshift Task Using an ODBC Connection

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 …

Performance Tuning and Sizing Guidelines for PowerExchange for Amazon Redshift on the Spark Engine

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 …

Performance Tuning Guidelines to Read Data from or Write Data to Amazon S3

When you read data from or write data to Amazon S3, multiple factors such as hardware parameters, Hadoop cluster parameters, and mapping parameters impact the operation performance. You can optimize the performance by tuning these parameters appropriately. This article describes general guidelines to help you tune the operation …

Ecosystem – Azure

Performance Guidelines for Databricks for PowerExchange for Microsoft Azure Blob Storage

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 …

Performance Tuning Guidelines for Databricks for PowerExchange for Cosmos DB SQL API

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 …

Performance Tuning Guidelines for PowerExchange for Microsoft Azure SQL Data Warehouse on Databricks

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 …

Performance Tuning Guidelines for PowerExchange for Microsoft Azure SQL Data Warehouse on the Spark Engine

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 …

Prerequisites to Create a Microsoft Azure Data Lake Storage Gen2 Connection

You can use PowerExchange® for Microsoft Azure Data Lake Storage Gen2 to connect to Microsoft Azure Data Lake Storage Gen2 from Informatica. This article explains the prerequisite tasks that you must complete before you create a Microsoft Azure Data Lake Storage Gen2 Connection.

Ecosystem – Google

Configuring Optimized Spark Mode for PowerExchange for Google BigQuery Data Objects

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.

Performance Tuning Guidelines for PowerExchange for Google BigQuery on the Spark Engine

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.

Performance Tuning Guidelines for PowerExchange for Google Cloud Storage for Spark

When you use Informatica PowerExchange for Google Cloud Storage to read data from or write data to Google Cloud Storage, multiple factors such as hardware parameters, database parameters, and application server parameters impact the performance of PowerExchange for Google Cloud Storage. You can optimize the performance by tuning these …

Ecosystem – Snowflake

Performance Tuning and Sizing Guidelines for PowerExchange for Snowflake on the Spark Engine

When you use PowerExchange for Snowflake to read data from or write data to Snowflake, multiple factors such as hardware parameters, database parameters, Hadoop cluster parameters, and Informatica mapping parameters impact the adapter performance. You can optimize the performance by tuning these parameters appropriately. This article …

Enterprise Application

Configuring PowerExchange for SAP NetWeaver in a Load Balancing SAP BW Environment

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

Downloading and Installing the SAP NetWeaver RFC SDK Libraries for PowerExchange for SAP NetWeaver

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 …

HTTPS Configuration for Table Reader Mappings in Streaming Mode for PowerExchange for SAP NetWeaver

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

Optimizing Performance of an SAP Table Data Extraction Mapping

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

Using PowerExchange for LDAP to Update Information in Active Directory

This article describes how to use PowerExchange for LDAP to update a telephone number in Active Directory.

Relational

Performance Tuning Guidelines for PowerExchange for JDBC V2 on the Spark Engine

Use PowerExchange for JDBC V2 to read from and write to Aurora PostgreSQL, Azure SQL Database, and databases with the Type 4 JDBC driver. Multiple factors such as hardware parameters, database parameters, and mapping parameters impact the adapter performance. You can optimize the performance by tuning these parameters appropriately. …

Additional Content

Common Content for Data Integration 10.5.6
Actions
Download Documentation Set
Send Feedback
Onboard
What’s New in PowerExchange Adapters
Run-time Environments
Product Availability Matrix
Configure
Create a Dynamic Mapping
Create a Transformation
Optimize
Spark Engine Optimization for Sqoop Pass-through Mappings
Pushdown Optimization
Related Content
Best Practices for PowerExchange for Amazon Redshift
Mappings on Blaze Engine
Mappings on Spark Engine
Mappings on Databricks Engine
Resources
Communities
Knowledge Base
Success Portal