Identifying a list of external connection data sources saved in Spotfire Library

Identifying a list of external connection data sources saved in Spotfire Library

This article suggests a SQL query that can be executed against the Spotfire housekeeping database to identify a list of external connection data sources saved in Spotfire Library. The 'Save to Library' option in the Data Source settings allows you to publish an embedded data source to the library, so that it may be reused in other analyses or by other people. Such data sources published to the library can be queried by the below SQL query:
 
----------------------------- 
SELECT *
FROM lib_items
WHERE item_type = (
                  SELECT type_id
                  FROM lib_item_types
                  WHERE LABEL = 'connectiondatasource'
                  )
 
----------------------------

Disclaimer: The content of this article is for informational purposes only. The subject material may change in any new versions with no notice and there is no responsibility by TIBCO to maintain or support future access to this internal application content. Modification of any internal application content is not recommended and can lead to an unsupported configuration.  It is not intended to be used "As Is" in a Production environment. Always test in a Development environment first. https://docs.tibco.com/pub/sfire-analyst/7.11.1/doc/html/en-US/TIB_sfire-analyst_UsersGuide/connect/connect_details_on_data_source_settings_login.htm