This example assumes that you have an analysis based on an embedded SQL Server data connection already saved in the library and you want to redirect the connection to a different database server. For example, you may have set up the analysis using a test database server but now you want to switch to a production server. The first instructions show how you can create a copy of the current test analysis. You can then change the URL to the data in the copy, while keeping the old test analysis as it is. You could just as easily skip the copy steps and edit the old analysis directly.
To copy an analysis in the library:
Open Tools > Library Administration and browse to the analysis you want to copy.
Select the analysis and, on the toolbar, click Copy.
Tip: It is also possible to select the whole folder and use the Export/Import buttons if you need to copy items between libraries on different Spotfire servers.
Select the destination folder for the copied analysis.
Click OK.
To redirect an embedded data source from a test to a production instance:
Select File > Open From > Library....
Browse to the folder where the analysis to redirect is located, select the analysis and click Open.
Go to Edit > Data Connection Properties.
Click on Settings.
Click on the Data
Source tab and click Settings....
In the Data Source Settings
dialog, click on Edit.
Response: The Microsoft SQL Server Connection dialog is opened.
Change the database server
URL to the production server URL, click Connect
and select the production database.
Click OK in all dialogs.
Response: The analysis now loads data from the new server and displays the visualizations.
See also:
What is a Connection Data Source?
How to Work with Data Connections and their Data Sources in the Library