At times there might be a need to identify all data sources in the information services that are based on a specific JDBC / Data source template inorder to modity/edit only those data sources or for troubleshooting purposes. It can be a very time consuming to navigate through each data source in the Information Designer individually and check the JDBC template it's based on. 

All

Method 1: (Only works in Spotfire 12.5 and Higher)
Do a search in the Information Designer search window by TypeName or DriverClass. You can get this information in the Data Source Templates from the configuration tool.

Example: 

Search by Template name: 
Spotfire.DataSourceTemplate.TypeName::sqlserver2005

Search by Driver class:
Spotfire.DataSourceTemplate.DriverClass::com.microsoft.sqlserver.jdbc.SQLServerDriver

Method 2: (12.0 and Higher) 
Go to the the installed Analyst client, open Information Designer and right-click anywhere in the Data Sources tab and select "Copy List of Data Sources to Clipboard". The clipboard data obtained provides information about the current data sources and it can be analyzed using the Spotfire client. A column named "Data Source Type" is generated which can provide you with the required information.

The topic of this article is how to locate all data sources that are based on a specific data source template in the Information Services.

Doc: Migrating from TIBCO-branded DataDirect JDBC drivers

• https://docs.tibco.com/pub/spotfire_server/latest/doc/html/TIB_sfire_server_tsas_admin_help/server/topics/migrating_data_direct_drivers.html