Installing JDBC Driver for an External Application

To install the JDBC driver in order to use the with your external application, the sdf-jdbc.jar needs to be installed.

  1. In the web UI, click on the admin dropdown in the header.
  2. Click on Download JDBC Driver.
  3. Save the sdf-jdbc.jar file in the default browser directory.
    Note: You do not need to restart the server.
Once the JDBC driver is installed, use the below details to connect to the Spectrum™ server using a simple code or any application:
  1. Spectrum™ username
  2. Password to authenticate the Spectrum™ username
  3. JDBC Driver Class Name = com.pb.spectrum.sdf.driver.SDFDriver
  4. Connection String Template = jdbc:spectrum://${host}:${port}/${virtualDataSource}.

    Fill in the server IP or machine name in place of {host}, the port for the in {port}, and the name of the Virtual Data Source you wish to access in {virtualDataSource}.

You can now connect to any desired Virtual Data Source.