JDBC drivers for unsupported sources

Use the following procedures to extend the data source to use a driver for a database that is not provided in the base system.

Install a driver on a MID Server

You can install a new JDBC driver JAR file to a MID server to access database formats that are not supported by default.

Before you begin

Role required: agent_admin

Procedure

  1. Navigate to MID Server > JAR Files.
  2. Click New.
  3. Complete the following fields:
    • Name: A unique and descriptive name for identifying the file in the instance.
    • Version: A version number for the file, if one is available.
    • Source: Location of the JAR file for reference purposes. Source information is not used by the system.
    • Description: Short description of the JAR file and its purpose in the instance.
  4. Click the paper clip icon in the banner and attach the JAR file to the record.
    Attach a file
  5. Click Submit.
  6. Restart the MID Server service.

    The platform makes the JAR file available to any MID Server configured to communicate with the instance.

Add a new JDBC format choice

Extend the available JDBC driver options by creating a new choice list entry to specify the JDBC driver Java package name.

Before you begin

Role required: import_admin

About this task

Add a new choice list entry for the new database to the Format field in the sys_data_source table.

Procedure

  1. Navigate to System Import Sets > Administration > Data Sources.
  2. Click New.
  3. In the Data Sources form, right-click the Format field label, and select Show Choice List from the pop-up menu.
    JDBC Data Source
  4. Click New in the list of choices.
  5. Provide the following values to create the new database choice. Look at the existing drivers for examples.
    • Table: sys_data_source
    • Label: Database name that appears as an option in the Format choice list, for example: TeraData.
    • Value: Package name and class of the driver. For example, the value for TeraData is com.ncr.teradata.TeraDriver.
    • Dependent value: JDBC
    JDBC Choice List
  6. Click Submit.

    The new data source now appears in the list of available JDBC formats.

Add Sybase or DB2 JDBC format choices

Extend the available JDBC driver options by activating the Sybase or DB2 choices.

Before you begin

Roles required: admin

Important: To use Sybase or DB2 JDBC drivers, you must manually install the driver JAR file on a MID server. Refer to KB0551236 for more information.

About this task

Activate the Sybase or DB2 JDBC drivers to connect with those database formats through a MID server. This procedure assumes you are using the following Sybase or DB2 drivers:
Table 1. Drivers
Format Driver Driver class
Sybase jconnect-jdbc com.sybase.jdbc3.jdbc.SybDriver
DB2 db2jcc com.ibm.db2.jcc.DB2Driver

If you are using a different implementation of the Sybase or DB2 driver, you must modify the choice Value to use the driver class from your driver implementation.

Procedure

  1. Navigate to System Import Sets > Administration > Data Sources.
  2. Click New.
  3. In the Type field, select JDBC.
  4. Right-click the Format field label, and select Configure Choices from the pop-up menu.
  5. Move the Sybase or DB2 Universal choices from the Available column to the Selected column.
  6. Click Save.

    The new data source now appears in the list of available JDBC formats.

Create a new data source

Add a new JDBC data source by defining a data source record.

Before you begin

Role required: import_admin

Procedure

  1. Navigate to System Import Sets > Administration > Data Sources and click New.
  2. In the Data Source form, select JDBC from the list in the Type field.
  3. Select the new data source from the choice list in the Format field.
    JDBC Data Source
  4. Configure the form and add the Connection URL field.
  5. Provide the connection URL to the JDBC data source, and then click Submit.

    No other connection information is required.

    JDBC Data Source