Data Connections

[Joed Porto]

Hey guys!

I need to know which data connections are used in various dashboards, for a migration we are planning.

Example: Oracle vs SQL server

I need to know which ones use Oracle connection, I would like to do it without having to open one by one, is there any way to do this

This information may be recorded in a spotfire sever table

[Tejas Devadkar]

Hi ,

Use the below search expression in the Library Administration search bar as per the requirement:

To find the list of analysis files using any Information Links:

type:dxp depends_on(type:query)

 

To find the list of analysis files using Information Links where you know the Data Source name:

type:dxp depends_on(type:query depends_on(type:datasource title:DataSourceName))

 

To find the list of analysis files using Information Links where you know Information Link name:

type: dxp depends_on(type::query InformationLinkName)

 

To find the list of all analysis files that uses any Data connection:

type:dxp depends_on(type:dataconnection)

 

To find the list of all analysis files that uses any Data connection where the connection name is known:

type:dxp depends_on(type:dataconnection title:SQL)

 

Probbaly the below KB article might be of help to you. If the connections are stored in the library then they could be retrieved by queryign the Spotifre Server database.

https://support.tibco.com/s/article/How-to-query-the-TIBCO-Spotfire-database-to-get-the-list-of-all-analysis-files-using-a-particular-data-connection-which-is-saved-in-a-library

 

https://support.tibco.com/s/article/How-to-identify-the-list-of-analysis-files-using-a-particular-Information-Link-or-data-connection-as-Data-Source

 

Applciation Profiler

https://support.tibco.com/s/article/How-to-get-list-of-Table-Columns-and-Datasource-information-for-an-analysis-file

 

If you want any specific question you could also raise a support ticket onsupport.tibco.com for quick assistance.

[Joed Porto]

Tks Tejas helped me a lot.