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

Date Posted: 2019-01-16
Product: TIBCO Spotfire®

Problem:

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

Solution:

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.

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

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