Managing Table Mappings

Mapping Overview

Before creating a job, you need to create a mapping to map the table structures of the source and destination databases, facilitating data migration between databases.

Creating a Table Mapping

1. Log in to the GaussDB(DWS) console.
2. In the navigation pane, choose Data > Data Integration > Table Mappings.
3. Click Create Table Mapping.

   

   

4. Configure parameters.
   1. Click in the list on the left. Configure Table Mapping Name, Source Table, and Target Table.
   2. Click in the list on the right and configure the parameters.
      

      If no column mappings are specified in the list on the right, all the columns with the same name will be mapped with by default.

5. Confirm the information and click OK.

Modifying a Table Mapping

1. Log in to the GaussDB(DWS) console.
2. In the navigation pane, choose Data > Data Integration > Table Mappings.
3. In the Operation column of a table mapping, click Modify.
   Figure 1 Modifying table mapping configurations
   

4. In the Modify Table Mapping dialog box, configure Table Mapping Name, Source Table, and Target Table.
5. Confirm the information and click OK.

Checking a Table Mapping

1. Log in to the GaussDB(DWS) console.
2. In the navigation pane, choose Data > Data Integration > Table Mappings.
3. In the Operation column of a table mapping, click Modify.
4. In the Modify Table Mapping dialog box, click the Jobs tab to view the bound jobs.

Deleting a Table Mapping

1. Log in to the GaussDB(DWS) console.
2. In the navigation pane, choose Data > Data Integration > Table Mappings.
3. In the Operation column of a table mapping, click Delete.
4. In the displayed dialog box, click OK.