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

Created
October 08, 2021 23:24

Date Posted: 2018-08-29
Product: TIBCO Spotfire®

Problem:

How to enable Oracle synonyms in Spotfire Information Link data sources

Solution:

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. 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 https://support.revvitysignals.com/hc/en-us/articles/4408237061908-Modifications-to-a-data-source-template-not-reflected-in-data-source for more information.

Related articles