Registering a JDBC Driver
To connect to a database at design-time from within the Query Database task, you must first register the JDBC driver.
- Procedure
- Navigate to the Data Source Explorer tab.
- Right-click Database Connections and select
New... .
The Connection Profile pane displays.
- Select the driver from the list of Connection Profile Types and click
Next.
The Specify and Driver and Connection Details pane displays.
- Click the
New Driver Definition icon location to the right of the Drivers drop-down list.
The New Driver Definition dialog box displays.
- Select the JDBC Driver in the Available driver templates list of the Name/Type tab.
- Navigate to the
Jar List tab.
The jar file for the selected database is listed in the list of driver files..
- Select the JAR file (generated according to the selected JDBC driver) and click Remove JAR/Zip.
- Click Add JAR/Zip.
- In the Select the file dialog box select the driver appropriate for your database, and click Open.
- Click OK.
Result
The database is now registered and is ready to be used within the Query Database task.