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