Hi, I'm Ask INFA!
What would you like to know?
ASK INFAPreview
Please to access Ask INFA.
Not Found
English

Page Not Found

The page or file you are looking for has been moved or no longer exists.

The following links might help you find the content you need:


You can also search the Documentation Portal or visit the home page.

English
  • Data Integration Connectors
  • All Products

Table of Contents

Search

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

Amazon Redshift Connectors

Amazon Redshift Connectors

Back Next

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.
0 COMMENTS
We’d like to hear from you!