Enable faster retrieval of schemas from Oracle data sources in Information Designer

Enable faster retrieval of schemas from Oracle data sources in Information Designer

book

Article ID: KB0079650

calendar_today

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.

Issue/Introduction

Configuration option when you experience poor performance when expanding Oracle data sources in Spotfire Information Desgner.

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

Additional Information

Keywords: slow , poor performance , metadata , meta data , tables, data source, datasource, datasources