By default, materialized query tables or views are generally not visible in TIBCO Spotfire Information Designer

This article explains how to make materialized query tables or views visible in Information Designer by adding them to the setting in a data source template.

All

What table types should be retrieved/visible for a specific data source type in Information Services is controlled by the <table-types> setting in the data source template. You can edit data source templates using the TIBCO Spotfire Server configuration tool (for more information about that, see "Adding a data source template with the configuration tool" in the references below). The changes will take effect after the next TIBCO Spotfire Server (service) restart.  

For Materialized query tables, modify the <table-types> setting in the data source template as shown below.

From:

<table-types>TABLE, VIEW, NICKNAME</table-types>

To:

<table-types>TABLE, VIEW, NICKNAME, MATERIALIZED QUERY TABLE</table-types>

Note: The above example is taken from the IBM DB2 data source template which is included in the TIBCO Spotfire Server installation. 


For Materialized views, modify the <table-types> setting in the data source template as shown below.

From:

<table-types>TABLE,VIEW</table-types>

To:

<table-types>TABLE,VIEW,MATERIALIZED VIEW</table-types>

Note: The above example is taken from the PostgreSQL data source template which is included in the TIBCO Spotfire Server installation. By default, the value of the table‐types setting is 'TABLE, VIEW'.

• XML settings for data source templates
  • https://docs.tibco.com/pub/spotfire_server/11.4.0/doc/html/TIB_sfire_server_tsas_admin_help/server/topics/xml_settings_for_data_source_templates.html
• Adding a data source template with the configuration tool
  • https://docs.tibco.com/pub/spotfire_server/11.4.0/doc/html/TIB_sfire_server_tsas_admin_help/server/topics/adding_a_data_source_template_with_the_configuration_tool.html