Mapping Destination

Mapping can be done by dragging the mouse pointer from Object Source node to Destination node in the O2R frame. By doing so, all the columns are mapped at a time. However, mapping of one column can be done by placing the mouse pointer on a particular column in the Object Source and dragging it to a column in the destination node.

Specifying Mapping for Destination

The Mapping tab in the destination configuration pane displays mapping table.

To map the columns, just drag and drop the source side classes to destination side tables. The mapping will be done automatically and will be visible on the right pane under the Mapping tab.

To enter a default value, click on the row of a Destination Column for which the default value is to be added and click Clear. Enter the value at Default Value column and press [Enter] key. Click Query tab and Click Apply.

Nodes Configuration_Figure 52: Mapping Destination

The mapped columns are displayed in the Mapping tab as shown in the above figure.

Generate Class and AutoMap

This option is used to generate and map classes automatically based on the table structure.

1. Select the destination table.
2. Select the required columns to be included in the class and click Apply.
3. Right-click on the destination table node and select Generate Class And Auto Map option.

Nodes Configuration_Figure 53: Generate Class and AutoMap

The class is generated automatically and is displayed under Object Source.

Once a class is automatically created by Generate Class and AutoMap option, the mapping of columns is displayed in the Mapping tab as shown below:

Nodes Configuration_Figure 54: Auto mapping of columns displayed in the Mapping tab

The Default Value can also be a column name or combinations of column names.

1. Click on the DefaultValue column. The Default Value(or)Expression dialog box appears.

   

2. Click on the ColumnNames button. The Column Names dialog box appears. Select the required column names.

   

3. Enter $ at starting and ending of expression.

   

4. Click Ok and then click on Apply button in Query tab.

   

   Configuring Auto Number for Destination Columns

   The eDapter Toolkit allows the user to configure an Auto Number for destination columns in the table.

5. After generating the class and auto mapping of columns is done, Click on the Auto Number column under Mapping tab corresponding to the destination column for which Auto Number needs to be configured. The list of Auto Numbers appear as shown below:

   

6. Select the required value from Auto Numbers list and click OK. If the column is already mapped, a message representing that the destination column is already mapped will be displayed as shown below.

   

7. Click Yes to change the mapping. The selected Auto Number will be displayed as shown below.

   

   After selecting the Auto Number, the value "Next" will be displayed as default at Sequence Value column.

   

   Select the Sequence Value as "Current" from dropdown list when the Auto Number should not be incremented and only the current Auto Number is to be used.

   

8. Click Apply in the Query tab.