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.
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.
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.
For instance, the drivers of the following databases are not provided: IBM DB2 zOS, IBM DB2, Informix, and Sybase.
In order to profile these databases via JDBC from TOS for DQ Studio, you will have to install the Jars manually following these steps:
Copy these jars to STUDIO_INSTALLATION_DIR/lib/java:
But in the subscription versions of TDQ Studio, there is an alternative: to install these Jars from the Modules view:
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.
Click List Drivers in order to list the appropriate driver: oracle.jdbc.driver.OracleDriver.
Click OK, then click OK again to close the [Preferences] dialog box. The driver is now installed.