Installing JDBC Driver

Use these steps to download the JDBC driver, install it, and create connection to the model store.

  1. On the Spectrum™ Technology Platform welcome page, click Platform Client Tools. In the options on the right pane, expand the Driver cascading menu, and click the Download Jar button for JDBC Driver.
  2. Save the modelstore-jdbc.jar file in the default browser directory.
    Note: You do not need to restart the server.
Once the JDBC driver is installed, use these 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.modelstore.driver.modelstoreDriver
  4. Connection String Template = jdbc:spectrum://${host}:${port}/${modelstore}.
    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 model store you wish to access in {modelstore}.
    Note: Default for {port} is 32750.

You can now connect to any desired model store.