PowerExchange Adapters

PowerExchange Adapters for Informatica

PowerExchange for Amazon Redshift

• •The Amazon S3 bucket that you specify to create staging files can be in a different region than the Amazon Redshift cluster.
• •You can use KMS Customer managed keys from an external account to create encrypted resources by providing the Amazon Resource Name (ARN) of the external account in the connection properties.

PowerExchange for Amazon S3

• •You can read multiple files of the flat format type from Amazon S3 and write data to a target using a .manifest file.
• •You can use the AWS ap-east-1 (Hong Kong) region in the native environment and on the Spark engine.
• •You can use KMS Customer managed keys from an external account to create encrypted resources by providing the Amazon Resource Name (ARN) of the external account in the connection properties.
• •You can run a mapping to read an Amazon S3 binary file using the FileName port in native mode.
• •You can read an Amazon S3 binary file from a directory in native mode.

PowerExchange for Google BigQuery

• •You can configure a cached lookup operation on a Google BigQuery table. You can also enable lookup caching for a lookup operation to increase the lookup performance. The Data Integration Service caches the lookup source and runs the query on the rows in the cache.
• •You can read data from and write data to a table in a Google BigQuery dataset available in a specific region. Specify the Google BigQuery region in the Region ID connection property.

PowerExchange for Hive

PowerExchange for Microsoft Azure Data Lake Storage Gen2

• •You can run mappings to read and write ORC files in the following environments:
• - Native environment
• - Spark engine in the Hadoop environment
• - Databricks
• •You can run mappings to read and write JSON files in the native environment.
• •You can configure the Azure Government end-points in mappings in the native environment and on Spark engine in the Hadoop environment.
• •You can configure the authenticated proxy server settings for the Data Integration Service to connect to Microsoft Azure Data Lake Storage Gen2.

PowerExchange for Salesforce

• •You can use version 48.0 of Salesforce API to create a Salesforce connection and access Salesforce objects.
• •You can configure dynamic mappings to include the frequent changes to sources, targets, and transformation logic at run time based on parameters and rules that you define.

PowerExchange for SAP NetWeaver

PowerExchange for Snowflake

PowerExchange Adapters for PowerCenter

PowerExchange for Db2 Warehouse

• •You can read and write data for the following data types in Db2 Warehouse:
• - VarcharForBitData
• - CharForBitData
• •You can use PowerExchange for Db2 Warehouse on the Windows platform. You can create Windows connections and sessions in PowerCenter installed on Windows to read from and write to Db2 Warehouse.
• •You can use PowerExchange for Db2 Warehouse on the AIX platform. You can create AIX connections and sessions in PowerCenter installed on AIX to read from and write to Db2 Warehouse.

PowerExchange for Greenplum

PowerExchange for Google BigQuery

• •You can create a pipeline Lookup transformation to perform a lookup on a Google BigQuery table. You can retrieve data from a Google BigQuery lookup definition based on the lookup condition that you specify. A pipeline Lookup transformation has a source qualifier as the lookup source.
• •You can create a session to read the real-time or changed data from a Change Data Capture (CDC) source and load data into Google BigQuery. You must select Data Driven in the Treat source rows as property to capture changed data. You can resume the extraction of changed data from the point of interruption when a session fails or is stopped.
• •You can read data from and write data to a table in a Google BigQuery dataset available in a specific region. Specify the Google BigQuery region in the Region ID connection property.

PowerExchange for Google Cloud Storage

PowerExchange for Kafka

• •When you write data to a Kafka target, you can configure file-based recovery in a real-time session.
• •You can configure additional configuration properties to connect to a Kafka broker over SSL. You can configure these properties in the Additional Security Properties of the Kafka connection.
• •When you specify configuration properties in Additional Security Properties field, the value that you specify is masked.
• •You can configure PLAIN security for a Kafka broker in Additional Connection Properties or Additional Security Properties field.

PowerExchange for Microsoft Azure SQL Data Warehouse V3

PowerExchange for Salesforce

PowerExchange for SAP NetWeaver

PowerExchange for Snowflake

• •You can use external tables and materialized views as Snowflake sources and perform all the read operations.
• •You can use the Update Override target session property to override the default update query that the PowerCenter Integration Service generates with the update query that you specify.