Installing and Maintaining Custom JDBC Drivers

Installing Data Studio creates and initially populates the drivers directory in Workbench for Eclipse installation location. It contains a set of several JDBC drivers providing connectivity to SQL Server, Sybase, Derby, Access, and Excel. If the user performing the installation accepts the Oracle License Agreement, an Oracle JDBC driver is also installed in the same directory. See Enable DB2 JDBC Repository and Database Access Support for the steps for adding the IBM DB2 JDBC driver support.

Still, a user might want to install additional JDBC drivers for other databases, such as Teradata or MySQL, or to use a different version of these already installed drivers. Also, if a user works with multiple installations of Data Studio, keeping the modified sets of drivers consistent between different installations can be cumbersome.

Data Studio allows users to install such custom JDBC drivers into any directory. In that case, the user needs to create an environment variable TOPAZ_DRIVERS pointing to the JDBC drivers location, restart the communication manager and the Local execution server (see Shutting-Down-or-Restarting-Local-Execution-Server-and-Local-Communication-Manager) and all these drivers will be available for Data Studio applications.

Important

  • See the task Configure the Driver for details on additional steps that might be required to make the newly added drivers usable.
  • If different versions of the same driver are installed at <Topaz Installation directory>\Drivers and %TOPAZ_DRIVERS% locations, the former takes precedence.


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*