If you are not using the MySQL or embedded H2 database with Talend Administration Center, you must install the driver for the database to use in your Web application server.
For more information about the databases compatible with Talend Administration Center, see Compatible databases.
Procedure
- Stop your Web application server.
- If you use Apache Tomcat, clean the <apache-tomcat>\work\Catalina\localhost folder.
-
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
-
Download the correct database drivers 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.
If 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 ones 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 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/ -
Place the drivers you need in the right folder:
- In <TomcatPath>\webapps\org.talend.administrator\WEB-INF\lib for Apache Tomcat.
- Restart your Web application server.