Note: Only data connections and connection data sources that are embedded can be edited within the context of the analysis. For connections that are shared in the library, use the Manage Data Connections tool instead.
However, all data connections and connection data sources can be embedded, if desired. Click on the Embed in Analysis button in the Data Connection Settings and the Embed in Connection button in the Data Source Settings dialogs if you still have to edit data connection properties within the analysis:
To reach the Data Connection Settings dialog:
Select Edit > Data Connection Properties.
Click on the connection you want to add data tables to in the Connections list.
Click on Settings....
Response: The Data Connection Settings dialog is displayed.
To reach the Data Source Settings dialog:
Select Edit > Data Connection Properties.
Click on the connection you want to edit in the Connections list.
Click on Settings....
Response: The Data Connection Settings dialog is displayed.
On the Data Source tab, click on Settings....
Response: The Data Source Settings dialog is displayed.
To add views to an embedded data connection:
Select Edit > Data Connection Properties.
Click on the connection you want to add data tables to in the Connections list.
Click on the Settings...
button.
Response: The Data
Connection Settings dialog is opened.
Click on the Edit... button.
Response: The Views in Connection dialog is opened.
In the Available tables in database list, double-click on the tables you want to be able to work with in Spotfire.
Response: The tables are moved to the Views in connection list.
Comment: Click on an item in the Views in connection list to see the columns in the selected view. You can clear the check box for columns you want to exclude from the view and, hence, any data tables built on this view.
Comment: If the Available tables in database does not show all the tables in the database, you can click on the Edit Tables... button to open the Select Database Tables dialog where you can add more tables. This may require a higher level of database permissions.
When you are done, click OK.
Response: The added views are shown in the Data tables views list.
Click OK.
Note: Use Add Data Tables > From Analysis to add a new data table from a connection that has already been added to the analysis, after you have added new views to the connection.
To remove views from an embedded data connection:
Select Edit > Data Connection Properties.
Click on the connection you want to remove data tables from in the Connections list.
Click on the Settings... button.
Response: The Data Connection Settings dialog is opened.
Click on the Edit... button.
Response: The Views in Connection dialog is opened.
In the Views in connection list, click on a view you want to remove.
Comment: You can also hide sub-tables in the list by clearing their corresponding check box.
Click on the < Remove button.
Response: The view is removed from the Views in connection list.
Repeat for each view you want to remove.
When you are done, click OK.
Response: If the removed views are used to create data tables in the analysis, you will be prompted to remove the data tables or to confirm that they will become empty.
Click OK twice to close the Data Connection Settings dialog and the Data Connection Properties dialog.
Note: You can remove data tables at any time using Edit > Data Table Properties. This will not affect the views available in the connection and all views in the connection can be used to add data tables again using Add Data Tables > From Current Analysis.
To edit the data source configuration of an embedded data connection:
If you need to change any settings regarding how the connection to the data source is made, you can reach the Data Source Settings dialog for each connection from the Data Connection Properties dialog. For example, you may need to switch from a test environment to a production environment. However, make sure not to change the connection settings unless necessary, since visualizations using the selected data connection will become invalid if the data source connection fails.
Select Edit > Data Connection Properties.
Click on the connection you want to edit in the Connections list.
Click on Settings....
Response: The Data Connection Settings dialog is displayed.
On the Data Source tab, click on Settings....
Response: The Data Source Settings dialog is displayed.
On the Login tab, click on the Edit... button to the right of the Data source field.
Response: The connection dialog for the selected data connection is opened.
Make the desired changes in the dialog and click OK when done.
Response: The data connection is updated with the changes. Note that some types of changes need to be followed by a Refresh Schema operation (see below) and possibly also an update of the available data tables.
To update login information:
If you have skipped to log in when opening an analysis, or if you need to update an expired password in an analysis, you can reach the Data Source Settings dialog for each connection from the Data Connection Properties dialog.
Select Edit > Data Connection Properties.
Click on the connection you want to edit in the Connections list.
Click on Settings....
Response: The Data Connection Settings dialog is displayed.
On the Data Source tab, click on Settings....
Response: The Data Source Settings dialog is displayed.
On the Login tab, click on the Login... button to the right of the Data source field.
Response: The login dialog is opened.
Enter your login information and click OK.
Response: The data connection is updated with the changes.
Refreshing data:
To refresh data from the database, open the Data Connection Properties dialog, and click on the data connection of interest in the Connections list.
Click Refresh Data if you want the reload to include only changes in the rows of the data in the selected connection, for example, added or removed rows.
If you need a more extensive reload of the data you might be able to perform a refresh of the entire schema. This is done in the Data Connection Settings dialog, on the General tab. Click Refresh Schema. This will include updates in the underlying schema, added or removed columns, or changes in structural relations. However, Custom Queries are not validated upon a schema refresh, only actual database tables. To refresh a custom query you need to return to the Custom Query dialog and run Verify again. Note that permissions set on the database server may prevent you from using Refresh Schema.
Go to the Data Connection Settings dialog for the data connection containing the view based on a custom query, as described at the top of the page.
Click Edit....
In the Views in Connection dialog, select the custom query table you wish to edit and then click Custom Query > Edit Custom Query....
See also:
Data Connection Settings – General
Data Connection Settings – Data Source
Data Connection Settings – Cache Settings