Refreshing the database schema in a data connection

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.

About this task

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

Note: 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 in a connection, you must use a Spotfire installed client.

Refreshing the database schema for a connection in an analysis

Procedure

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.
Click OK to save your changes and close the dialog.

Refreshing the database schema for a connection saved in the library

Procedure

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.
Click Save to save your changes and close the dialog.