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

Elastic mapping example

Elastic mapping
example

You work for an organization that stores large amount of purchase order details, such as customer ID, item codes, and item quantity in Amazon S3. You need to port the data from Amazon S3 to another cloud-based environment to quickly analyze the purchase order details and to increase future revenues.
Create an
elastic mapping
that runs on the
elastic cluster
to achieve faster performance when you read all the purchase records from Amazon S3 and write the records to an Amazon Redshift target.
  1. In Data Integration, click
    New
    Mappings
    elastic cluster
    Create
    .
    The
    New Mapping
    dialog box appears.
  2. Enter a name, location, and description for the mapping.
  3. On the Source transformation, specify a name and description in the general properties.
  4. On the
    Source
    tab, perform the following steps to provide the source details to read data from the Amazon S3 source:
    1. In the
      Connection
      field, select the Amazon S3 V2 source connection.
    2. In the
      Source Type
      field, select the type of the source.
    3. In the
      Object
      field, select the required object.
    4. In the
      Advanced Properties
      section, provide the appropriate values.
  5. On the
    Fields
    tab, map the Amazon S3 source fields to the target fields.
  6. On the Target transformation, specify a name and description in the general properties.
  7. On the
    Target
    tab, perform the following steps to provide the target details to write data to the Amazon Redshift target:
    1. In the
      Connection
      field, select the Amazon Redshift V2 target connection.
    2. In the
      Target Type
      field, select the type of the target.
    3. In the
      Object
      field, select the required object.
    4. In the
      Operation
      field, select the required operation.
    5. In the
      Advanced Properties
      section, provide appropriate values for the advanced target properties.
  8. Map the Amazon S3 source and the Amazon Redshift target.
  9. Click
    Save
    Run
    to validate the mapping.
    In Monitor, you can monitor the status of the logs after you run the task.