Spotfire Server: How to retrieve SQL queries used by Information Links that are not saved in Spotfire Library

Question:

Is it possible to retrieve SQL queries used by Information Links that are not saved in Spotfire Library?

Answer:

Information Links that are embedded in analyses, without being saved in Spotfire Library, are also known as "anonymous" Information Links. These Information Links appear in Data-> Data Table properties under Source tab as type "Information link not saved in the library":

These Information Links are stored in analysis files as serialized data Element objects. Their SQL query, however, is not stored anywhere - it always gets created dynamically at runtime. Unfortunately, this means that the only way to see their SQL queries is to execute them and retrieve these queries from sql.log file on Spotfire Server.

Currently, there is no way to save or convert "anonymous" Information Links to standard Information Link objects that can be saved in the Library. The only option is to execute them, find their SQL queries (in sql.log), then create new Information Links and save those new objects in the Library.

The only way "anonymous" Information Links can be created is as follows:

1. Open Spotfire Analyst client, then Data menu-> Information Designer.

2. Create a new Information Link, but instead of saving it, select "Open Data" button.

3. Close Information Designer without saving the new Information Link.

4. Save current analysis file, which now contains the unsaved Information Link and the data retrieved from it.