Table of Contents

Search

  1. Preface
  2. Part 1: 10.2
  3. Part 2: Version 10.1.1
  4. Part 3: Version 10.1
  5. Part 4: Version 10.0
  6. Part 5: Version 9.6.1
  7. Part 6: Version 9.6.0

PowerExchange Adapters for PowerCenter

PowerExchange Adapters for PowerCenter

This section describes new PowerCenter adapter features in version 10.2.

PowerExchange for Amazon Redshift

Effective in version 10.2, PowerExchange for Amazon Redshift includes the following new features:
  • You can read data from or write data to the China (Beijing) region.
  • When you import objects from
    AmazonRSCloudAdapter
    in the PowerCenter Designer, the PowerCenter Integration Service lists the table names alphabetically.
  • In addition to the existing recovery options in the vacuum table, you can select the
    Reindex
    option to analyze the distribution of the values in an interleaved sort key column.
  • You can configure the multipart upload option to upload a single object as a set of independent parts. TransferManager API uploads the multiple parts of a single object to Amazon S3. After uploading, Amazon S3 assembles the parts and creates the whole object. TransferManager API uses the multipart uploads option to achieve performance and increase throughput when the content size of the data is large and the bandwidth is high.
    You can configure the
    Part Size
    and
    TransferManager Thread Pool Size
    options in the target session properties.
  • PowerExchange for Amazon Redshift uses the
    commons-beanutils.jar
    file to address potential security issues when accessing properties. The following is the location of the
    commons-beanutils.jar
    file:
    <Informatica installation directory>server/bin/javalib/505100/commons-beanutils-1.9.3.jar
For more information, see the
Informatica PowerExchange for Amazon Redshift 10.2 User Guide for PowerCenter
.

PowerExchange for Amazon S3

Effective in version 10.2, PowerExchange for Amazon S3 includes the following new features:
  • You can read data from or write data to the China (Beijing) region.
  • You can read multiple files from Amazon S3 and write data to a target.
  • You can write multiple files to Amazon S3 target from a single source. You can configure the
    Distribution Column
    options in the target session properties.
  • When you create a mapping task to write data to Amazon S3 targets, you can configure partitions to improve performance. You can configure the
    Merge Partition Files
    option in the target session properties.
  • You can specify a directory path that is available on the PowerCenter Integration Service in the
    Staging File Location
    property.
  • You can configure the multipart upload option to upload a single object as a set of independent parts. TransferManager API uploads the multiple parts of a single object to Amazon S3. After uploading, Amazon S3 assembles the parts and creates the whole object. TransferManager API uses the multipart uploads option to achieve performance and increase throughput when the content size of the data is large and the bandwidth is high.
    You can configure the
    Part Size
    and
    TransferManager Thread Pool Size
    options in the target session properties.
For more information, see the
Informatica PowerExchange for Amazon S3 version 10.2 User Guide for PowerCenter
.

PowerExchange for Microsoft Dynamics CRM

Effective in version 10.2, you can use the following target session properties with PowerExchange for Microsoft Dynamics CRM:
  • Add row reject reason. Select to include the reason for rejection of rows to the reject file.
  • Alternate Key Name. Indicates whether the column is an alternate key for an entity. Specify the name of the alternate key. You can use alternate key in update and upsert operations.
  • You can configure PowerExchange for Microsoft Dynamics CRM to run on AIX platform.
For more information, see the
Informatica PowerExchange for Microsoft Dynamics CRM 10.2 User Guide for PowerCenter
.

PowerExchange for SAP NetWeaver

Effective in version 10.2, PowerExchange for SAP NetWeaver includes the following new features:
  • When you run ABAP mappings to read data from SAP tables, you can use the STRING, SSTRING, and RAWSTRING data types. The SSTRING data type is represented as SSTR in PowerCenter.
  • When you read or write data through IDocs, you can use the SSTRING data type.
  • When you run ABAP mappings to read data from SAP tables, you can configure HTTP streaming.
For more information, see the
Informatica PowerExchange for SAP NetWeaver 10.2 User Guide for PowerCenter
.


Updated August 28, 2020