Table of Contents

Search

  1. Preface
  2. Mappings
  3. Mapping tutorial
  4. Parameters
  5. CLAIRE recommendations
  6. Data catalog discovery
  7. Visio templates

Mappings

Mappings

Step 3. Create the mapping task

Step 3. Create the
mapping
task

To process data using the Date to String Visio template, create a
mapping
task.
  1. Click
    New
    Tasks
    Mapping Task.
    and click
    OK
    .
  2. Configure the task details as follows and click
    Next
    .
    Task detail
    Value
    Task Name
    Date to String
    Location
    Browse to the folder where you want to store the Date to String
    mapping
    task or use the default location.
    Runtime Environment
    Select the runtime environment that contains the Secure Agent to use to run the task.
    Mapping
    Click
    Select
    and browse to the Visio template, and then click
    Select
    .
    After you select the template, the template image displays.
  3. On the
    Sources
    page, select a source connection and source object, and click
    Next
    .
    Based on the template parameter properties, the wizard displays only database connections.
  4. On the
    Targets
    page, select a target connection and target object, and click
    Next
    .
    Based on the template parameter properties, the wizard displays file and database connections.
  5. On the
    Input Parameters
    page, enter the date format that you want to use for $fromdateformat$.
    For example: yyyy-mm-dd.
  6. Enter the date format that you want to use for $todateformat$ and click
    Next
    .
    For example: mm-dd-yyyy.
  7. On the
    Schedule
    page, select schedule details, email notification options, advanced options, and click
    Save
    .
When you run the task, the Secure Agent reads data from the source, converts dates to the new format, and writes data to the selected target.

0 COMMENTS

We’d like to hear from you!