Table of Contents

Search

  1. Preface
  2. Part 1: Introduction to Amazon Redshift connectors
  3. Part 2: Data Integration with Amazon Redshift V2 Connector
  4. Part 3: Data Integration with Amazon Redshift Connector

Amazon Redshift Connectors

Amazon Redshift Connectors

Rules and guidelines for creating a target

Rules and guidelines for creating a target

Consider the following rules and guidelines when you create a target:
  • When you create a target if the source table contains column of Text data type, the Secure Agent displays the following error message:
    Unsupported datatype - 'text' for column 'LONGTXTAREA__C'
    You must edit the data type of the source column in the Source transformation.
  • You cannot parameterize the target at runtime.
  • When you create a target and specify a table name or column name in uppercase or mixed case alphabets, the Secure Agent converts the target table name or column name into lowercase alphabets and the mapping task runs successfully. However, the tomcat log shows the following error message:
    An unexpected exception occured while fetching metadata:[The following object is not found].