Table of Contents

Search

  1. Preface
  2. Part 1: Version 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 Informatica

PowerExchange Adapters for Informatica

This section describes new Informatica adapter features in version 9.6.1 HotFix 2.

PowerExchange for Cassandra

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
.

PowerExchange for LinkedIn

Effective in version 9.6.1 HotFix 2, PowerExchange for LinkedIn secures all API calls to LinkedIn by using HTTPS URLs.
For more information, see the
Informatica PowerExchange for LinkedIn 9.6.1 HotFix 2 User Guide
.

PowerExchange for DataSift

Effective in version 9.6.1 HotFix 2, PowerExchange for DataSift has the following new features and enhancements:
  • You can retrieve data from the DataSift buffer.
  • You can pause and resume the Historics query.
  • You can set the maximum number of attempts to re-establish a connection to DataSift if a connection fails.
For more information, see the
Informatica PowerExchange for DataSift 9.6.1 HotFix 2 User Guide
.

PowerExchange for Hive

Effective in version 9.6.1 HotFix 2, PowerExchange for Hive has the following new features and enhancements:
  • You can use the user-defined functions in Informatica to transform the Binary data type in a Hive environment.
  • PowerExchange for Hive processes sources and targets that contain the Timestamp data type. The Timestamp data type format is YYYY-MM-DD HH:MM:SS.fffffffff. The Timestamp data type has a precision of 29 and a scale of 9.
  • PowerExchange for Hive processes sources and targets that contain the Date data type. The Date data type has a range of 0000-01-01 to 9999-12-31. The format is YYYY-MM-DD. The Date data type has a precision of 10 and a scale of 0.
For more information, see the
Informatica PowerExchange for Hive 9.6.1 HotFix 2 User Guide
.

PowerExchange for MongoDB

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
.

PowerExchange for Salesforce

Effective in version 9.6.1 HotFix 2, PowerExchange for Salesforce has the following new features and enhancements:
  • You can configure PowerExchange for Salesforce to capture changed data from a Salesforce object that is replicateable and contains the CreatedDate and SysModstamp fields.
  • You can use PowerExchange for Salesforce to connect to Salesforce API v30 and v31.
  • The Data Integration Service can push Filter transformation logic to Salesforce sources.
For more information, see the
Informatica PowerExchange for Salesforce 9.6.1 HotFix 2 User Guide
.


Updated September 25, 2020