Importing a JDBC Driver - data_integration_1 - discovery - spectrum_platform - 23.1

Spectrum Discovery Guide

Product type
Software
Portfolio
Verify
Product family
Spectrum
Product
Spectrum > Discovery
Version
23.1
Language
English
Product name
Spectrum Discovery
Title
Spectrum Discovery Guide
First publish date
2007
Last updated
2024-02-07
Published on
2024-02-07T17:21:58.768552

If Spectrum Technology Platform does not have a driver for your database, you can add a JDBC driver to access data in the database.

Spectrum Technology Platform can access data from any database using a JDBC driver. Drivers for SQL, Oracle, PostgreSQL and other types of databases are provided with Spectrum Data Federation. If a driver for your database is not included with Spectrum Technology Platform, use this procedure to import a JDBC driver by copying driver files to the server. After you complete this procedure the imported driver will be available to define a JDBC database connection in Spectrum Management Console.

Note: For a cluster configuration, you must perform this procedure for each server in the cluster.
Note: This procedure works for JDBC 4.x drivers. If the driver you want to add uses an older version of JDBC you must add the driver manually in Spectrum Management Console. For more information, see Manually Adding a JDBC Driver.
  1. In a temporary location, put all the JDBC driver files for the database into a folder named:

    Name.jdbc

    Where Name is any name you want. The folder name must end with .jdbc.

  2. In the folder SpectrumDirectory\server create a folder named drivers if not already present.
  3. Copy the Name.jdbc folder that you created in step 1 to the SpectrumDirectory\server\drivers folder.
  4. To verify that the driver was successfully imported, log in to Spectrum Management Console and go to System > Drivers. The driver should be listed.

    If the driver is not listed, open the System Log in Spectrum Management Console and look for errors related to deploying JDBC drivers.