Spotfire Server: How to make materialized query tables or views visible in Spotfire Information Designer

Summary:
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.

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

Resolution:
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 Spotfire Server Configuration Tool (for more information about this process, see "Adding a data source template with the configuration tool" in the Spotfire Server Administration Guide). The changes will take effect after the next Spotfire Server service restart.  
 

For Materialized views in PostgreSQL, 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 Spotfire Server installation. By default, the value of the <table-types> setting is 'TABLE, VIEW'.

For Materialized query tables in IBM DB2, 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 Spotfire Server installation.