PowerExchange Adapters for PowerCenter

PowerCenter User Guide for PowerCenter

Use the PowerExchange® for Cloud Application User Guide to integrate PowerCenter and data sources by using Cloud Data Integration. Learn to import data source objects from Cloud Data Integration and use the objects in PowerCenter mappings.

PowerExchange for Cassandra User Guide for PowerCenter

Last updated for 10.5.10

PowerExchange for Cassandra User Guide for PowerCenter

PowerExchange for Essbase User Guide for PowerCenter

Last updated for 10.5.10

Use the Informatica® PowerExchange® for Essbase User Guide to learn how to read data from an Essbase source, write data to an Essbase target, and modify the Essbase outline by using the PowerCenter Client. Learn to create an Essbase connection, develop mappings, and run sessions in an Informatica domain.

PowerExchange for Hadoop User Guide for PowerCenter

Last updated for 10.5.10

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

PowerExchange for JD Edwards World User Guide for PowerCenter

Last updated for 10.5.10

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

PowerExchange for JMS User Guide for PowerCenter

Last updated for 10.5.10

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

PowerExchange for Kafka User Guide for PowerCenter

Last updated for 10.5.10

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

PowerExchange for LDAP User Guide for PowerCenter

Last updated for 10.5.10

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

PowerExchange for Lotus Notes User Guide for PowerCenter

Last updated for 10.5.10

Use the Informatica® PowerExchange® for Lotus Notes User Guide for PowerCenter® to learn how to extract from and load to Lotus Notes by using PowerCenter Client. Learn to create a Lotus Notes connection, develop mappings, and run sessions in an Informatica domain.

PowerExchange for Microsoft Dynamics 365 for Sales User Guide for PowerCenter

Last updated for 10.5.10

Use the Informatica® PowerExchange® for Microsoft Dynamics 365 for Sales User Guide for PowerCenter® to learn how to read from and write to Microsoft Dynamics 365 for Sales by using PowerCenter Client. Learn to create a Microsoft Dynamics 365 for Sales connection, develop mappings, and run sessions in an Informatica domain.

PowerExchange for Microsoft Dynamics CRM User Guide for PowerCenter

Last updated for 10.5.10

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

PowerExchange for MongoDB JDBC User Guide for PowerCenter

Last updated for 10.5.10

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

PowerExchange for MongoDB ODBC User Guide for PowerCenter

Last updated for 10.5.10

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

PowerExchange for MSMQ User Guide for PowerCenter

Last updated for 10.5.10

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

PowerExchange for Oracle E-Business Suite User Guide for PowerCenter

Last updated for 10.5.10

Use the Informatica® PowerExchange® for Oracle E-Business Suite User Guide to learn how to read from or write to Oracle E-Business Suite by using PowerCenter Client. Learn to create a connection, develop mappings, and run sessions in an Informatica domain.

PowerExchange for PeopleSoft User Guide for PowerCenter

Last updated for 10.5.10

Use the Informatica® PowerExchange® for PeopleSoft User Guide to learn how to extract from and load to a PeopleSoft system by using PowerCenter Client. Learn to create a PeopleSoft connection, develop mappings, and run sessions in an Informatica domain.

PowerExchange for Salesforce Analytics User Guide for PowerCenter

Last updated for 10.5.10

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

PowerExchange for Salesforce User Guide for PowerCenter

Last updated for 10.5.10

PowerExchange for Salesforce User Guide for PowerCenter

PowerExchange for SAP NetWeaver User Guide for PowerCenter

Last updated for 10.5.10

Use the Informatica® PowerExchange® for SAP NetWeaver User Guide for PowerCenter® to learn how to extract data from and load data to SAP by using PowerCenter Client. Learn to create an SAP connection, develop mappings, and run sessions in an Informatica domain.

PowerExchange for SAS User Guide for PowerCenter

Last updated for 10.5.10

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

PowerExchange for Siebel User Guide for PowerCenter

Last updated for 10.5.10

Use the Informatica® PowerExchange® for Siebel User Guide to learn how to extract data from and load data to Siebel by using PowerCenter Client. Learn to create a Siebel connection, develop mappings, and run sessions in an Informatica domain.

PowerExchange for Tableau User Guide for PowerCenter

Last updated for 10.5.10

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

PowerExchange for Tableau V3 User Guide for PowerCenter

Last updated for 10.5.10

Use the Informatica® PowerExchange® for Tableau V3 User Guide to learn how to read from multiple sources, generate a Tableau .hyper output file, and write the data to Tableau by using PowerCenter Client. Learn to create a Tableau V3 connection, develop mappings, and run sessions in an Informatica domain.

PowerExchange for webMethods User Guide for PowerCenter

Last updated for 10.5.10

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

PowerExchange for WebSphere MQ User Guide for PowerCenter

Last updated for 10.5.10

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

Web

PowerExchange for Web Services User Guide for PowerCenter

Last updated for 10.5.10

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

Ecosystem – Google

PowerExchange for Google Analytics User Guide for PowerCenter

Last updated for 10.5.10

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

PowerExchange for Google BigQuery User Guide for PowerCenter

Last updated for 10.5.10

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

PowerExchange for Google Cloud Spanner User Guide for PowerCenter

Last updated for 10.5.10

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

