Skip to main content Skip to complementary content

Installing database drivers in your Web application server

If you are not using the embedded H2 database with Talend Administration Center or Talend Activity Monitoring Console, you must install the driver for the database to use in your Web application server.

For more information regarding the databases compatible with Talend Administration Center and Talend Activity Monitoring Console, see Compatible databases.

For more information regarding the databases compatible with Talend Administration Center, see Compatible databases.

Procedure

  1. Stop your Web application server.
  2. In case you use Apache Tomcat, clean the <apache-tomcat>\work\Catalina\localhost folder.
  3. Make sure that the driver for the database you want to use does not exist in any of the following folders. If the driver already exists in one of these folders, skip the next step.
    Web application Server used Folders to check

    Apache Tomcat

    <TomcatPath>\webapps\org.talend.administrator\WEB-INF\lib

  4. Download the correct database driver(s) from the official provider website, according to the version of the JVM you use to run your Web application server and the version of the database you want to use.
    In case you use Oracle, use a copy of the ojdbcX.jar file from your Oracle installation.
    Note that those drivers are specific and that you should only download the one(s) that you need.
    Database used Driver to download
    Azure SQL / SQL Server https://docs.microsoft.com/en-us/sql/connect/jdbc/overview-of-the-jdbc-driver
    Information noteNote: For 7.3, it is recommended to use MSSQL official driver instead of jTDS.
    MySQL http://dev.mysql.com/downloads/connector/j/
    Oracle http://www.oracle.com/technetwork/database/features/jdbc/index-091264.html
    PostgreSQL http://jdbc.postgresql.org/download.html
    MariaDB https://downloads.mariadb.org/connector-java/
  5. Place the driver(s) you need in the right folder:
    • In <TomcatPath>\webapps\org.talend.administrator\WEB-INF\lib for Apache Tomcat.
  6. Restart your Web application server.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!