Installing JDBC Driver for an External Application

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

  1. In the Metadata Insights web UI, click on the admin dropdown in the header.
  2. Click on Download Metadata Insights 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 Metadata Insights 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.