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