How to enable Oracle synonyms in Spotfire Information Link data sources
Article ID: KB0081002
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:
Replace it with all of the following:
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.
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.
Feedback
Yes
No
Powered by
