If you are accessing Amazon Redshift using the Amazon Redshift V1 connection or the Amazon Redshift ODBC connection, you can upgrade to the newer Amazon Redshift V2 Connector. You can replace the source or target connection type in existing mappings and mapping tasks that use the Amazon Redshift connection or the Amazon Redshift ODBC connection with the Amazon Redshift V2 connection.
After you replace the connection in an existing mapping, the object selected previously is not retained. You must reimport the Amazon Redshift object. The configured advanced source, target, and lookup properties in the fields that are common between the two connectors are retained in the new connector. You also have the option to retain the configured field mappings from the old connector.
You can run the mapping successfully using the configured values from the old connector. You can additionally configure features that the enhanced Amazon Redshift V2 Connector offers.
If you are using the Amazon Redshift V1 connection in mappings to read from or write data to Amazon Redshift, Informatica recommends you to use the Amazon Redshift V2 connection to make use of the features that the enhanced connector offers. To get the license for Amazon Redshift V2 Connector, contact Global Customer support.