How to list all dataconnections which are saved in Spotfire library?

Created
October 08, 2021 23:21

Date Posted: 2019-02-28
Product: TIBCO Spotfire®

Problem:

Solution:

All content which you save to Spotfire library is stored in a Spotfire database.You can find list of all "dataconnections" saved to Spotfire library by querying "LIB_ITEMS" joined with table "LIB_ITEM_TYPES" or via search expression in Library Administration Tool. Solution#1: Run the following query on the Spotfire Database
---------------------------
select a.* from dbo.LIB_ITEMS a,dbo.LIB_ITEM_TYPES b where a.ITEM_TYPE=b.TYPE_ID and b.LABEL='dataconnection'
---------------------------

Note: The above query was tested on MSSQL Server Spotfire database.

Solution#2: Search for "type:dataconnection" in Spotfire Library Administration tool as mentioned in the attached screenshot.

Related articles