How to search for the Data Connections and Connection Data Sources saved in the TIBCO Spotfire library based on server/hostname, database name or the selected views in the connections

book

Article ID: KB0070876

calendar_today

Updated On:

Products	Versions
Spotfire Analyst	10.0 and higher

Description

This article describes how to search for the server/hostname, database name, or the selected views in the Data Connections or Connection Data sources which are saved in the TIBCO Spotfire library.

Issue/Introduction

The library properties Spotfire.ConnectionSourceServer, Spotfire.ConnectionSourceDatabase, Spotfire.ConnectionViews can be used to search for Data Connections and Connection Data Sources saved in the TIBCO Spotfire library using those specified properties.

Resolution

When searching the TIBCO Spotfire library via the Library Administration or Information Designer tools, the following library properties can be used to search for the data connections or connection data sources that are using specific details:

Spotfire.ConnectionSourceServer:<servername>

This search string is used to search for all the Data Connections and Connection Data Sources connected to the specified servername

Spotfire.ConnectionSourceDatabase:<databasename>

This search string is used to search for all the Data Connections & Connection Data Sources where the specified databasename is selected

Spotfire.ConnectionViews:<viewnames>

This search string is used to search for all the Data Connections in which the specified views are selected (does not apply for connection data sources)

Spotfire.Connector:<connectortypename>