Manually Adding 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
Topic type
How Do I
Overview
Reference
First publish date
2007
ft:lastEdition
2024-02-07
ft:lastPublication
2024-02-07T17:21:58.768552

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.

In this procedure you will add JDBC driver files to the server then manually define the connection string and connection properties. Before you begin, be sure that you understand the connection string format and properties required by the driver. You must define these accurately in order for the driver to function. You can typically find information about a driver's connection string and properties from the driver provider's website.

Note: We recommend that you use this procedure only when adding a JDBC driver that uses JDBC 1.x, 2.x, or 3.x. If the driver uses JDBC 4.x, we recommend that you use the import method to add the driver. For more information, see Importing a JDBC Driver.
  1. Open Spectrum Management Console.
  2. Go to System > Drivers.
  3. Click the Add button .
  4. In the Name field, enter a name for the driver. The name can be anything you choose.
  5. In the JDBC driver class name field, enter the Java class name of the driver. You can typically find the class name in your JDBC driver's documentation.

    For example, to use the Microsoft JDBC driver, you might enter the following:

    com.microsoft.sqlserver.jdbc.SQLServerDriver

  6. In the Connection string template field, enter the JDBC connection URL to use to connect to the database, including any properties you want to set in the connection string. Different database vendors use different connection strings so check your database's documentation for more information about the connection string.

    If the driver will be used by more than one database connection, consider using property tokens in the connection string instead of hard-coding property values that may be different for each connection. For example, if you want to have some connections use encryption and others not, you may want to define a property token for the encryption property.

    To use a property token in the connection string, use this syntax:

    ${PropertyToken}

    Any property tokens you include in the connection string template will be required fields when defining a database connection.

    Note: Use the property token name ${password} for the property that will contain the database password. By using this token name, the password will be masked in the field in Spectrum Management Console and will be encrypted in the database.

    For example, this connection string for SQL contains property tokens for host, port, instance, and encryption:

    jdbc:sqlserver://${host}:${port};databaseName=${instance};encrypt=${encryption};‚ÄčTrustServerCertificate=true

    These tokens are required fields when defining a database connection that uses this driver.

  7. If there are properties that you want to make optional for database connections, define them in the Connection Properties section.
    1. In the Connection properties section, click the Add button .
    2. In the Label field, enter a user-friendly description of the property. The label you enter here is used as the field label in the connections window when creating a connection using this driver.
    3. In the Property token field, enter the token for the optional property. See the database driver's documentation for the properties supported by the driver.
    Note: Use the property token name password for the property that will contain the database password. By using this token name, the password will be masked in the field in Spectrum Management Console and will be encrypted in the database.
    For example, if you want to make encryption optional for database connections that use this driver, you could define the encryption property like this:
    Label Property Token
    Use SSL useSSL

    When a database connection uses this driver, the encryption property would be displayed as an optional property in the database connection.

  8. Log in to the server running Spectrum Technology Platform and place the database driver file in a folder on the server. The location does not matter.
  9. In the Driver files section, click the Add button .
  10. In the File path field, enter the path to the database driver file on the server.
  11. Click Save.