Connector Release Notes

Connector Release Notes

Amazon Redshift V2 Connector

Amazon Redshift V2 Connector

Fixed issues

The following table describes fixed issues:
CR
Description
CCON-29000
When you use a view that you created on an external table, the mapping fails for numeric and character data types with the following error:
Internal error. The native type system does not support the data type [numeric(2,0)] in the native metadata field. Contact Informatica Global Customer Support.
(February 2021)
CCON-28801
When you run a query that contains a dollar ($) symbol and the identifier name is not enclosed within double quotes, the mapping fails with the following error:
Invalid operation: cannot insert multiple commands into a prepared statement
Workaround: Enclose the identifier name within double quotes or upgrade the Redshift JDBC jar.
Upgrade the Redshift JDBC jar to
RedshiftJDBC42-no-awssdk-1.2.50.1077.jar
and the dependent jar to
antlr4-4.5.3.jar
. Remove the existing Redshift JDBC jar
RedshiftJDBC42-no-awssdk-1.2.47.1071.jar
.
(February 2021)
CCON-28189
When the source type is multiple objects and you apply a filter condition on a related object, the mapping fails. (February 2021)
CCON-20054
When you configure a source filter under
Query Options
on any field in the source object, the Secure Agent converts boolean values to zero in the target object. (February 2021)

Known issues

The following table describes known issues:
CR
Description
CCON-27072
When the source table name contains unicode or special characters and you select an existing target or create a target, the elastic mapping fails. (October 2020)


Updated February 11, 2021