Details on Repair Table

This dialog is used to repair a broken data table in a data connection. On a schema refresh, Spotfire detects that a table is missing and indicates this in the Views in Connection dialog. If you right-click on the missing table and select Repair Table, this dialog is shown.

Option

Description

Data tables in database

Lists the tables that are available in the database. If the database has a hierarchical structure, this will be reflected in the list by showing the table name preceded by the database schema it is included in.

Example:
Sales.Customer
The table Customer resides in the database schema named Sales.

Click to select the data table in the database that should replace the broken data table.

Include related data tables

Select this check box to also include all the tables that have a relation to the selected table in the database.