JDBC V2 Connector

JDBC V2 Connector

Mappings in advanced mode example

Mappings in advanced mode example

You work for a multi-national hospital that maintains medical records of patient emergencies for more than 50 specialties in their database across the globe. The hospital has more than 10,000 units spread across 500 locations.
Medical investigators from the hospital want to analyze the medical data of the treatment performance of specific inpatient hospital events within the hospitals. The management wants to use this analysis to provide better care for patients and help achieve health equity.
To avoid low performance and high-cost challenges, the hospital plans to port its entire data from all the hospital branches spread globally to Aurora PostgreSQL within a short span of time. Create a mapping in advanced mode to read data from the hospital branches and write data to the Aurora PostgreSQL target.
  1. In
    Data Integration
    , click
    New
    Mappings
    Mapping
    .
    The
    New Mapping
    dialog box appears.
  2. In the Mapping Designer, click
    Switch to Advanced
    .
    The following image shows the
    Switch to Advanced
    button in the Mapping Designer:
    In the Mapping Designer, the header includes the Switch to Advanced button.
  3. In the
    Switch to Advanced
    dialog box, click
    Switch to Advanced
    .
    The Mapping Designer updates the mapping canvas to display the transformations and functions that are available in advanced mode.
  4. Enter a name, location, and description for the mapping.
  5. Add a Source transformation, and specify a name and description in the general properties.
  6. On the
    Source
    tab, perform the following steps to provide the source details to read data from the source:
    1. In the
      Connection
      field, select the required 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.
  7. Add a Target transformation, and specify a name and description in the general properties.
  8. On the
    Target
    tab, perform the following steps to provide the target details to write data to the Amazon S3 target:
    1. In the
      Connection
      field, select the JDBC 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.
  9. Click
    Save
    Run
    the mapping.
    In Monitor, you can monitor the status of the logs after you run the mapping.

0 COMMENTS

We’d like to hear from you!