PowerExchange Adapters for Informatica

PowerExchange Adapters for Informatica Release Notes

Read the Informatica® PowerExchange Adapters Release Notes to learn about installation, closed enhancements, fixed limitations, and known limitations for PowerExchange adapters for Informatica.

PowerExchange Adapters for Informatica Release Notes (10.4.0.1)

Read the Informatica® PowerExchange Adapters Release Notes to learn about installation, closed enhancements, fixed limitations, and known limitations for PowerExchange adapters for Informatica.

PowerExchange fo SAS Release Notes

Read the Informatica® PowerExchange® for SAS Release Notes to learn about new features, known limitations, and bug fixes associated with version 10.4.0.

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 environments.

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 Guide to 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 ODBC User Guide

Use the Informatica® PowerExchange® for Cassandra ODBC 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 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 and write to MongoDB by using the Developer tool. 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 Salesforce User Guide

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

PowerExchange for SAP NetWeaver Transport Versions Installation Notice

Use the Informatica® PowerExchange® for SAP NetWeaver Transport Versions Installation Notice to learn how and when to upgrade or install Informatica transports.

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

Social Media

PowerExchange for DataSift User Guide

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

PowerExchange for Facebook User Guide

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

PowerExchange for LinkedIn User Guide

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

PowerExchange for Twitter User Guide

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

PowerExchange for Web Content-Kapow Katalyst User Guide

Use the Informatica® PowerExchange® for Web Content-Kapow Katalyst User Guide to learn how to use PowerExchange for Web Content-Kapow Katalyst to import and access robots in Kapow Katalyst and extract data from the Web by using the Developer tool. Learn to create a Web Content-Kapow Katalyst connection and develop and run mappings in …

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.

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.

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. …

Download Documentation Set

Send Feedback

What’s New in PowerExchange Adapters

Run-time Environments

Product Availability Matrix

Create a Dynamic Mapping

Create a Transformation

Spark Engine Optimization for Sqoop Pass-through Mappings

Pushdown Optimization

Best Practices for PowerExchange for Amazon Redshift

Mappings on Blaze Engine

Mappings on Spark Engine