how to get the metadata information from Spotfire Database ?

[ISKG]

Hi Folks, Need your expertise on how to get the metadata information from Spotfire Database ? Can any share the list of tables available in Spotfire v14.0

[David Boot-Olazabal]

Hi,

Please see this earlier topic on the same:

If you want the list of available tables and views from the Spotfire library database, you could:
- check the installation script (not really in handy format though);
- run a query on the database itself.

In the latter case, you can use this command for SQL Server:
SELECT
    *
FROM
    information_schema.tables;

This command can be used for Oracle:

SELECT 
    table_name
FROM
    dba_tables;

In both cases, you have to use the spotfire_server database as current one, so you'll see the proper list of tables and views.
If possible, I would advise the query approach on the database. Either directly n a SQL Developer tool or in Spotfire: create a direct connection (ODBC) to the Spotfire database and then create a custom query, using the examples above (you probably need to remove the ; at the end of the sql statement, as Spotfire doesn't like that one).

Kind regards,

David