The Talend Open Studio for ESB package provides JDBC drivers only for the Derby database. To use the MySQL database, its corresponding JDBC driver need to be explicitly installed into the container before installing the datasource. You can install the MySQL driver from a public Maven repository.
In a Talend Runtime container, run the following command (change the database version numbers if applicable):
For more information on how to install the H2, Oracle, DB2, SQLServer and PostgreSQL JDBC drivers into a container, see the section on datasource installation in the Talend ESB Infrastructure Services Configuration Guide.