Enable faster retrieval of schemas from Oracle data sources in Information Designer
Article ID: KB0079650
Updated On:
| Products | Versions |
|---|---|
| Spotfire Server | 7.5 and higher |
Description
Follow the instructions here to speed up retrieval of available schemas from Oracle data sources in Information Designer. This can be useful if you experience a long delay when e.g. expanding a data source in Information Designer.
Note that the result of this will be that *all* schemas are listed, regardless of whether they are accessible or not.
Resolution
1. If needed, export the server configuration file from the Spotfire database. Use the graphical configuration tool or the command line configuration tool as shown below:
$ cd <TIBCO Spotfire Server>/tomcat/bin
$ config export-config
A file called configuration.xml will be created in the current directory
2. Open configuration.xml in a text editor and locate the "<oracle>" tag
3. Add the tag <use-faster-schema-listing>true</use-faster-schema-listing> inside <oracle> and </oracle>:
<configuration ...> ... <information-services> ... <jdbc> ... <oracle> ... <use-faster-schema-listing>true</use-faster-schema-listing> ... </oracle> ... </jdbc> ... </information-services> ... </configuration>
4. Save configuration.xml
5. Import the configuration.xml file back into the Spotfire server database. Example using the command line:
$ config import-config -c="Enabled oracle use-faster-schema-listing"
6. Restart TIBCO Spotfire Server
Note: This applies only to data sources that use the Oracle Thin driver (oracle.jdbc.OracleDriver) and not Oracle DataDirect (tibcosoftwareinc.jdbc.oracle.OracleDriver).
Issue/Introduction
Configuration option when you experience poor performance when expanding Oracle data sources in Spotfire Information Desgner.
Additional Information
Keywords: slow , poor performance , metadata , meta data , tables, data source, datasource, datasources
Feedback
Yes
No
Powered by
