Table of Contents

Search

  1. Preface
  2. Introduction to PowerExchange for Amazon S3
  3. PowerExchange for Amazon S3 Configuration Overview
  4. Amazon S3 Connections
  5. PowerExchange for Amazon S3 Data Objects
  6. PowerExchange for Amazon S3 Mappings
  7. PowerExchange for Amazon S3 Lookups
  8. Appendix A: Amazon S3 Data Type Reference
  9. Appendix B: Troubleshooting

PowerExchange for Amazon S3 User Guide

PowerExchange for Amazon S3 User Guide

Amazon S3 Dynamic Mapping Example

Amazon S3 Dynamic Mapping Example

Your organization has a large amount of data that keeps changing. Your organization needs to incorporate all the updated data in a short span of time. Create a dynamic mapping, where you can refresh the source schema dynamically to fetch the updated data. Add all the dynamic ports to the target to override the metadata of the existing ports.
  1. Import the Amazon S3 read and write data objects.
  2. Select a project or folder in the
    Object Explorer
    view.
  3. Click
    File
    New
    Mapping.
    The
    Mapping
    dialog box appears.
  4. Enter the name of the mapping in the
    Name
    field.
  5. Click
    Finish
    .
  6. Drag the data object into a mapping.
    The
    AmazonS3 Data Object Access
    dialog box appears.
  7. Select the
    Read
    option and click
    OK
    .
  8. In the
    Data Object
    tab, select the
    At runtime, get data object columns from data source
    check box.
  9. Drag the data object into a mapping.
    The
    AmazonS3 Data Object Acess
    dialog box appears.
  10. Select the
    Write
    option and click
    OK
    .
  11. In the
    Ports
    tab, select the value of the
    Columns defined by
    as
    Mapping Flow
    .
  12. Select all the source ports and add the ports to the target.
  13. Save and run the mapping.

0 COMMENTS

We’d like to hear from you!