How to install external modules in the Talend solutions with the Data Quality option

Overview

Because of license restrictions from third-party vendors, a number of drivers (Jar files) are not provided by default by Talend. Those drivers therefore need to be installed manually in order for the associated databases to be accessible within your Talend product or for some connectors to be fully operational.


Environment

This article applies to Talend solutions with the Data Quality option up to version 5.3.

From version 5.4, the relevant procedure to install external modules is the following: How to install external modules in the Talend products in the Talend Help Center.


Description

You are getting a message about "missing JDBC drivers" and an error icon when creating a new database connection, or when unfolding your existing database connections.

error.png

TOP_Dialog.jpg

 

For instance, the drivers of the following databases are not provided: IBM DB2 zOS, IBM DB2, Informix, and Sybase.

 

Resolution

In order to profile these databases via JDBC from TOS for DQ Studio, you will have to install the Jars manually following these steps:

  1. Copy these jars to STUDIO_INSTALLATION_DIR/lib/java:

    • Oracle: ojdbc5.jar
    • IBM DB2 zOS and DB2:db2jcc.jar,db2jcc_license_cu.jar,db2jcc_license_cisuz.jar
    • Informix: ifxjdbc.jar
    • Sybase: jconn3.jar

    But in the subscription versions of TDQ Studio, there is an alternative: to install these Jars from the Modules view:

    moduleViewer.png
  2. In the Preferences of the Studio (Window > Preferences > Talend > Data Explorer > JDBC Drivers), add each of these Jar files into the class path.

    The example below describes how to add and configure the Oracle driver.

    Click the Add button, then select the Oracle JDBC jar: ojdbc5.jar.


    DQ_add_drivers.jpg

    Click List Drivers in order to list the appropriate driver: oracle.jdbc.driver.OracleDriver.


    DQ_add_drivers_after.jpg


    Click OK, then click OK again to close the [Preferences] dialog box. The driver is now installed.

Version history
Revision #:
5 of 5
Last update:
‎06-27-2017 04:03 PM
Updated by:
 
Labels (2)
Tags (1)