Documentation on Spotfire Database tables

[Sharon]

Is there documentation / data dictionary available for the various tables in the Spotfire database? e.g. LIB_ITEMS, LIB_ITEM_TYPES 

I'm looking for descriptions of each table and the columns within them.

[David Boot-Olazabal]

Hi Sharon,

The Spotfire database's internal structure is not documented (at least officially) since it is not a public artefact. The reason for this, is that it may change across versions (new tables/views, etc).
And we want to shield our users from having to go through the 'pain' of having to adapt their analysis/queries accordingly.

Having said that, we could support specific questions, with the caveat of having to change them in the future.

So, if you have any specific question, feel free to ask and we will see if we can help out. In the meantime, we also asked internally about your general question, but tat could take a bit more time to get feedback on.

Kind regards,

David

[Olivier Keugue Tadaa]

Hi Sharon,
The Spotfire database's internal structure is not documented (at least officially) since it is not a public artifact. Indeed it is supposed to change across versions.
We can help provide some information (from our internal design documents). However, whatever you develop on top of it might become obsolete very soon.
Could you let us know what is your intention? We might have the same result using the public and official server API.

[Sharon]

Hi David, Oliver,

My specific use cases are:

- Extract library hierarchy: for each object in Spotfire, identify its parents recursively all the way up to the root folder. 

- Extract permissions: for each object in Spotfire, identify what permissions have been granted to groups/ individual users.

Since the database may change, is there a way to get this info through the APIs?

[Olivier Keugue Tadaa]

Hi Sharon,

All that information is available with the server API. However, it is a development project that requires some knowledge of the API.

Meanwhile, attached is an IronPython script where you can find some inspiration.

I hope it will help

👉The link to the server API documentation https://docs.tibco.com/pub/spotfire_server/14.4.0/doc/api/TIB_sfire_server_Server_API_Reference/index.html
and https://docs.tibco.com/pub/spotfire_server/14.4.0/doc/api/TIB_sfire_server_WebServices_API_Reference/com/spotfire/ws/pub/package-summary.html

 

 

loadcontent2.py

Edited August 9 by Olivier Keugue Tadaa