PowerExchange Adapters for Informatica
This section describes changes to Informatica adapters in version 10.2.1.
PowerExchange for Amazon Redshift
Effective in version 10.2.1, after you connect to PowerExchange for Amazon Redshift, the following prerequisite tasks are completed automatically:
- •The required Amazon Redshift JDBC .jar file are downloaded.
- •The .jar file are copied on the node that runs on the Data Integration Service and on the client machine.
Previously, you had to perform the prerequisite tasks manually and restart the Data Integration Service before you can use PowerExchange for Amazon Redshift.
PowerExchange for Cassandra
Effective in version 10.2.1, PowerExchange for Cassandra has the following changes:
- •The name and directory of the Informatica PowerExchange for Cassandra ODBC driver file has changed.
The following table lists the Cassandra ODBC driver file name and file directory based on Linux and Windows operating systems:
Operating System | Cassandra ODBC Driver File Name | File Directory |
|---|
Linux | libcassandraodbc_sb64.so | <Informatica installation directory>\tools\cassandra\lib\libcassandraodbc_sb64.so |
Windows | CassandraODBC_sb64.dll | <Informatica installation directory>\tools\cassandra\lib\CassandraODBC_sb64.dll |
On Linux operating systems, you must update the value of the Driver property to <Informatica installation directory>\tools\cassandra\lib\libcassandraodbc_sb64.so for the existing Cassandra data sources in the odbc.ini file.
On Windows, you must update the following properties in the Windows registry for the existing Cassandra data source name:
Driver=<Informatica installation directory>\tools\cassandra\lib\CassandraODBC_sb64.dll
Setup=<Informatica installation directory>\tools\cassandra\lib\CassandraODBC_sb64.dll
- •The new key name for Load Balancing Policy option is LoadBalancingPolicy.
Previously, the key name for Load Balancing Policy was COLoadBalancingPolicy
- •The default values of the following Cassandra ODBC driver properties has changed:
Driver Property Name | Key Name | New Default Value |
|---|
Concurrent Requests | NumConcurrentRequests | 100 |
Insert Query Threads | NumInsertQueryThreads | 2 |
Iterations Per Insert Thread | NumIterationsPerInsertThread | 50 |
For more information, see the Informatica PowerExchange for Cassandra 10.2.1 User Guide.
PowerExchange for Snowflake
Effective in version 10.2.1, PowerExchange for Snowflake installs with Informatica 10.2.1.
Previously, PowerExchange for Snowflake had a separate installer.
For more information, see the Informatica PowerExchange for Snowflake 10.2.1 User Guide .