To connect to the Oracle Spotfire database in Spotfire 14, please follow the necessary steps.

1. Oracle template is not available by default in the Spotfire configuration tool to create a bootstrap on Spotfire 14.0.x version. PFA screenshot.

2. To use the Oracle driver template, you need to download the ojdbc*.jar file from the Oracle vendor and place the "ojdbc11.jar" Oracle driver at path: <installation dir>/tomcat/custom-ext.

e.g. C:\spotfire\spotfireserver\14.0.0\tomcat\custom-ext, now close the configuration tool and re-launch it.
3. Now, the Oracle driver template will be visible to you in the Configuration tool. PFA screenshot.

4. Now, choose the driver template and connect to the Oracle Spotfire database to create a bootstrap file.
5. The minimum required configuration change is to update the connection URL/connection string and the driver class setting.

Spotfire database connection

• Change the setting driver class to the driver class of new JDBC driver.
• Change the setting database-url, according to the format required for new JDBC driver.

Note: 

• If you want to install the Data Direct driver on version 14.0, it is not supported and you would have to migrate to vendor-specific/native JDBC drivers.
• After installing your new JDBC drivers, you might prefer to manually change your configuration to use the drivers, before you upgrade Spotfire.

• https://docs.tibco.com/pub/spotfire_server/14.0.1/doc/html/TIB_sfire_server_tsas_admin_help/server/topics/installing_the_oracle_database_driver.html

• https://docs.tibco.com/pub/spotfire_server/14.0.1/doc/html/TIB_sfire_server_tsas_admin_help/server/topics/migrating_data_direct_drivers.html

• https://www.oracle.com/in/database/technologies/appdev/jdbc-downloads.html