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

Configuring a stored procedure

Configuring a stored procedure

You can configure a SQL transformation to process a stored procedure on the
SQL
tab of the SQL transformation.
Add a SQL transformation in an Amazon Redshift mapping.
Configure a mapping with the Source, Target, and SQL transformations.
Perform the following tasks in the SQL transformation:
  1. Enter a name and description for the SQL transformation.
  2. In the
    Incoming Fields
    tab, define field rules that determine the data to include in the transformation.
  3. In the
    Properties
    panel of the SQL transformation, click the
    SQL
    tab.
  4. On the
    SQL
    tab, perform the following tasks:
    1. Select the connection to the database.
      You can select the connection or use a parameter.
    2. Set the SQL type to
      Stored Procedure
      .
    3. Click
      Select
      to select the stored procedure from the database, or enter the exact name of the stored procedure to call.
      The stored procedure name is case-sensitive.
      If you add a new stored procedure to the database while you have the mapping open, the new stored procedure does not appear in the list of available stored procedures. To refresh the list, close and reopen the mapping.
    The following image shows the configured SQL transformation properties:
    Select the SQL Type as Stored Procedure and select a stored procedure.
  5. On the
    Field Mapping
    tab, specify how to map incoming fields to the input fields of the selected stored procedure.
  6. Define advanced properties for the transformation according to your requirement.