Modifying table and column mappings

Table mappings indicate which tables should be synchronized, how tables should be synchronized, and how the synchronized data should be mapped between the remote and consolidated databases.

Upload-only, download-only, and non-synchronized tables or columns

By default, MobiLink does a complete, bi-directional synchronization. You can change each table to be upload-only or download-only. You can also choose to not synchronize a table.

In a model, you can only specify tables as download-only; you cannot create download-only publications. This is because a model can have only one publication.

To change the table mapping direction
  1. In Model mode, open the Mappings tab.

  2. In the Table Mappings pane, select a remote table.

  3. In the Mapping Direction dropdown list, select one of the following:

    • Bi-directional

    • Upload to consolidated only

    • Download to remote only

    • Not synchronized

    Caution

    By default, shadow tables are not synchronized. Do not attempt to synchronize them.

  4. If necessary, select a consolidated table to map to from the Consolidated Table dropdown list.

To not synchronize a column
  1. In Model mode, open the Mappings tab.

  2. In the Table Mappings pane, select a table.

    Column information for the table appears in the Column Mappings tab in the lower pane.

  3. Select a column.

  4. In the Mapping Direction dropdown list, choose Not Synchronized.

    Note that primary keys must be synchronized.

Changing table and column mappings

If your model is based on an existing remote database, the column mappings represent a best guess. You should check them and customize them as required.

To change table mappings
  1. In Model mode, open the Mappings tab.

  2. In the Table Mappings pane, select a table.

  3. To change the consolidated table that is mapped: From the Consolidated Table dropdown list, select a different table.

  4. To change the remote table that is mapped:

  5. To change column mappings for a table: Select the table, and open the Column Mappings tab in the lower pane.