How to enable Oracle synonyms in Spotfire Information Link data sources

How to enable Oracle synonyms in Spotfire Information Link data sources

book

Article ID: KB0081002

calendar_today

Updated On:

Products Versions
Spotfire Server All Versions

Description

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.

Issue/Introduction

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

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.