PowerExchange for Google Cloud Storage User Guide for PowerCenter

Last updated for 10.5.10

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

Data Warehouse

PowerExchange for Db2 Warehouse User Guide for PowerCenter

Last updated for 10.5.10

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

PowerExchange for Greenplum User Guide for PowerCenter

Last updated for 10.5.10

Use the Informatica® PowerExchange® for Greenplum User Guide to learn how to read from or load data to Greenplum Database by using the PowerCenter Client. Learn to create a Greenplum connection, develop mappings, and run sessions in an Informatica domain.

PowerExchange for Netezza User Guide for PowerCenter

Last updated for 10.5.10

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

PowerExchange for Teradata Parallel Transporter API User Guide for PowerCenter

Last updated for 10.5.10

Use the Informatica® PowerExchange® for Teradata Parallel Transporter API User Guide to learn how to read from and write to Teradata by using the PowerCenter Client. Learn to create a Teradata Parallel Transporter API connection, develop mappings, and run sessions in an Informatica domain. This guide also includes information on …

PowerExchange for Vertica User Guide for PowerCenter

Last updated for 10.5.10

Use the Informatica® PowerExchange® for Vertica User Guide to learn how to extract data from and load data to Vertica by using PowerCenter Client. Learn to create a Vertica connection, develop mappings, and run sessions in an Informatica domain.

Relational

PowerExchange for HANA User Guide for PowerCenter

Last updated for 10.5.10

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

PowerExchange for PostgreSQL User Guide for PowerCenter

Last updated for 10.5.10

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

Ecosystem – Azure

PowerExchange for Microsoft Azure SQL Data Warehouse V3 User Guide for PowerCenter

Last updated for 10.5.10

Use Informatica® PowerExchange® for Microsoft Azure SQL Data Warehouse V3 User Guide to learn how to read from or write to Microsoft Azure SQL Data Warehouse by using PowerCenter Client. Learn to create a connection, develop mappings, and run sessions in an Informatica domain.

Additional Guides

PowerExchange for JD Edwards EnterpriseOne User Guide for PowerCenter

Last updated for 10.5.10

The Informatica PowerExchange for JD Edwards EnterpriseOne User Guide for PowerCenter provides information about extracting data from a JD Edwards EnterpriseOne source and loading data to a JD Edwards EnterpriseOne target. It is written for database administrators and developers who are responsible for extracting data from JD …

Ecosystem – Snowflake

PowerExchange for Snowflake User Guide for PowerCenter

Last updated for 10.5.10

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

Ecosystem – Amazon

PowerExchange for Amazon S3 User Guide for PowerCenter

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

PowerExchange for Amazon Redshift User Guide for PowerCenter

Last updated for 10.5.10

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

Additional Content

Common Content for Data Integration 10.5.11

Performance Tuning and Sizing Guidelines for PowerExchange for Db2 Warehouse for PowerCenter

Use PowerExchange for Db2 Warehouse to learn how to read from and write to Db2 Warehouse. Multiple factors such as data set size, hardware parameters, and mapping parameters impact the adapter performance. To optimize the performance, you can analyze your data set size, use the recommended hardware, and tune these parameters appropriately.

Enterprise Application

Configuring HTTP Streaming for SAP ABAP Table Reader Mappings in PowerCenter

When you run ABAP mappings in PowerCenter to read data from SAP tables, you can configure HTTP streaming. HTTP stream mode sessions use background processing. This article describes how to configure HTTP streaming for ABAP table reader mappings in PowerCenter.

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.

Frequently Asked Questions for PowerExchange for Kafka for PowerCenter

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

How to Configure SAP BCI Delta Initialization Without Transfer

You can use PowerExchange for SAP NetWeaver to extract business content data from SAP Business Suite applications. When you extract business content data, the first step that you perform is delta initialization with transfer. Based on your business needs, you can also configure for delta initialization without transfer. This article …

How to Configure the SAP Secure Network Communication Protocol in PowerCenter

Secure Network Communication (SNC) is a software layer in the SAP system architecture that integrates third-party security products with SAP. Using the SNC protocol, you can secure communications between SAP and an external system. This article describes how to configure the SNC protocol to secure communications between PowerCenter and SAP.

HTTPS Configuration for Table Reader Mappings with PowerExchange for SAP Dynamic ABAP Table Extractor

This article explains how to configure HTTPS streaming with PowerExchange for SAP Dynamic ABAP Table Extractor when you read data from SAP tables in streaming mode.

Importing Kafka Topics in Binary Format in PowerCenter

You can use PowerExchange for Kafka to import Kafka topics as a source or target definition in the PowerCenter Designer. This article describes how to import Kafka topics as source or target definitions in binary format.

Performance Tuning Guidelines for PowerExchange for SAP Dynamic ABAP Table Extractor

This article describes the parameters that you can tune to optimize the performance of a PowerExchange® for SAP Dynamic ABAP Table Extractor source session from PowerCenter®.

Additional Content

Common Content for Data Integration 10.5.11

Download Documentation Set

Send Feedback

Getting Started

What’s New in PowerExchange Adapters

Product Availability Matrix

Creating a Connection

Creating a Transformation

PowerCenter Performance Tuning Guide

FAQs: PowerExchange for Google BigQuery

FAQs: PowerExchange for Kafka