Synchronizing Data to a New Table

You can create a table on OData warehouse, and synchronize data to the new 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 new table.
  3. In the field next to Sync to new table, enter a name for the new table.
  4. Create a field mapping between the source columns in TIBCO Clarity and the target columns on OData warehouse.
    1. Select the columns you want to export to OData warehouse by selecting the check boxes next to them.
    2. In the Table Column Name fields, enter names or accept default values for columns of the new table on OData warehouse.
    3. From the Type lists, select data types for columns of the new table on OData warehouse.
      Note: The types supported by TIBCO Clarity are displayed in the lists. See OData Primitive Types for more details.
    4. Select one or more Key check boxes to indicate one or more keys of the table.
      Note: You must indicate at lease one column as the key of the table.
  5. Click Done.

What to do next

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