How to enable Oracle synonyms in Spotfire Information Link data sources

Product:TIBCO Spotfire Server
Versions:All Versions

Summary:
How to enable Oracle synonyms for Information Link data sources in Spotfire Information Designer.

Details:
Synonyms are disabled by default in the Information Designer data source template for Oracle Thin JDBC driver. You must edit the data source template to enable synonyms.

Resolution:
Using the TIBCO Spotfire Server configuration tool, edit the Oracle data source template.

Find this row:
 

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

Replace it with all of the following:
 

<table-types>TABLE, VIEW, SYNONYM</table-types>
<connection-properties>
  <connection-property>
    <key>includeSynonyms</key>
    <value>true</value>
  </connection-property>
</connection-properties>

Save the configuration to database, then restart TIBCO Spotfire Server as a service.

Note: You must edit and re-save any existing data sources in Information Designer for changes to the template to take effect. Refer to article 000028924 for more information.