Procedure
-
Double-click the tDBConnection_1 component to open its Basic settings view.
-
With the Property Type set to Built-In, specify the connection details in the
relevant fields, including:
-
the host name or IP address of your database server
-
the listening port number
-
the database name
-
the user name and password for your database authentication.
If you have stored your connection details under the Metadata node in the Repository tree view, you can simply drop your centralized metadata item onto the tMysqlConnection component. For information on how to centralize a database connection, see the chapter on managing metadata of the Talend Studio User Guide. -
- Select the Use or register a shared DB Connection check box so that the database connection open by this component can be shared across different Jobs. Then, enter a name for the shared connection between double quotes in the Shared DB Connection Name field, shared_mysql_connection in this example.