Synchronizing Data to an Existing Table

You can specify an existing table on OData warehouse, and synchronize data to the specified table.

Prerequisites

In the enterprise edition, ensure that a valid connection to OData warehouse is created before synchronizing. See Configuring OData Warehouse for more details.

Procedure

  1. On the project data page, click OData > Export to warehouse.
  2. Click Sync to existing table radio button.
  3. From the list next to the Sync to existing table radio button, select a target table.
    The column names of specified table are displayed in the Tables list.
  4. Map the source columns to the destination columns.
    • Automatic mapping: click Auto map.
    • Manual mapping: drag the source and destination columns to the mapping area manually.
    Note: You can click Clear all mapping to initialize the field mapping.
  5. Click Done.

What to do next

Click OData Warehouse > Exporting history to check, download, or delete the history of exporting data to warehouse.