This section describes new PowerCenter adapter features in version 10.1.1 HotFix 1.
PowerExchange for Amazon Redshift
This section describes new PowerExchange for Amazon Redshift features in version 10.1.1 HotFix 1:
You can read data from or write data to the following regions:
Asia Pacific (Mumbai)
Canada (Central)
US East (Ohio)
PowerExchange for Amazon Redshift supports the asterisk pushdown operator (*) that can be pushed to the Amazon Redshift database by using source-side, target-side, or full pushdown optimization.
For client-side and server-side encryption, you can configure the customer master key ID generated by AWS Key Management Service (AWS KMS) in the connection.
For more information, see the
Informatica 10.1.1 HotFix 1 PowerExchange for Amazon Redshift User Guide for PowerCenter
.
PowerExchange for Amazon S3
This section describes new PowerExchange for Amazon S3 features in version 10.1.1 HotFix 1:
You can read data from or write data to the following regions:
Asia Pacific (Mumbai)
Canada (Central)
US East (Ohio)
For client-side and server-side encryption, you can configure the customer master key ID generated by AWS Key Management Service (AWS KMS) in the connection.
When you write data to the Amazon S3 buckets, you can compress the data in GZIP format.
You can override the Amazon S3 folder path when you run a mapping.
For more information, see the
Informatica PowerExchange for Amazon S3 10.1.1 HotFix 1 User Guide for PowerCenter
.
PowerExchange for Microsoft Azure Blob Storage
Effective in version 10.1.1 HotFix 1, you can use append blob type target session property to write data to Microsoft Azure Blob Storage.
For more information, see the
Informatica PowerExchange for Microsoft Azure Blob Storage 10.1.1 HotFix 1 User Guide
.
PowerExchange for Microsoft Azure SQL Data Warehouse
Effective in version 10.1.1 HotFix 1, you can use the following target session properties with PowerExchange for Microsoft Azure SQL Data Warehouse:
Update as Update. The PowerCenter Integration Service updates all rows as updates.
Update else Insert. The PowerCenter Integration Service updates existing rows and inserts other rows as if marked for insert.
Delete. The PowerCenter Integration Service deletes the specified records from Microsoft Azure SQL Data Warehouse.
For more information, see the
Informatica PowerExchange for Microsoft Azure SQL Data Warehouse 10.1.1 HotFix 1 User Guide for PowerCenter
.
PowerExchange for Microsoft Dynamics CRM
Effective in version 10.1.1 HotFix 1, 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.
For more information, see the
Informatica PowerExchange for Microsoft Dynamics CRM 10.1.1 HotFix 1 User Guide for PowerCenter
.
PowerExchange for SAP NetWeaver
Effective in version 10.1.1 HotFix 1, PowerExchange for SAP NetWeaver supports the SSTRING data type when you read data from SAP tables through ABAP. The SSTRING data type is represented as SSTR in PowerCenter.
For more information, see the
Informatica PowerExchange for SAP NetWeaver 10.1.1 HotFix 1 User Guide
