Creating a database connection in Talend Management Console

Create a custom connection to your MySQL database in Talend Management Console to use it in your task.

1. Open Talend Management Console and go to the MANAGEMENT tab, then click CONNECTIONS in the relevant workspace.

   

2. Click ADD CONNECTION.
3. In the Application field, select Custom connections and enter mysql in Application Name.
4. Enter a Name for your connection, Movie catalog for example.

   

5. Click ADD PARAMETER six times to create your parameters, and configure them as follows:

   Key	Value
   Database	Name of your MySQL database, moviecatalog for example.
   Server	Host for your MySQL database
   Login	Your MySQL user name
   AdditionalParams	noDatetimeStringSync=true
   Password	Your MySQL password. Click the lock next to the value to mask it.
   Port	Port for your MySQL database

6. Click SAVE.