Table of Contents

Search

  1. Version 10.1
  2. Version 10.0
  3. Version 9.6.1
  4. Version 9.6.0

PowerExchange Adapters for PowerCenter

This section describes new PowerCenter adapter features in version 9.6.1 HotFix 2.
Effective in version 9.6.1 HotFix 2, you can tune consistency levels when you read data from or write data to a Cassandra database. Consistency level determines how data is synchronized on all replicas. Based on your requirement of data accuracy or response time, you can set the required consistency level.
For more information, see the
Informatica PowerExchange for Cassandra 9.6.1 HotFix 2 User Guide for PowerCenter
.
Effective in version 9.6.1 HotFix 2, the MongoDB ODBC driver creates a virtual table for each column that contain arrays and nested arrays. You can use the MongoDB ODBC driver to read up to five levels of nested columns and write up to three levels of nested columns.
For more information, see the
Informatica PowerExchange for MongoDB 9.6.1 HotFix 2 User Guide for PowerCenter
.
Effective in version 9.6.1 HotFix 2, you can use PowerExchange for Salesforce Analytics to write data to Salesforce Analytics. You can then run queries on the Salesforce Analytics database to analyze the data.
For more information, see the
Informatica PowerExchange for Salesforce Analytics 9.6.1 HotFix 2 User Guide for PowerCenter
.
Effective in version 9.6.1 HotFix 2, you can perform the following tasks with PowerExchange for Vertica:
  • You can create Vertica targets in the Target Designer.
  • You can use relational mode to read large volumes of data from a Vertica source. To read data in relational mode, you must create a Vertica relational connection and configure the session to use a relational reader.
  • You can use relational mode to update or delete data in a Vertica target. To write data in relational mode, you must create a Vertica relational connection and configure the session to use a relational writer.
  • When you use bulk mode to write large volumes of data to a Vertica target, you can configure the session to create a staging file. On UNIX operating systems, when you enable file staging, you can also compress the data in a GZIP format. By compressing the data, you can reduce the size of data that is transferred over the network and improve session performance.
  • You can run sessions on a grid to improve session performance.
  • The PowerCenter Integration Service can push transformation logic to Vertica sources and targets that use native drivers. For more information, see the
    Informatica PowerCenter 9.6.1 HotFix 2 Advanced Workflow Guide
    .
For more information, see the
Informatica PowerExchange for Vertica 9.6.1 HotFix 2 User Guide for PowerCenter
.


Updated April 09, 2019