How to Edit Data Connection Properties


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:

connect_embed_in_analysis_button.png

  1. Select Edit > Data Connection Properties.

  2. Click on the connection you want to add data tables to in the Connections list.

  3. Click on Settings....

  4. Response: The Data Connection Settings dialog is displayed.

  1. Select Edit > Data Connection Properties.

  2. Click on the connection you want to edit in the Connections list.

  3. Click on Settings....

  4. Response: The Data Connection Settings dialog is displayed.

  5. On the Data Source tab, click on Settings....

  6. Response: The Data Source Settings dialog is displayed.

  1. Select Edit > Data Connection Properties.

  2. Click on the connection you want to add data tables to in the Connections list.

  3. Click on the Settings... button.
    Response: The Data Connection Settings dialog is opened.

  4. Click on the Edit... button.

  5. Response: The Views in Connection dialog is opened.

  6. In the Available tables in database list, double-click on the tables you want to be able to work with in Spotfire.

  7. 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.

  8. When you are done, click OK.

  9. Response: The added views are shown in the Data tables views list.

  10. 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.

  1. Select Edit > Data Connection Properties.

  2. Click on the connection you want to remove data tables from in the Connections list.

  3. Click on the Settings... button.

  4. Response: The Data Connection Settings dialog is opened.

  5. Click on the Edit... button.

  6. Response: The Views in Connection dialog is opened.

  7. In the Views in connection list, click on a view you want to remove.

  8. Comment: You can also hide sub-tables in the list by clearing their corresponding check box.

  9. Click on the < Remove button.

  10. Response: The view is removed from the Views in connection list.

  11. Repeat for each view you want to remove.

  12. When you are done, click OK.

  13. 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.

  14. 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.

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.

  1. Select Edit > Data Connection Properties.

  2. Click on the connection you want to edit in the Connections list.

  3. Click on Settings....

  4. Response: The Data Connection Settings dialog is displayed.

  5. On the Data Source tab, click on Settings....

  6. Response: The Data Source Settings dialog is displayed.

  7. On the Login tab, click on the Edit... button to the right of the Data source field.

  8. Response: The connection dialog for the selected data connection is opened.

  9. Make the desired changes in the dialog and click OK when done.

  10. 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.

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.

  1. Select Edit > Data Connection Properties.

  2. Click on the connection you want to edit in the Connections list.

  3. Click on Settings....

  4. Response: The Data Connection Settings dialog is displayed.

  5. On the Data Source tab, click on Settings....

  6. Response: The Data Source Settings dialog is displayed.

  7. On the Login tab, click on the Login... button to the right of the Data source field.

  8. Response: The login dialog is opened.

  9. Enter your login information and click OK.

  10. 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.

  1. 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.

  2. Click Edit....

  3. 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