Working with Databases - Getting Started with Talend Open Studio for Data Integration - page 90

4. We now need to configure the database connection.
You may need to get database connection details from your database
administrator if you are working with an existing database. Note that,
while broadly similar, the connection parameters that are required do
vary depending upon which database system you use, so seek some
expert advice on the specifics of your database if you are not sure.
5. The Studio has built-in database connection drivers for most of the common
database systems (and some not so common). It can also use generic ODBC
or JDBC drivers for those database systems that support these protocols.
We are using MySQL, so in the DB Type drop-down menu, find and select
MySQL . Selecting this will configure some default parameters, such as the
Db Version field and the String of Connection fields. Note that Db Version
can be changed wherever appropriate.
6. Enter the value for the Login and Password fields.
7. Enter the value for the Server field. This will be the hostname or IP address
of your database server.
8. Enter the Port details.
9. Enter the Database name to which you want to connect.
10. Once all of the values have been entered, click on the Check button to
test the connection. If all has been set up correctly, you will get the Check
Connection pop-up window saying that the connection has been successful.
If not, go back and check the values that you have configured.