Data ServicesAdd a JDBC Driver to Spectrum

Java Database Connectivity (JDBC) API drivers for Oracle 19c and 12c, PostgreSQL 14 for Linux, and PostgreSQL 14 for Windows Server, are installed with Spectrum. To enable Spectrum to connect to another type of database, you must install a third-party JDBC driver for that type of database on the computer where Spectrum is installed. A JDBC driver is not required for File data services or HTTP data services.

To add a third-party JDBC driver to Spectrum, use this procedure.

  1. Download a JDBC driver for your type of database from the database company's website or another source.
  2. Review the documentation for the JDBC driver that you downloaded to obtain the package and class name for the driver.
  3. Copy the driver JAR file to the following location. <SPECTRUM_HOME> represents the folder on the Spectrum Application Server in which the Spectrum application is installed.
    <SPECTRUM_HOME>\product\endorsed
  4. Open the following file in a text editor:
    <SPECTRUM_HOME>\product\conf\jdbc.properties
    1. Add the following line to the file. <PackageName> and <ClassName> represent the package name and class name for the driver that you downloaded.
      external.jdbc.drivers=<PackageName>.<ClassName>

      Tip: If you are using more than one third-party JDBC driver, separate the entries with a colon:
      external.jdbc.drivers=<PackageName1>.<ClassName1>:<PackageName2>.<ClassName2>

      Example

      In the following example, two third-party JDBC drivers are used.

      external.jdbc.drivers=com.mysql.jdbc.Driver:com.microsoft.sqlserver.jdbc.SQLServerDriver

    2. Save and close the file.
  5. In the Windows Server Control Panel, open the Services console and restart the Loftware Spectrum service.

A Data Service AdministratorClosed A local administrator who creates and configures data services for use by Designers who configure Database data sources and Alternate data sources. can now create JDBC data services that use this JDBC driver.