Skip to Main Content
Spotfire Ideas Portal
Status Future Consideration
Product Spotfire
Categories Library
Created by Guest
Created on Jun 9, 2017
Merged idea
This idea has been merged into another idea. To comment or vote on this idea, please visit SPF-I-149 Find dependencies within an analysis.

admin overview of data sources Merged

For data security and administration purposes it would be useful to have the possibility to create an overview of the data sources with items like source, username, authentication method, location in library, used in - information. this may be, but is not directly covered by https://ideas.tibco.com/ideas/SPF-I-441

  • Guest
    Reply
    |
    May 22, 2019

    Christian, Thanks the queries are helpful. Is there however a way to determine columns in a data table when a data connection is used in a report? The metadata approach will help as there are 1000+ reports and it is not feasible to use Py code in each report to get the information.

  • Guest
    Reply
    |
    Jul 3, 2017

    Hi, I believe you should be able to see this wiki page, let me know if you can't:

    https://community.tibco.com/wiki/spotfire-metadata-queries

  • Guest
    Reply
    |
    Jul 3, 2017

    Christian, I understand that this is a query outside Spotfire? Since this would be a proprietary solution I suggest you share it for TIBCO to use for their easier built of a solution for all.

    Thanks.

  • Guest
    Reply
    |
    Jun 30, 2017

    Christian, would you mind sharing the query?

    Thanks!

  • Guest
    Reply
    |
    Jun 30, 2017

    What database are you using for the Spotfire metadata? I have a query that gives all of this but it's for ORacle only...

  • Guest
    Reply
    |
    Jun 15, 2017

    Also consider adding driver used, and maybe driver version.