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.
Did this page help you?
If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!
