> #### How to add a JDBC driver

> This procedure assumes you are creating a new JDBC data source, and you need to install a new driver because the driver that the database requires is not available in the list of drivers.

> 1 | In New JDBC Data Source Profile, shown in Figure 2-16, choose Manage Drivers.

> Figure 2-16 New JDBC Data Source Profile

> 2 | In Manage JDBC Drivers, choose Add to install the JAR file that contains the driver.

> 3 | Navigate to the directory that contains the JAR file. Select the JAR file and choose Open. Manage JDBC Drivers shows the new JAR file.

> 4 | Choose Drivers to see the list of installed drivers, as shown in Figure 2-17.

> Figure 2-17 Viewing JDBC driver classes

> 5 | Optionally, set the properties for a driver, using the following steps:

> 1 | Select the new driver, then choose Edit.

> 2 | In Edit JDBC Driver, specify the following information:

> | In Driver Display Name, type a user-friendly name that describes the driver. This name appears in parenthesis next to the driver class name in Driver Class on New JDBC Data Source Profile.

> | In URL Template, type the URL format that the driver requires. This URL format appears in Driver URL on New JDBC Data Source Profile.

> Figure 2-18 shows an example of properties specified for a MySQL JDBC driver.

> Figure 2-18 Properties specified for a JDBC driver

> 3 | Choose OK. Manage JDBC Driver displays the new display name and URL template syntax suggestion.

> 6 | In New JDBC Data Source Profile, specify the connection properties to connect to the JDBC data source. The Driver Class list displays the installed driver.

(c) Copyright Actuate Corporation 2013