In a data connection, you can update the data and retrieve any changes to the database schema from the external data source, by performing a refresh schema action. In some cases, if there have been changes in a database to which you have existing data connections in Spotfire, you might have to refresh the schema in those connections to resolve errors.
Database changes that can require that you retrieve changes to the database schema include:
Columns have been added or removed
The data types of columns have changed
Database tables have been removed
There are also some cases in which, to update certain connections that were created in earlier versions of Spotfire and resolve compatibility issues, you must refresh the schema of those data connections.
To refresh the database schema for a connection in an analysis:
Open the analysis, and, on the menu bar, select Data > Data Connection Properties.
In the Data Connection Properties dialog, click to select the data connection of interest, and click Settings....
On the General tab of the Data Connection Settings dialog, click Refresh Schema.
To save your changes and close the dialog, click OK.
To refresh the database schema for a connection saved in the library:
On the menu bar, select Data > Manage Data Connections.
In the Manage Data Connections dialog, locate the data connection of interest, click to select it, and then click Edit.
In the Data Connection Login dialog, enter the credentials for the external data source, and then click Connect.
On the General tab of the Data Connection Settings dialog, click Refresh Schema.
To save your changes and close the dialog, click Save.