JDBC V2 Connector > Mappings and elastic mappings in JDBC V2 Connector > Elastic mapping task example
  

Elastic mapping task 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 an elastic mapping that runs on the elastic cluster to achieve faster performance when you read data from the hospital branches and write data to the Aurora PostgreSQL target.
    1. In Data Integration, click New > Mappings > Elastic Mapping > Create.
    The New Mapping dialog box appears.
    2. Enter a name, location, and description for the mapping.
    3. In 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 source:
    1. a. In the Connection field, select the required source connection.
    2. b. In the Source Type field, select the type of the source.
    3. c. In the Object field, select the required object.
    4. d. In the Advanced Properties section, provide the appropriate values.
    5. In the Target transformation, specify a name and description in the general properties.
    6. On the Target tab, perform the following steps to provide the target details to write data to the Amazon S3 target:
    1. a. In the Connection field, select the JDBC V2 target connection.
    2. b. In the Target Type field, select the type of the target.
    3. c. In the Object field, select the required object.
    4. d. In the Operation field, select the required operation.
    5. e. In the Advanced Properties section, provide appropriate values for the advanced target properties.
    7. Click Save > Run the mapping.
    In Monitor, you can monitor the status of the logs after you run the mapping.