Shop

Your Notifications (0)

There are currently no notifications. You're all set!

Demos Trials
Knowledgebase
ChemDraw and ChemOffice+ Products Signals Notebook E-Notebook and ChemBioOffice Enterprise Spotfire and Signals Spotfire Products Image Artist Spectrus, Percepta, Katalyst, Luminata and more
Downloads
Downloads
Community
Ideas Portal Product Basics
About Support
Legal Resources Support and Maintenance Plans Product Life Cycle Support News
Contact Support

Spotfire Server: JDBC driver jar file location for Information Services data sources

Kisiel, Pawel
  • Updated
Problem:

This article explains where JDBC driver jar files should be placed for Spotfire Server's Information Services.

 

Solution:

To be able to access data from a JDBC-compliant data source with Information Services, you must install the appropriate JDBC driver on the computer that is running Spotfire Server.

Note: In a clustered server deployment, you must install the driver on all computers that run Spotfire Server in the cluster.

Installing JDBC drivers:

If you have administrator access to the computer running the Spotfire Server, you can log in to the computer and install JDBC drivers manually.

Procedure:

  1. Download the database JDBC driver.

  2. Place the driver in the following directory: 

    <installation dir>/tomcat/custom-ext-informationservices/

     
    Note: This is the recommended directory for most JDBC drivers. There might be some JDBC drivers that you must install to a different directory. For information on some known exceptions, see Spotfire JDBC Data Access Connectivity Details on the Community.
     
    Note: If you are using Oracle as the Spotfire database and you want to access data with information services (regardless of whether you want to access Oracle data), you must add the same Oracle jar file in both directories <installation dir>/tomcat/custom-ext and <installation dir>/tomcat/custom-ext-informationservices.
  3. Restart the Information Services process.
 

Important: Upgrading to Spotfire version 12.1 and later

In versions 12.1 and later, Information Services runs in its own subprocess, and uses the new default extensions directory <installation dir>/tomcat/custom-ext-informationservices for JDBC drivers. When you upgrade from an earlier version, all your JDBC drivers remain in the previous default directory, <installation dir>/tomcat/custom-ext, and the configuration property information-services.external-process.use-legacy-extensions is set to true. This way, Information Services can also use drivers from the custom-ext folder.

After upgrading, it is recommended that you manually move Information Services-related JDBC drivers to the custom-ext-informationservices directory. After you have moved your drivers, set the configuration property information-services.external-process.use-legacy-extensions to false.

What to do next

To connect to an external data source, you must also add and/or enable a data source template that matches the database and the specific database driver.

Note: The database connection URL, used by the server to connect to the database, may differ for different database drivers; see Database drivers and database connection URLs.

 

References:

Included drivers and data source templates for Information Services

Database drivers and database connection URLs

Migrating from TIBCO-branded DataDirect

Related articles

Comments

0 comments

Article is closed for comments.